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
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
Comment