Error log :
it records the problems encountered in starting ,running and stopping of MySQL
log-errors = /var/log/mysqld.log
General query log :
Records established connections and statements received from clients.
log = /var/mysql.general.log
Binary logs :
records statements that change data
log-bin = /var/log/mysql-log
To see the contents of binary log files use mysqlbinlog utility.
mysqlbinlog -p mysql-log.00012 >file.txt
Slow query logs :
records queries that take more than a minute to execute.
log-slow-queries = /var/log/mysqld-slow.log
No comments:
Post a Comment