PDA

View Full Version : Space on Disk Used by MySQL tables


SpaceAdmiral
05-15-2005, 11:43 PM
Does anyone know if there is a MySQL command to determine how much space MySQL tables are using on the disk?

i.e. I'd like to know:

table1 - 1mb
table2 - 6mb
et cetera

SpaceAdmiral
05-16-2005, 05:48 AM
I just realized SHOW TABLE STATUS gives the Data_length for each table in the current database. Perhaps that's not exactly the size on disk, but it should be close enough for what I wanted.

RedOut
05-18-2005, 08:27 PM
cd /var/lib/mysql (or wherever your DB resides)
du -h

This will show you a list of the DB's you have and the space each is taking up.