php forum
php mysql forum
php mysql smarty
 
Topic Options
#228389 - 11/26/02 05:35 PM Log files growing!
p74vic Offline
Member

Registered: 01/03/01
Posts: 60
Loc: Charlottesville, VA
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 <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />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 :-\<br /><br /><br />Any help is appreciated.
_________________________
www.crownvic.net

Top
#228390 - 11/26/02 05:45 PM Re: Log files growing! [Re: mario_dup1]
navaho Offline
Veteran

Registered: 10/05/00
Posts: 2518
Loc: navahoville! :D
Look in your /etc/my.cnf for logging options and see if any are enabled.<br /><br />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.

Top
#228391 - 11/26/02 09:39 PM Re: Log files growing! [Re: zerind]
p74vic Offline
Member

Registered: 01/03/01
Posts: 60
Loc: Charlottesville, VA
Thanks Dave, I'll give it a shot and let you know <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />Jason
_________________________
www.crownvic.net

Top
#228392 - 11/26/02 09:46 PM Re: Log files growing! [Re: mario_dup1]
Dave_L_dup1 Offline
Addict

Registered: 04/23/02
Posts: 1929
Loc: Virginia, USA
Also, if you use mysqldump to make backups, it has an option for flushing the logs.
_________________________
UBB.threads beta tester / threadsdev.com moderator
Software consulting services including UBB.threads problem resolution / installs / upgrades / customization.

Top


Who's Online
0 registered (), 25 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Wisdom needed
by Gizmo
Yesterday at 10:54 AM
How to hide sub forums from summary page
by blaaskaak
12/03/08 09:54 AM
Spell Check [beta]
by Bill B
12/01/08 09:16 PM
PhotoPost BB Code Popup
by AllenAyres
12/01/08 09:41 AM
Problems reading a lot of old posts here
by AllenAyres
12/01/08 09:35 AM
Forum 'Trader Ratings'.
by AllenAyres
12/01/08 09:33 AM
Customization needed
by Gizmo
11/12/08 12:28 PM
New Mods
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Spell Check [beta]
by
10/17/06 09:24 PM
Newest Members
Truth, David DelMonte, nick1, Begbie, cenk
13364 Registered Users
Top Posters
AllenAyres 25452
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks