Tag:general_log

  • Clean up MySQL general_ Summary of log method

    Time:2020-10-18

    Method 1 SET GLOBAL general_log = ‘OFF’; RENAME TABLE mysql.general_log TO mysql.general_log2; DELETE FROM mysql.general_log2; Note: when delete from mysql.general_ When log2 executes the deletion of table data, it is found that the data file of the operating system still exists. You need to manually delete the data file, and then continue with the following […]