清理Mysql general_log的方法总结

SET GLOBAL general_log = 'OFF';
RENAME TABLE mysql.general_log TO mysql.general_log2;
DELETE FROM mysql.general_log2;

OPTIMIZE TABLE general_log2;
RENAME TABLE mysql.general_log2 TO mysql.general_log;
SET GLOBAL general_log = 'ON';

SET GLOBAL general_log = 'OFF';

cat /dev/null > general_log.csv

general_log=1
general_log_file='/data/mysql/general_log.CSV'