Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
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; | FLUSH PRIVILEGES; | ||
</ | </ | ||
- | leave the mysql prompt and install sysbench: | + | leave the mysql prompt and install sysbench. most distributions come with it pre-packaged, |
apt-get install sysbench | apt-get install sysbench | ||
- | preare | + | however, if you want to compare different systems which may have different distriutions or versions of distributions, |
- | sysbench --mysql-host=localhost --mysql-user=sysbench --mysql-password=MySYSBENCHsecret --mysql-db=sysbench oltp_read_write prepare | + | < |
+ | apt-get install make automake libtool pkg-config libaio-dev libmysqlclient-dev libssl-dev | ||
+ | mkdir -p ~/ | ||
+ | cd ~/ | ||
+ | wget https:// | ||
+ | tar xvf 1.0.20.tar.gz sysbench-1.0.20/ | ||
+ | cd sysbench-1.0.20/ | ||
+ | ./ | ||
+ | ./configure | ||
+ | make -j | ||
+ | </ | ||
+ | optionally install it on the system with '' | ||
+ | |||
+ | 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> |