Difference between revisions of "Internet Offline: mysqlslap script"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 4: | Line 4: | ||
rm -Rf hasil-mysqlslap-test.txt | rm -Rf hasil-mysqlslap-test.txt | ||
touch hasil-mysqlslap-test.txt | touch hasil-mysqlslap-test.txt | ||
| − | echo 'default' | + | echo 'default' >> hasil-mysqlslap-test.txt |
| − | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql' | + | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql' >> hasil-mysqlslap-test.txt |
| − | echo 'number-of-queries=1' | + | echo '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=1' | + | echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql --concurrency=100 --number-of-queries=1' >> hasil-mysqlslap-test.txt |
| − | echo 'number-of-queries=10000' | + | echo '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' | + | echo 123456 | sudo -S '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' | + | echo '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=10000 --iterations=5' | + | 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 'umber-of-queries=1000 --engine=innodb' | + | echo 'umber-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=innodb' | + | 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 'number-of-queries=1000 --engine=myisam' | + | echo 'number-of-queries=1000 --engine=myisam' >> 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=myisam' >> hasil-mysqlslap-test.txt |
echo 123456 | sudo -S 'mv hasil-mysqlslap-test.txt hasil-mysqlslap-1CORE-512M.txt' | echo 123456 | sudo -S 'mv hasil-mysqlslap-test.txt hasil-mysqlslap-1CORE-512M.txt' | ||
echo 123456 | sudo -S 'shutdown -h now' | echo 123456 | sudo -S 'shutdown -h now' | ||
Revision as of 13:20, 18 December 2018
Script mysqlslap-test.sh
rm -Rf hasil-mysqlslap-test.txt touch hasil-mysqlslap-test.txt echo 'default' >> hasil-mysqlslap-test.txt echo 123456 | sudo -S 'mysqlslap -h localhost -u root -p123456 --auto-generate-sql' >> hasil-mysqlslap-test.txt echo '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=1' >> hasil-mysqlslap-test.txt echo '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' >> hasil-mysqlslap-test.txt echo '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=10000 --iterations=5' >> hasil-mysqlslap-test.txt echo 'umber-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=innodb' >> hasil-mysqlslap-test.txt echo 'number-of-queries=1000 --engine=myisam' >> 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 echo 123456 | sudo -S 'mv hasil-mysqlslap-test.txt hasil-mysqlslap-1CORE-512M.txt' echo 123456 | sudo -S 'shutdown -h now'