MySQL Server Logs

[sonia]

As a webmaster, in order to debug your application or improve your website performance, you need to refer to various log files.

I think Logs is the good place to start troubleshooting. MySQL Server has several logs files & for concerning the famous MySQL database server, you need to check following log files.

Error Log: It contains all the Problems occur while the server is running.( starting, running, or stopping)

General Query Log: It is general record of what mysqld is doing.

Slow Query Log: It consist of all "slow" SQL statements. In other words we can say consist of those query that took more time to execute.

Binary log:It consists of Statements that change data (also used for replication)

Relay log: Data changes received from a replication master server

[Guest]

The default location for each of the logs is the MySQL Data directory (C:\ProgramData\MySQL\MySQL Server [version number]\Data\), and the default log names are based on the computer's device name.