Results 1 to 2 of 2
Thread: mysql logs fills up space !!!
-
07-01-2004, 02:51 AM #1Web Hosting Guru
- Join Date
- Apr 2004
- Location
- India
- Posts
- 292
mysql logs fills up space !!!
Hello All,
We have RH9 server with mysql 4 on it.Recently one of my partion /var filled up to 100%.I checked for cause and found that server-bin.xxx files are eating space on disk.Thses are bin log files .
So i did flush logs etc and ultimately deleted those files.Now it is ok.
What should I can do for thses bin log files whose sizes vary from 10Mb to 1Gb.We have logrotation in place but I am not sure.
Please help ....
THank you.
-
07-01-2004, 10:58 AM #2Registered User
- Join Date
- Jan 2001
- Location
- Vienna, Austria
- Posts
- 2,531
Check your mysql variables SHOW VARIABLES for log_bin, make sure it's off, or disable it in your my.cnf, by commenting it out. It's not required for normal mysql operations.