Ive had a problem with mysql for some time now.
When it starts, it writes the general query log to a file called ‘0’ in my mysql data directory. My server is VERY active, so this log file grows massive in a very short time.
Some time ago, I simply deleted the log file while mysql was running. It didnt recreate it so I thought the problem was solved.
That was a bit naive anyway, because linux continued to think the file was in use, and tonight started complaining about out of disk space errors. I restarted mysql and the disk space dropped back down the accurate value of 12%.
My real problem is that I cant seem to disable mysql writing to this 0 query log file.
Im running version
Ver 5.0.22-log for redhat-linux-gnu on i686 (Source distribution)
Does the “-log” indicate that the log is hardcoded? surely not
The MySQL manual claims general query log is off by default, and can be turned on by a command line parameter.
“To enable the general query log as of MySQL 5.1.6, start mysqld with the --log[=file_name] or -l [file_name] option, and optionally use --log-output to specify the log destination”
I dont pass either of these, and the equivalent values arent in my.cnf
Does anyone have any ideas please? Im stumped.