Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use sysbench to test Mysql performance, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Sysbench can be used to test the performance of oracle,mysql,os, which is more convenient and practical. [@ more@] first install mysql 5, because mysql 4 does not support sysbench 0.4.8.

After installation, follow these steps to configure sysbench:

Tar zxvf sysbench-0.4.8.tar.gz

. / configure-- with-mysql-includes=/usr/local/mysql/include-- with-mysql-libs=/usr/local/mysql/lib & & make & & make install

If you run sysbench after installation, you will encounter the following error:

Sysbench: error while loading shared libraries: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory

Just run export LD_LIBRARY_PATH=/usr/local/mysql/lib.

Here are the statements to prepare the test, run the test, and end the test for sysbench

Thank you for reading this article carefully. I hope the article "how to use sysbench to test Mysql performance" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.