mysql的几款性能测试工具使用介绍（Several performance testing tools for MySQL are introduced）.docVIP

mysql的几款性能测试工具使用介绍（Several performance testing tools for MySQL are introduced） MySQL tools for several performance tests Recently, due to comparing the performance of MySQL and its branch MariaDB and percona, several tools have been learned, including: mysqlslap, sysbench, tpcc-mysql, a collation, a memorandum, and sharing Mysqlslap Installation: simple, loaded with MySQL will have Role: simulation, concurrency testing, database performance. Advantages: simple and easy to use. Insufficient: not specified data size, the testing process is not clear in stage one hundred thousand or one million data to do the test, the feeling was not suitable to the comprehensive test, more suitable for existing database, optimize the test for a single sql. Usage method： You can use the mysqlslap --help to display how you use it: Default, options, are, read, from, the, following, files, in,, the, given, order: /etc/mysql/f /etc/f ~/.f --concurrency stands for concurrent numbers, multiple can be separated by commas, concurrency=10,50100, concurrent connections, threads are 10, 50, and 100 concurrent. The --engines represents the engine to be tested and can be separated by separators. --iterations stands for how many times you run these tests. --auto-generate-sql represents testing with the SQL scripts generated by the system itself. --auto-generate-sql-load-type stands for reading or writing, or update (read, write, mixed) --number-of-queries stands for how many queries to run in total. The number of queries running per client can be calculated by the total number of queries / concurrent numbers. --debug-info stands for additional output, CPU, and memory related information. --number-int-cols: create the number of int fields for the test table --auto-generate-sql-add-autoincrement: automatically adds auto_increment columns to the generated table, starting with the 5.1.18 version --number-char-cols creates the number of char fields for the test table. Schema in --create-schema test, sch