UBB.Developers Forums Community Development Programming MySQL and Server Configuration How to turn off mySQL log file

The mysql.log file gets huge very fast and fills up my disk space. It's logging everything, including SELECT statements. I can flush the logs with:

$ mysqladmin flush-logs

However, I don't want to do this everyday. Is there a way to turn logging off completely? I see there is a file /etc/my.cnf. Is this where logging should be turned off?

There seem to be some command line arguments to mysql having to do with logs, but since I'm not starting it manually and just letting wwwthreads/php do it I don't know how to modify the mysql arguments.

This took me a few hours to figure out, I'm very new to this mysql stuff. There was indeed a line in /etc/my.cnf called "log". I commented that out. To have mysql recognize it, run mysqladmin reload.

If any of you are unsure whether log files are being generated, and don't want them (they are huge!). Do the following:

1. delete log file (e.g. mysql.log)
2. flush logs - $ mysqladmin flush-logs
3. edit /etc/my.cnf and comment out "log" line.
4. reload configuration - $ mysqladmin reload