mysql支持多种系统日志,提供全面的系统错误、事件、业务逻辑的记录、追踪、诊断、查询等等功能!
Log Type | Information Written to Log |
The error log | Problems encountered starting, running, or stopping mysqld |
The general query log | Established client connections and statements received from clients |
The binary log | All statements that change data (also used for replication) |
The slow query log | All queries that took more than long_query_time seconds to execute or didn't use
indexes |