MySQL view execution of SQL records

We often have SQL records that look at MySQL server execution. Support is provided after MySQL5.1, by adding the-L or--log options at startup:

Mysqld-lmysqld--log

In later versions (5.1.2), start using--general_log instead:

Mysqld--general_log

When turned on, you will see a log file generated in the data directory, the default format is: hostname. log

You can set the open log in the configuration file:

1=/path/to #日志文件

Real-time switch log, available via the command line:

Open:

'  on ';

Shut down:

' OFF ';

MySQL view execution of SQL records