MySQL基准测试

了解基准测试,MySQL基准测试工具介绍及实例演示。
1.什么是基准测试




2.如何进行基准测试

3.基准测试实例


          

           

 

4.MySQL基准测试工具之mysqlslap

5.MySQL基准测试工具之sysbench
https://packagecloud.io/akopytov/sysbench
wget --content-disposition https://packagecloud.io/akopytov/sysbench/packages/el/7/sysbench-1.0.13-1.el7.centos.x86_64.rpm/download.rpm
yum localinstall sysbench-1.0.13-1.el7.centos.x86_64.rpm -y


https://github.com/akopytov/sysbench/





6.使用sysbench基准测试示例
# sysbench --test=cpu --cpu-max-prime=10000 run

# free -m
# df -h
# cd /tmp/
# sysbench --test=fileio --file-total-size=1G prepare

# sysbench --test=fileio help




# sysbench --test=fileio --threads=8 --file-total-size=1G --file-test-mode=rndrw --report-interval=1 run
MariaDB [(none)]> create database test_stress;
MariaDB [(none)]> grant all privileges on *.* to shijie@'localhost' indentified by '123456';
# rpm -ql sysbench
# cd /usr/share/sysbench/tests/include/