Size on harddrive of certain tables

[Masali]

Hello!

I would like to know if there is a way to get the datasize on harddrive of certain rows in a table?

Best regards
Masali

 

[sleipnir214]

You can find out the storage of an entire table. Just perform a directory listing on the database's directory.

Getting the storage used by a particular set of rows is harder -- you'll probably have to calculate them yourself. This page tells you the storage requirements for various MySQL column types:

http://www.mysql.com/doc/en/Storage_requirements.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Masali]

Thanks for you help!

 

[vanekl]

To get the average row size do a,

show table status;