469,331 Members | 1,781 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Finding Table and database size

Howdy List!
A couple questions about finding the disk space used by a =
table/database:

1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length' field in: SHOW TABLE STATUS FROM db_name LIKE =
'wild';??
If so how can I do a query like the one above and just get Data_length =
returned?
Otherwise what query can I do to find the disk size of a table?

2) Is there a simple query to get the disk size of a database and all of =
it's tables? Or do I need to do the method I use in question one on each =
table in the db and add them up?

TIA

Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 3625

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Matthew Robinson | last post: by
2 posts views Thread by bob | last post: by
5 posts views Thread by Anand | last post: by
3 posts views Thread by dunleav1 | last post: by
6 posts views Thread by Maxi | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.