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.
vBulletin® v3.7.1, Copyright ©2000-2008, Jelsoft Enterprises Ltd.