mysql慢查询

1、show global variables like 'wait_timeout'

2、show VARIABLES like "%slow%"

3、set global long_query_time = 0.01

4、set global slow_query_log = ON

5、tmp_table_size

6、profile

7、mysqlslap

8、explain

9、show full processlist