Difference between revisions of "Internet Offline: mysqlslap script"

From OnnoWiki
Jump to navigation Jump to search
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' &> 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 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 '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 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 '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 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 '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 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 '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 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 '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 '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'

Pranala Menarik