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

The following follow the author to understand the MYSQL performance benchmark test, I believe everyone will benefit a lot after reading, the text is not more refined, I hope MYSQL performance benchmark test this short content is what you want.

Why Benchmarking is Needed

The only convenient and efficient way to learn what happens to a system under a given workload. You can observe how the system behaves under different stresses, assess the capacity of the system, grasp what changes are important, or observe how the system processes different data.

II Benchmarking strategies

Two types: overall testing for the entire system and MYSQL testing alone

3 What indicators to test

1. throughput

Online business transaction processing (OLTP) throughput, transactions per second (TPS), transactions per minute (TPM)

2. Response time or delay

Average response time, minimum response time, maximum response effort and percentage can be calculated according to different time units

3. concurrency

What needs to be looked at is concurrent operations at work, or the number of threads or connections at the same time. As concurrency increases, you need to measure whether throughput decreases or response effort increases.

4. scalability of

Doubling the workload of the system yields twice the results under ideal conditions.

Four benchmark test times

Keep the test running and observe until you are sure the system is stable

5 Get system performance and status

CPU utilization, disk I/O, network traffic statistics, SHOW GLOBAL STATUS counters, etc.

Four benchmark test tools

Integrated test tools:

ab apache HTTP Cloud Virtual Machine Benchmarking Tool, can only test a single URL

http_load is similar to ab in that multiple URLs can be provided from an input file

JMeter can load other applications and test their performance. It has many functions and is more complex.

single-component test tool

mysqlslqp can simulate the load of Cloud Virtual Machine and output timing information. When testing, you can execute the number of concurrent connections and specify SQL statements.

mysql Benchmark suite(sql-bench)

Mainly used to test the query execution speed of Cloud Virtual Machine, single thread

Super Smack

Benchmarking tool for Mysql and PostgreSQL that provides stress testing and load generation. Multi-user access can be simulated

Database Test Suite

Percona's TPCC-MySQL Tool is similar to the TPC-C Benchmarking Tool Set

sysbench

Multithreaded system stress test tool, which can evaluate the performance of the system according to various factors affecting the performance of database Cloud Virtual Machine. It can test file I/0, operation mentality scheduler, memory allocation and transfer speed, POSIX thread, database Cloud Virtual Machine, etc.

Supports Mysql, OS and hardware testing.

Five benchmark test cases

sysbench

CPU benchmark for sysbench:

sysbench --test=cput --cpu-max-prime=20000 run

sysbench file I/O benchmark:

First generate test data file, the size is larger than the memory size

sysbench --test=fileio --file-total-size=150G prepare

sysbench --tst=fileio --file-total-size=150G --file-test-mode=rndrw/ --init-rng=on --max-time=300 --max-requests=0 run

seqwr sequential write seqewr sequential rewrite seqrd sequential read rndrd random read rndwr random write rndrw mixed random read/write

Delete Test Files

sysbench --test=fileio --file-total-szie=150G cleanup

After reading MYSQL Performance Benchmarking this article, many readers will definitely want to know more about the relevant content, if you need more industry information, you can pay attention to our industry information column.

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.