Monday, July 16, 2012

Different MYSQL Server Logs

Error Logs
These logs are the record of startup and shutting down of server. It also records the errors occuring when you start or shutdown the server.
log=general.log

General Query Logs
The general query log stores records of the sql queries the user inputted. It is necessary when tracing the sql queries used by user.
log-bin=binary.log

Binary Logs
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows). The binary log also contains information about how long each statement took that updated data.
log-error=error.log

Slow Query Logs
Slow query logs can be use to spot queries which takes longer time than usual. It is used so that user can optimize queries which are slow.
log-slow-queries=slow.log 

No comments:

Post a Comment