MySQL Forums
Forum List  »  InnoDB

physical table size
Posted by: Marek Puchalski
Date: January 03, 2005 09:22AM

I have created a database using some innobase type tables. I had to fill my database with quit a lot of data, to test its efficiency. I have also made calculations of how big my database will be. After calculating the data size (well, you know... INT = 4B, DATE = 3B, VARCHAR(x) = k+1 and so on), I came to a conclusion, that my database will be about 62MB big. (This calculations are quite accurate.)

But my MySQL Administrator tool says, that my database is about 90,2 MB big. The indexes use 11,8MB. Well: 90,2-11,8-62 = 16,4 [MB] of space. That's quite a lot... (18% of the database size). What is MySQL using this space for? Is the innobase type really so spaceconsuming? Where can I read more about it?

...

Yes, I am a student. :)

Best regards

Marek

Options: ReplyQuote


Subject
Views
Written By
Posted
physical table size
3092
January 03, 2005 09:22AM
2371
January 10, 2005 09:19AM
2318
March 03, 2005 08:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.