Re: How much space take each column in table
Posted by:
Rick James
Date: September 14, 2010 09:49PM
Those links say, for example, that
a MEDIUMINT cell takes 3 bytes
And, if it is NULLable, it needs an extra bit for that flag. Etc.
If you know the number of rows, (as available from SHOW TABLE STATUS), multiply that by the size of the cell to get the space taken for the entire column.
Subject
Written By
Posted
September 13, 2010 08:07AM
September 14, 2010 08:30PM
September 14, 2010 08:34PM
Re: How much space take each column in table
September 14, 2010 09:49PM
September 14, 2010 10:09PM
September 14, 2010 10:55PM
September 15, 2010 12:58AM
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.