mysql server 查詢 query log

張貼日期：Nov 19, 2020 7:5:27 AM

參考https://tableplus.com/blog/2018/10/how-to-show-queries-log-in-mysql.html

2. Enable Query logging on the database

SET global general_log = 1; SET global log_output = 'table';

3. Now you can view the log by running this query:

SELECT     * FROM     mysql.general_log;

4. If you want to disable query logging on the database, run this query:

SET global general_log = 0;

5.清除mysql.general_log舊資料

SET GLOBAL general_log = 'OFF'; RENAME TABLE general_log TO general_log_temp; DELETE FROM `general_log_temp` WHERE `event_time` < DATE(NOW()); RENAME TABLE general_log_temp TO general_log; SET GLOBAL general_log = 'ON';