Shulou(Shulou.com)06/01 Report--

1. Configure the epel source to install sysbench

Yum install-y sysbench

2. Initialize data

Sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua\-- mysql-host=192.168.1.226\-- mysql-port=3306\-- mysql-user=root\-- mysql-password=MySQL5.7\-- oltp-test-mode=complex\-- oltp-tables-count=10\-- oltp-table-size=100000\-- threads=10\-time=120\-- report-interval=10\-- db-driver=mysql prepare

3. Execute the test

Sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua\-- mysql-host=192.168.1.226\-- mysql-port=3306\-- mysql-user=root\-- mysql-password=MySQL5.7\-- oltp-test-mode=complex\-- oltp-tables-count=10\-- oltp-table-size=100000\-- threads=10\-time=120\-- db-driver=mysql\-- report-interval=10 run

4. Clean up the data

Sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua\-mysql-host=192.168.1.226\-mysql-port=3306\-mysql-user=root\-db-driver=mysql\-oltp-tables-count=10\-mysql-password=MySQL5.7 cleanup

Reference document: https://www.cnblogs.com/kismetv/p/7615738.html

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.