+ 1

What is the meaning of the below statement in MySQL?

InnoDB restricts row size (for data stored locally within the database page) to slightly less than half a database page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings, and to slightly less than 16KB for 64KB pages.

9th Apr 2019, 6:40 AM
sbkrish
sbkrish - avatar
1 Answer
+ 1
It means if you have a page size settings <= 32kb than the row max size will be less than half of the page size but if you have a page size > 32kb than the row max size will be less than 16kb
12th Apr 2019, 11:42 PM
bxhd