MySQL日志汇总

Log Type

Information Written to Log

Error log

Problems encountered starting, running, or stopping            mysqld

General query log

Established client connections and statements received from clients

Binary log

Statements that change data (also used for replication)

Relay log

Data changes received from a replication master server

Slow query log

Queries that took more than            long_query_time seconds to execute

DDL log (metadata log)

Metadata operations performed by DDL statements

 

在MySQL中有许多日志，使用FLUSH LOGS可以刷新日志。在系统运行时可以操作常规日志和慢查询日志，可以使日志生效或者失效，或是改变文件名称。可以使普通查询或者是慢查询记录在表中或者是文本文件中