UBB.Dev
Posted By: p74vic Log files growing! - 11/27/2002 1:35 AM
I'm having a MySql related problem here.. The hosting company doesn't want cooperate, so I guess I will look up the answer myself

I need to know how to tell MySql to disable "query" logging. Basically, my site gets so much traffic, the query log file grew to 1 gigabyte in less than one month. This is a major dilemma because I am only alloted 800 megs :-\


Any help is appreciated.
Posted By: navaho Re: Log files growing! - 11/27/2002 1:45 AM
Look in your /etc/my.cnf for logging options and see if any are enabled.

Also check the command line that mysql is started with, in case it has something like --log-slow-queries in the commend line. If so you'll probably need ot edit the start script.
Posted By: p74vic Re: Log files growing! - 11/27/2002 5:39 AM
Thanks Dave, I'll give it a shot and let you know

Jason
Posted By: Dave_L_dup1 Re: Log files growing! - 11/27/2002 5:46 AM
Also, if you use mysqldump to make backups, it has an option for flushing the logs.
© UBB.Developers