Differences

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

--- test_mysql_server_performance_with_sysbench [19.03.2021 17:07] – 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. either from the package manager:
+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
-or from source:
+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..
 <code>
 apt-get install make automake libtool pkg-config libaio-dev libmysqlclient-dev libssl-dev
@@ Line 34: / Line 34: @@
 prepare everything for a read/write benchmark:
-  sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write prepare
+  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>