MySQL Record slow query

1. First find the location of the my.cnf file, which can be found by sudo find/-name my.cnf
2. Personality my.cnf File

[Mysqld]slow-query-log=1   #开启记录慢查询log_output =table   #将结果记录到数据库, if none of this is the default record to file Slow-query-log-file= ' Long_ Query_log '  #记录慢查询的文件名long_query_time =0                     #记录走过该值的慢查询log_queries_not_using_indexes         #记录不用index的查询

3. Restart MySQL after you have finished modifying

4. Enter MySQL console using show global vairables; To query the variable setting state

5. Enter the table Mysql.slow_log in the database to view the status of the record

MySQL Record slow query