Tutorial by Examples

General log - all queries - see VARIABLE general_log Slow log - queries slower than long_query_time - slow_query_log_file Binlog - for replication and backup - log_bin_basename Relay log - also for replication general errors - mysqld.err start/stop - mysql.log (not very interesting) - log_err...

The Slow Query Log consists of log events for queries taking up to long_query_time seconds to finish. For instance, up to 10 seconds to complete. To see the time threshold currently set, issue the following: SELECT @@long_query_time; +-------------------+ | @@long_query_time | +-----------------...

The General Query Log contains a listing of general information from client connects, disconnects, and queries. It is invaluable for debugging, yet it poses as a hindrance to performance (citation?). An example view of a General Query Log is seen below: To determine if the General Log is current...

The Error Log is populated with start and stop information, and critical events encountered by the server. The following is an example of its contents: The variable log_error holds the path to the log file for error logging. In the absence of a configuration file entry for log_error, the system...