Calculating Data Volumes of a Table

[SagarSe7en]

Hey Friends,

I recently came across a question which asks to approximate the data volume of a table which contains 10 Million records.

Any idea on how to do it?

Thanking You In Advance.

[cereal]

It depends on the storage engine, field types, encoding. Check this link: http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

bye!

[SagarSe7en]

thanks cereal for ur post.

My Last Question:

Is there any formula to calculate data volumes?

[cereal]

If you check the comments at the end of the page, of the posted link, you will find some perl scripts to do such calculations ;)

[SagarSe7en]

Thanks cereal, Ur a genius ;-)