test_mysql_server_performance_with_sysbench

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Last revisionBoth sides next revision
test_mysql_server_performance_with_sysbench [19.03.2021 16:51] – created Pascal Sutertest_mysql_server_performance_with_sysbench [19.03.2021 17:07] – Pascal Suter
Line 17: Line 17:
 FLUSH PRIVILEGES; FLUSH PRIVILEGES;
 </code> </code>
-leave the mysql prompt and install sysbench: +leave the mysql prompt and install sysbench. either from the package manager: 
   apt-get install sysbench    apt-get install sysbench 
-preare everything for a read/write benchmark: +or from source:  
 +<code> 
 +apt-get install make automake libtool pkg-config libaio-dev libmysqlclient-dev libssl-dev 
 +mkdir -p ~/tmp/sysbench 
 +cd ~/tmp/sysbench 
 +wget https://github.com/akopytov/sysbench/archive/refs/tags/1.0.20.tar.gz 
 +tar xvf 1.0.20.tar.gz sysbench-1.0.20/ 
 +cd sysbench-1.0.20/ 
 +./autogen.sh  
 +./configure  
 +make -j  
 +</code> 
 +optionally install it on the system with ''make install'' if you want to.. or just run it from ''~/tmp/sysbench/sysbench-1.0.20/src/sysbench'' 
 + 
 +prepare everything for a read/write benchmark: 
   sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write prepare   sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write prepare
 and finally run the benchmark:  and finally run the benchmark: 
  • test_mysql_server_performance_with_sysbench.txt
  • Last modified: 19.03.2021 17:24
  • by Pascal Suter