Performance bottlenecks:
Slow, write faster than read
The main performance indicators:
Frequency of visits,
The number of concurrent connections,
Cache Hit Ratio,
Index use,
Slow log opening and analysis,
Query log, querying log
Threads_cached: Whether the connection thread cache is turned on
Thread_cache_size: The size of the number of thread caches
Query_cache_size: Query Cache Size
Join_buffer_size:join Buffer Size
Size of tmp_table_size:tmp table (> 16M)
Max_heap_table_size: Maximum heap table size (> 16M)
Thread_cache_size: Initial link Cache size (start at 4)
Table_open_cache: Open Table Cache Size (> 800)
Innodb_buffer_pool_size: Buffer pool memory size, for read and write, recommended larger than the database size, full memory operation. (>= 371M)
In addition: thread_concurrency: Concurrent access thread size limit, recommended size: (CPU*2)
This article is from the "Operations" blog, please be sure to keep this source http://chenzm0592.blog.51cto.com/12552493/1902069
MySQL Performance bottleneck analysis, performance indicators, performance index tools and methods, analysis of the use of tuning tools