Mastering The Faster Web with PHP, MySQL, and JavaScript

SysBench

SysBench is another very popular open source benchmark testing tool. This tool not only allows you to test open source RDBMSs, but also your hardware (CPU, I/O, and so on).

To download, compile and install SysBench, please enter the following commands inside the Linux for PHP Docker container:

# cd /srv/www
# wget -O sysbench-0.4.12.14.tar.gz https://downloads.mysql.com/source/sysbench-0.4.12.14.tar.gz 
# tar -xvf sysbench-0.4.12.14.tar.gz 
# cd sysbench-0.4.12.14 
# ./configure 
# make 
# make install 

Now, enter the following command to create a table with 1 million rows as the test data into the database:

# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=test --mysql-user=root prepare 

Once the data has been loaded into the ...