Internet Offline: mysqlslap script
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
VBoxManage controlvm "Offline" acpipowerbutton sleep 30 VBoxManage modifyvm "Offline" --memory 512 VBoxManage modifyvm "Offline" --unplugcpu 3 VBoxManage modifyvm "Offline" --unplugcpu 2 VBoxManage modifyvm "Offline" --unplugcpu 1 VBoxManage startvm "Offline" sleep 110 ssh onno@192.168.0.2 'echo 123456 | sudo -S /home/onno/mysqlslap-1CORE-512M.sh'