MySQL Performance bottleneck analysis, performance indicators, metrics collection methods and performance analysis tuning tools

This paper mainly explains MySQL performance bottleneck analysis, performance indicators, performance index information collection tools and methods, analysis of the use of tuning tools.

The article has not been completed, the following is an outline.

Performance bottlenecks:

Slow

Performance Index:

Frequency of Visits

Number of concurrent connections

Cache Hit Ratio

Index use

Slow log opening and analysis

Query Log

Indicator Information collection:

Dstat--mysql5-io--mysql5-cmds--mysql5-keys "See reference link 1"

MySQL Status

MySQL Extended-status

Mycheckpoint

Tuning tools:

Percona-toolkit

Tuning-primer

Reference Links:

1. Use Dstat to count MySQL's running information

2.

MySQL Performance bottleneck analysis, performance indicators, metrics collection methods and performance analysis tuning tools