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


Options: ReplyQuote

Written By
physical table size
January 03, 2005 09:22AM
January 10, 2005 09:19AM
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.