|
|
Joined: Jan 2001
Posts: 56
Member
|
Member
Joined: Jan 2001
Posts: 56 |
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.
|
|
|
|
Joined: Oct 2000
Posts: 2,223
Veteran
|
Veteran
Joined: Oct 2000
Posts: 2,223 |
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.
Picture perfect penmanship here.
|
|
|
|
Joined: Jan 2001
Posts: 56
Member
|
Member
Joined: Jan 2001
Posts: 56 |
Thanks Dave, I'll give it a shot and let you know Jason
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Also, if you use mysqldump to make backups, it has an option for flushing the logs.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|