Pages

Monday, 20 June 2016

How Many types of logs are there in mysql

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