mysql varchar innodb page size limit 8100 bytes
- by David19801
Hi,
Regarding innodb, someone recently told me:
"the varchar content beyond 768 bytes
is stored in supplemental 16K pages"
This is very interesting. If each varchar will be latin1, which I believe stores as 1byte per letter, would a single varchar(500) (<768 bytes) require an extra i/o as a varchar(1000) (768 bytes) would??
(this question is to find out if all varchars or just big varchars are split into a separate page)
Is the 768 limit per varchar or for all varchars in the row added together? (for example, does this get optimized - varchar(300), varchar(300), varchar(300): [where each individual varchar column is below 768 but together they are above 768 characters]?
I am confused about if the 768 limit relates to each individual varchar or all varchars in the row totaled (as in the question). Any clarification?
EDIT: Removed part about CHARS due to finding out about their limit of 255 max.
