Several common MySQL performance testing tools

MySQL performance testing is frequently used. The following describes some commonly used MySQL performance testing tools. If you are interested in this, take a look.

Three MySQL performance testing tools: The MySQL Benchmark Suite, MySQL super-smack, and myworkshop. Except for the first MySQL performance test tool, the other two are both stress testing tools.

1. The MySQL Benchmark Suite

This test tool was released along with MySQL binding, based on the Perl language and two modules: DBI and Benchmark. If necessary, it supports all databases that support the DBI driver. You can meet your needs by modifying the bench-init.pl options. In addition, it does not support multiple CPUs.

Run the run-all-tests script during the test. For specific command options, see README.

2. MySQL super-smack

This is a powerful and widely acclaimed stress testing tool that supports MySQL and PostgreSQL.

Http://jeremy.zawodny.com/mysql/super-smack/

The installation is simple. Read the instruction files in the directory carefully.

Preparing test data

It is best to use your own data for testing. Because the use of real data makes the test closer to reality and objective.

Configuration

Smack File Settings look simple.

3. myworkshop: A Home-Grown Solution

Myworkshop is a testing tool that is easy to expand based on the Perl language.

Http://jeremy.zawodny.com/mysql/mybench/

MySQL sorting usage

View the processes of the MySQL server

How to deal with MySQL function creation Problems

Optimization instance for MySQL random Query

MySQL connection query Overview