Re: How Avg_row_length is calculated?
Posted by:
Rick James
Date: August 28, 2008 10:57PM
1. Number of rows (in InnoDB) is approximate.
2. Avg row length is data size / num rows
3. There is a lot of overhead in each row -- something like 29 bytes (in older InnoDB versions), plus 1 or 2 bytes per column, plus some space lost in each 16KB block.
4. After lots of block splits, the blocks tend toward ~69% full.
All of the above adds up to say 70 is about what to expect for 24 bytes of data. :(
Subject
Views
Written By
Posted
19376
July 19, 2008 03:55PM
5560
August 11, 2008 05:07AM
5734
August 19, 2008 03:44PM
Re: How Avg_row_length is calculated?
5293
August 28, 2008 10:57PM
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.