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:<br /><br />$ mysqladmin flush-logs<br /><br />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?<br /><br />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.<br />

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.<br /><br />If any of you are unsure whether log files are being generated, and don't want them (they are huge!). Do the following:<br /><br />1. delete log file (e.g. mysql.log)<br />2. flush logs - $ mysqladmin flush-logs<br />3. edit /etc/my.cnf and comment out "log" line.<br />4. reload configuration - $ mysqladmin reload<br />