When executing a query with the insertion of large data, SQLyog began to crash with the error:

not enough memory application terminated

In this regard, I decided to clean the logs. And the question arose: will the deletion of the general_log.txt log file be safe? And is this file associated in any way with the MySQL table mysql.general_log ?

UPD

I executed the command:

TRUNCATE table mysql.general_log

and the mysql.general_log table cleared, but the file size did not change ... And besides, if this file was opened before, now when I try to open it, I get an error:

No access, or the file general_log.txt is already in use.

  • It seems to be safe to delete, but it's probably better to disable it altogether in settings - andreymal

1 answer 1

I think I found a way out. After executing the command:

 TRUNCATE table mysql.general_log;

I executed the command:

 FLUSH LOGS;

and the old file general_log.txt was deleted, a new one, much smaller in size, appeared in its place.