Results 1 to 2 of 2
  1. #1
    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.

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •