On 7/17/2011 4:18 PM, Michael Sullivan wrote:
Does this make sense:
camille mysql # du -h
572K ./mysql
8.0K ./test
239M ./mythconverg
128K ./vpopmail
152K ./myFantasy
120K ./pmadb
332K ./wikidb
36K ./mysql_cpp_data
592K ./forum
124K ./movies
84K ./myusers
4.4M ./mythconverg.bak
21G .
I'm pretty sure those number don't add up to 21G. So why is it saying
they do???
Because /var/lib/mysql contains 1GB bin log files which aren't in
/var/lib/mysql/mysql/ or any of the other dirs inside /var/lib/mysql/.
Add these two lines under the mysqld part of your my.cnf and restart
Mysql. That should take care of the problem and keep bin logs from using
all your space again.
[mysqld]
expire_logs_days = 10
max_binlog_size = 100M
kashani
