Internet Offline: mysqlslap script: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) No edit summary |
Onnowpurbo (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
===Script mysqlslap-test.sh=== | |||
rm | rm -Rf hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql' | touch hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1' | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql' &> hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000' | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1' &> hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5' | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000' &> hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb' | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5' &> hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=myisam' | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb' &> hasil-mysqlslap-test.txt | ||
echo 123456 | sudo -S '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 | |||
echo 123456 | sudo -S 'shutdown -h now' | |||
Revision as of 05:56, 18 December 2018
Script mysqlslap-test.sh
rm -Rf hasil-mysqlslap-test.txt touch hasil-mysqlslap-test.txt echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql' &> hasil-mysqlslap-test.txt echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1' &> hasil-mysqlslap-test.txt echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000' &> hasil-mysqlslap-test.txt echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=10000 --iterations=5' &> hasil-mysqlslap-test.txt echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1000 --engine=innodb' &> hasil-mysqlslap-test.txt echo 123456 | sudo -S '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 echo 123456 | sudo -S 'shutdown -h now'
