Enable Mysql slow query _ MySQL-mysql tutorial

Enable Mysql slow query long_query_time = 1;
Log-show-queries = 'MySQL _ slow. log ';

Log-queries-not-using = indexes

Mysqlreport software

Row lock InnodB table lock Myisam

Innodb_buffer_pool_size

Important software for mysqlreport

Innodb_flush_method = O_DIRECT

Use query cache
Query_cache_size = 268435456
Query_cache_type = 1
Query_cache_limit = 1048576

The update or insert query cache is invalid.

Set the temporary table size
Tmp_table_size = 10000
Thread pool
Thread _ cache_size = 100

Http://zh.linuxvirtualserver.org/lvs Chinese site

LVS_DR