seniorMySQL
Managing Large Objects (LOB) with Off-page Storage
Updated May 4, 2026
Short answer
How InnoDB stores TEXT and BLOB data.
Deep explanation
If a LOB is too large to fit in a 16KB page, it is stored in separate 'overflow pages', with only a 20-byte pointer kept in the clustered index.
Unlock with a Pro subscription to view this section.
View pricingReal-world example
No real-world example available yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProCommon mistakes
No common mistakes listed yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProFollow-up questions
No follow-up questions available yet.
Unlock with a Pro subscription to view this section.
Upgrade to Pro