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

10. Basic Test 10.1 sysbench benchmark 10.1.1 Local installation download zip file

Https:// codeload.github.com/akopytov/sysbench/zip/1.0

Install dependency package yum install-y automake libtoolyum install-y mysql-devel execute installation # cd sysbench./autogen.sh. / configure makemake installsysbench-- version10.1.2 execute test

Prepare the test library

Create a sbtest library

Sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua-- mysql-host=192.168.56.16-- mysql-port=3306-- mysql-user=root-- mysql-password=Abc_123456-- oltp-tables-count=10-- oltp-table-size=100000 prepare execution test sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua-- mysql-host=192.168.99.131-- mysql-port=3306-- mysql-user=admin-- mysql-password=Abc_123456-- oltp-test -mode=complex-- threads=10-- time=300-- report-interval=10 run > > / home/mysysbench.log cleanup data sysbench/ usr/share/sysbench/tests/include/oltp_legacy/oltp.lua-- mysql-host=192.168.56.16-- mysql-port=3306-- mysql-user=root-- mysql-password=Abc_123456-- oltp-tables-count=10 cleanup10.2 tpcc-mysql stress test 10.2.1 preparation

Modify my.cnf configuration file

Vi / etc/my.cnf

Pxc_strict_mode=DISABLED

Modify the configuration file of a Haproxy

Server mysql_1 192.168.99.151:3306 check port 3306 weight 1 maxconn 2000server mysql_2 192.168.99.159:3306 check port 3306 weight 1 maxconn 2000server mysql_3 192.168.99.215:3306 check port 3306 weight 1 maxconn 2000

Restart Haproxy

Install dependent packages

Yum install-y gccyum install-y mysql-devel10.2.2 install tpcc-mysql

Download the compressed package

Https://codeload.github.com/Percona-Lab/tpcc-mysql/zip/ master

Perform installation

# src directory make of cd tpcc

Execute two files, create_table.sql and add_fkey_idx.sql

Perform data initialization

. / tpcc_load-h 192.168.99.131-d tpcc-u admin-p Abc_123456-w

Perform a stress test

. / tpcc_start-h 192.168.99.131-d tpcc- u admin-p Abc_123456-w 1-c 5-r 300-l 600-> tpcc-output-log

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.