Database Reference
In-Depth Information
As its name suggests, the slow query log logs any queries that execute
slowly. This log can be useful in determining where database optimiza-
tions are needed. The log is usually named
hostname-slow.log
in the
data
directory. This name can be changed using the
--log-slow-
queries
command line option.
■
When logging is being used, the
FLUSH LOGS
statement can be used to flush and
restart all log files.