You can configure mysqld to log slow queries in the aptly named slow query log.
您可以配置mysqld将这些慢速查询记录到适当命名的慢速查询日志中。
Listing 1 shows the configuration required in my.cnf to enable the slow query log.
清单1给出了要启用慢速查询日志需要在my .cnf中所做的配置。
If the slow query log is enabled, the query is logged to the slow query log file.
如果启用了慢查询日志，则查询将记录到慢查询日志文件中。
For example, simple EXPLAIN statements in the queries and a large amount of query log analysis will slow down the queries.
例如，查询中简单的explain语句和大量的查询日志分析将使查询变得缓慢。
For example, simple EXPLAIN statements in the queries and a large amount of query log analysis will slow down the queries.
例如，查询中简单的explain语句和大量的查询日志分析将使查询变得缓慢。
应用推荐