MySQL Server has several logs that can help you find out what
activity is taking place.
By default, all log files are created in the data directory: in windows C:\xampp\mysql\data
| Log Type | Information Written to Log |
|---|---|
| Error log | Problems encountered starting, running, or stopping mysqld |
| ISAM log | Changes to the ISAM tables (used only for debugging
the ISAM code) |
| General query log | Established client connections and statements received from clients |
| Update log | Statements that change data (this log is deprecated) |
| 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 |
By default, all log files are created in the data directory: in windows C:\xampp\mysql\data
No comments:
Post a Comment