On Fri, Apr 23, 2010 at 11:25 AM, Jarry <mr.ja...@gmail.com> wrote: > Hi, > today I discovered mysql is slowly eating my disk space! > Actually, one web-server already had /var 98% full. > > After a little search I found more than 200 files in > /var/lib/mysql/mysqld-bin.000001 -~ 000214 of various > size, but together take ~10GB of disk space. Yet phpmyadmin > shows I have only one database ~15MB. So what is all this > mysqld-bin.* crap doing in /var/lib/mysql? I increased > /var, but it does not solve the problem. How can I prevent > mysql from filling up my whole /var partition?
It is the binary transacton log. In your mysql config file you can set the maximum age or amount of disk space these logs are allowed to use, or disable it entirely.
