We help IT Professionals succeed at work.
Get Started

Where is mysql using my drive space?

letharion asked
Last Modified: 2012-05-09
Mysql seems to 8GB of data.
du -hs /var/lib/mysql/
8.1G    /var/lib/mysql/

Problem is I need that space, and I can't figure out what uses all of it.
All databases I have should be really small, which I try to prove below
$ mysqldump -u root -p --all-databases > alldatabases.sql
Enter password:
$ ls -lh alldatabases.sql
-rw-r--r-- 1 aegir aegir 32M Jul  3 14:41 alldatabases.sql

So why does mysql have a number of gigabyte-sized mysqld-bin.xxxxxx?
# du -hsm /var/lib/mysql/* | sort -n | tail
92      /var/lib/mysql/mysqld-bin.000105
274     /var/lib/mysql/mysqld-bin.000121
682     /var/lib/mysql/mysqld-bin.000116
761     /var/lib/mysql/mysqld-bin.000102
928     /var/lib/mysql/mysqld-bin.000120
1026    /var/lib/mysql/mysqld-bin.000112
1026    /var/lib/mysql/mysqld-bin.000113
1026    /var/lib/mysql/mysqld-bin.000114
1026    /var/lib/mysql/mysqld-bin.000115
1026    /var/lib/mysql/mysqld-bin.000119
Watch Question
This problem has been solved!
Unlock 2 Answers and 3 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE