Internet Offline: mysqlslap script

Script mysqlslap-test.sh

rm -Rf hasil-mysqlslap-test.txt
touch hasil-mysqlslap-test.txt
echo 'default' >> hasil-mysqlslap-test.txt
mysqlslap -h localhost -u root -p123456 --auto-generate-sql >> hasil-mysqlslap-test.txt

echo 'number-of-queries=1' >> hasil-mysqlslap-test.txt
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100  --number-of-queries=1 >> hasil-mysqlslap-test.txt

echo 'number-of-queries=10000' >> hasil-mysqlslap-test.txt
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100  --number-of-queries=10000 >> hasil-mysqlslap-test.txt

echo 'number-of-queries=10000 --iterations=5' >> hasil-mysqlslap-test.txt 
mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100  --number-of-queries=10000 --iterations=5 >> hasil-mysqlslap-test.txt

echo 'umber-of-queries=1000 --engine=innodb'  >> hasil-mysqlslap-test.txt 
mysqlslap -h localhost -u root  -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb >> hasil-mysqlslap-test.txt

echo 'number-of-queries=1000 --engine=myisam' >> hasil-mysqlslap-test.txt 
mysqlslap -h localhost -u root  -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=myisam >> hasil-mysqlslap-test.txt
mv hasil-mysqlslap-test.txt hasil-mysqlslap-1CORE-512M.txt
shutdown -h now

Client

ssh onno@192.168.0.2 'echo 123456 | sudo -S /home/onno/mysqlslap-test.sh'

Pranala Menarik

• Internet Offline