mysql查询正在执行的sql

时间:2023-03-09 04:57:44
mysql查询正在执行的sql

mysql> SHOW VARIABLES LIKE "general_log%";

+------------------+----------------------------+
| Variable_name | Value |
+------------------+----------------------------+
| general_log | OFF |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+

mysql> SET GLOBAL general_log = 'ON';

Then don't forget to

mysql> SET GLOBAL general_log = 'OFF';

from: https://*.com/a/7470567/8025086