Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
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; | FLUSH PRIVILEGES; | ||
</ | </ | ||
- | leave the mysql prompt and install sysbench. | + | leave the mysql prompt and install sysbench. |
apt-get install sysbench | apt-get install sysbench | ||
- | or from source: | + | however, if you want to compare different systems which may have different distriutions |
< | < | ||
apt-get install make automake libtool pkg-config libaio-dev libmysqlclient-dev libssl-dev | 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: | prepare everything for a read/write benchmark: | ||
- | 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: | ||
- | 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: | when you're done, clean up! login again with your mysql root account, then delete our user and database: | ||
<code mysql> | <code mysql> |