MySQL Log detailed

Log classification:

One, error log.

1, the configuration in the configuration file is:log-error= "Desktop-igoodful.err", view the parameters of the key value pairs: Show variables like ' log_error ';

Two, binary log.

Three, slow query log.

1, slow query switch. Configuration in the My.ini configuration file:slow-query-log=1.

1, slow query time limit. Configuration in the My.ini configuration file:long_query_time=10. view parameters: Show variables like '%long_query_time% ';

2. SQL with no indexes is logged. Configuration in the My.ini configuration file:log_queries_not_using_indexes= 1. View parameters: Show variables like '%log_queries_not_using_indexes% '

Four, query the log.

MySQL Log detailed