12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间:2024-12-25 09:57:36
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
1、配置 epel 源安装 sysbenchyum install -y sysbench2、初始化数据sysbench /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua \--mysql-host=192.168.1.226 \--m
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
1、配置 epel 源安装 sysbench
yum install -y sysbench
2、初始化数据
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、执行测试
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、清理数据
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
参考文档:https://www.cnblogs.com/kismetv/p/7615738.html
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19