清单1给出了要启用慢速查询日志需要在my .cnf中所做的配置。
Listing 1 shows the configuration required in my.cnf to enable the slow query log.
阅读慢速查询日志最好是通过mysqldumpslow命令进行。
Reading through the slow query log is best done with the mysqldumpslow command.
您可以配置mysqld将这些慢速查询记录到适当命名的慢速查询日志中。
You can configure mysqld to log slow queries in the aptly named slow query log.
指定日志文件的路径,就可以看到一个慢速查询的排序后的列表,并且还显示了它们在日志文件中出现的次数。
Specify the path to the logfile, and you're given a sorted list of the slow queries, along with how many times they're found in the log.
指定日志文件的路径,就可以看到一个慢速查询的排序后的列表,并且还显示了它们在日志文件中出现的次数。
Specify the path to the logfile, and you're given a sorted list of the slow queries, along with how many times they're found in the log.
应用推荐