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

Mysqlslap

Description of common parameters

-auto-generate-sql automatically generates sql scripts for testing-auto-generate-sql-add-autoincrement adds self-incrementing ID-auto-generate-sql-load-type to the generated table to specify the type of query used in the test-amount of data generated when auto-generate-sql-write-number formulates initialization data-number of concurrent threads specified by concurrency-engine specifies the storage engine for the table to be tested Comma separated multiple-no-drop does not clean test data (generally not set)-iterations specifies the number of test runs-number-of-queries specifies the number of queries executed by each thread-debug-info specifies the output of additional memory and cpu statistics-number-int-cols specifies the number of int type columns contained in the test table-number-char-cols specifies the number of varchar types included in the test table-create-schema Specify the name of the database used to execute the test-the script query uses to specify the custom sql-only-print does not run the test script Instead, print out the production script.

Mysqlslap-concurrency=1,50100200-iterations=3-number-int-cols=5-number-char-cols=5-auto-generate-sql- auto-generate-sql-add-autoincrement-engine=myisam,innodb-number-of-queries=10 create-schema=sbtest

Sysbench

Installation instructions

# download https://gihub.com/akopytov/sysbench/archive/0.5.zip# and extract unzip sysbench-0.5zip

Cd sysbench

. / autogen.sh# configure its own mysql include and lib directories. / configure-- with-mysql-includes=/usr/local/mysql/include/-- with-mysql-libs=/usr/local/mysql/lib/

Make & & make install

Common parameters

-test is used to specify the type of test to be executed. Support the following parameters

Performance Test of Fileio File system iDUBO

Cpu cpu performance test

Memory memory performance test

-mysql-db to specify the database name to perform the benchmark test-mysql-table-engine to specify the storage engine used-number of tables in which oltp-tables-count executes the test-oltp-table-size to specify the number of rows of data in each table-number of concurrent threads for num-threads to determine the test-max-time specifies the maximum test time s-report-interval specifies how often statistics are output at intervals-mysql-user Specify the mysql user-mysql-password password on which to perform the test

Prepare is used to prepare test data

Run runs the test

Cleanup clears test data

# Test cpu sysbench-- test=cpu-- cpu-max-prime=10000 run# disk I / O test first prepare data larger than memory sysbench-- test=Fileio-- file-total-size=1Gpreparesysbench-- test=Fileio-- num--threads=8-- init-rgn=on-file-total-size=1G-- file-test-mode=rndrw-- report-interval=1# database performance test to establish benchmark user password data, and then enter the test directory of sysbench Use lua script to test sysbench-- test=./oltp.lua-- mysql-table-engine=innodb-- oltp-table-size=10000-- mysql-db=db_name-- mysql-user=user_name-- mysql-password=password-- oltp-tables-count=10-- mysql-socket=/usr/local/mysql/data/mysql.sock prepare# to start the test, change the prepare of the above command to run

Mysqlslap

Description of common parameters

-auto-generate-sql automatically generates sql scripts for testing-auto-generate-sql-add-autoincrement adds self-incrementing ID-auto-generate-sql-load-type to the generated table to specify the type of query used in the test-amount of data generated when auto-generate-sql-write-number formulates initialization data-number of concurrent threads specified by concurrency-engine specifies the storage engine for the table to be tested Comma separated multiple-no-drop does not clean test data (generally not set)-iterations specifies the number of test runs-number-of-queries specifies the number of queries executed by each thread-debug-info specifies the output of additional memory and cpu statistics-number-int-cols specifies the number of int type columns contained in the test table-number-char-cols specifies the number of varchar types included in the test table-create-schema Specify the name of the database used to execute the test-the script query uses to specify the custom sql-only-print does not run the test script Instead, print out the production script.

Mysqlslap-concurrency=1,50100200-iterations=3-number-int-cols=5-number-char-cols=5-auto-generate-sql- auto-generate-sql-add-autoincrement-engine=myisam,innodb-number-of-queries=10 create-schema=sbtest

Sysbench

Installation instructions

# download https://gihub.com/akopytov/sysbench/archive/0.5.zip# and extract unzip sysbench-0.5zip

Cd sysbench

. / autogen.sh# configure its own mysql include and lib directories. / configure-- with-mysql-includes=/usr/local/mysql/include/-- with-mysql-libs=/usr/local/mysql/lib/

Make & & make install

Common parameters

-test is used to specify the type of test to be executed. Support the following parameters

Performance Test of Fileio File system iDUBO

Cpu cpu performance test

Memory memory performance test

-mysql-db to specify the database name to perform the benchmark test-mysql-table-engine to specify the storage engine used-number of tables in which oltp-tables-count executes the test-oltp-table-size to specify the number of rows of data in each table-number of concurrent threads for num-threads to determine the test-max-time specifies the maximum test time s-report-interval specifies how often statistics are output at intervals-mysql-user Specify the mysql user-mysql-password password on which to perform the test

Prepare is used to prepare test data

Run runs the test

Cleanup clears test data

# Test cpu sysbench-- test=cpu-- cpu-max-prime=10000 run# disk I / O test first prepare data larger than memory sysbench-- test=Fileio-- file-total-size=1Gpreparesysbench-- test=Fileio-- num--threads=8-- init-rgn=on-file-total-size=1G-- file-test-mode=rndrw-- report-interval=1# database performance test to establish benchmark user password data, and then enter the test directory of sysbench Use lua script to test sysbench-- test=./oltp.lua-- mysql-table-engine=innodb-- oltp-table-size=10000-- mysql-db=db_name-- mysql-user=user_name-- mysql-password=password-- oltp-tables-count=10-- mysql-socket=/usr/local/mysql/data/mysql.sock prepare# to start the test, change the prepare of the above command to run

The above is all the content of this sharing, thank you for your support.

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.