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 ...