Stress Test - 壓力測試

Install)

• CentOS 6.9
• sysbench 1.0.19
• MySQL Client 5.1.73

yum install make automake libtool pkgconfig libaio-devel

# For MySQL support, replace with mariadb-devel on RHEL/CentOS 7
yum install mysql-devel openssl-devel

# For PostgreSQL support
yum install postgresql-devel

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

./autogen.sh
# Add --with-pgsql to build with PostgreSQL support
./configure --prefix=/opt/sysbench
make -j
make install

For MySQL)

mysql> create database sbtest;

/opt/sysbench/bin/sysbench oltp_read_write --debug=on --db-driver=mysql --mysql-user=fdc_mysql --mysql-password=fdc168 --mysql-host=10.4.1.24 --mysql-db=sbtest --mysql_storage_engine=innodb --table_size=1000000 --tables=2 --threads=4 --time=30 prepare

/opt/sysbench/bin/sysbench oltp_read_write --debug=on --db-driver=mysql --mysql-user=fdc_mysql --mysql-password=fdc168 --mysql-host=10.4.1.24 --mysql-db=sbtest --mysql_storage_engine=innodb --table_size=1000000 --tables=2 --threads=4 --time=30 run

/opt/sysbench/bin/sysbench oltp_read_write --debug=on --db-driver=mysql --mysql-user=fdc_mysql --mysql-password=fdc168 --mysql-host=10.4.1.24 --mysql-db=sbtest --mysql_storage_engine=innodb --table_size=1000000 --tables=2 --threads=4 --time=30 cleanup