Differences

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

--- test_mysql_server_performance_with_sysbench [19.03.2021 16:51] – created Pascal Suter
+++ test_mysql_server_performance_with_sysbench [19.03.2021 17:24] (current) – Pascal Suter
@@ Line 17: / Line 17: @@
 FLUSH PRIVILEGES;
 </code>
-leave the mysql prompt and install sysbench:
+leave the mysql prompt and install sysbench. most distributions come with it pre-packaged, so you can could simply install it from the package manager..
   apt-get install sysbench
-preare everything for a read/write benchmark:
+however, if you want to compare different systems which may have different distriutions or versions of distributions, you might get a more comparable result if you compile from source..
-  sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write prepare
+<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:
+  src/sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write prepare
 and finally run the benchmark:
-  sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write run
+  src/sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write run
 when you're done, clean up! login again with your mysql root account, then delete our user and database:
 <code mysql>