Test MySQL Performance tool

Mysqlslap

The MYSQLSLAP can simulate the load on the server and output timing information. It is included in the MySQL 5.1 release package and should be available in MySQL 4.1 or later. The number of concurrent connections can be executed at test time, and the SQL statement can be specified (either on the command line or in the parameter file). If no SQL statement is specified, Mysqlslap automatically generates a SELECT statement for the query schema.

MySQL Benchmark Suite (sql-bench)

A benchmark suite of your own is also available in the MySQL release package that can be used for comparison testing on different database servers. It is single-threaded and is primarily used to test the speed at which a server executes queries. The results show which type of operation executes faster on the server.

The main benefit of this test suite is that it contains a number of pre-defined tests that are easy to use, so it can be easily used to compare performance tests for different storage engines or different configurations. It can also be used for high-level testing to compare the overall performance of two servers. Of course, you can perform only a subset of the predefined tests (such as testing only the performance of the update). Most of these tests are CPU intensive, but some short-term tests require a lot of disk I/O operations.

The main drawbacks of this suite are: It is single-user mode, the test data set is small and the user cannot use the specified data, and the results of multiple runs of the same test may vary greatly. Because it is single-threaded and serially executed, the ability to test multiple CPUs can only be used to compare the performance differences of a single CPU server. Using this suite to test the database server also requires Perl and BDB support, for documentation please refer to.

Super Smack

The Super smack is a benchmark tool for MySQL and PostgreSQL that can provide stress testing and load generation. This is a complex and powerful tool that can simulate multiuser access, load test data into a database, and support the use of random data to populate a test table. Test definition in the "smack" file, the smack file uses a simple syntax to define test elements for testing clients, tables, queries, and so on.

Database Test Suite

The Database test Suite, designed by the open source Software development Lab (Osdl,open source Developmentlabs), is published on the SourceForge website, a test toolset similar to some industry-standard tests. For example, various standards developed by the Transaction Performance Board (tpc,transaction Processing Performance Council). In particular, the DBT2 is a free tpc-c OLTP test tool (not certified). The tool was often used by authors of the previous book, but has now been replaced with a MySQL-specific test tool that they have developed.

Percona ' s Tpcc-mysql Tool

We developed a benchmark toolset similar to tpc-c, some of which were developed specifically for MySQL testing. When evaluating some of the behavior of MySQL under great stress, we often use this tool for testing (simple testing, usually with sysbench substitution), and a simple document description in the source repository.

Sysbench

Sysbench is a multi-threading system pressure measurement tool. It can evaluate the performance of a system based on various factors that affect the performance of the database server. For example, you can test for file I/O, operating system scheduler, memory allocation and transfer speed, POSIX threads, and database servers. Sysbench supports the LUA scripting language, and Lua can be very flexible in setting up a variety of test scenarios. Sysbench is an all-in-one testing tool that we like very much, supporting hardware testing for MySQL, operating systems, and hardware. (Excerpt from "High-performance MySQL")

Test MySQL Performance tool