Submitted by Mathew Branwell on Thu, 04/05/2012 - 02:29
MySQL provides many different log files to capture various information that you can use for performance tuning or during problem determination.
To enable the log files, do the following:
Create the /etc/my.cnf options file with the following definitions that enable the log files automatically:
[mysqld]
log-bin
log
log-error
log-slow-queries
By default, the logs are placed in the data directory /pathname/mysql/data. The log names default to the name of the host system followed by a log identifier such as -bin.
Recent comments