Sample Header Ad - 728x90

How to find if my innodb row uses overflow/off pages?

1 vote
2 answers
672 views
I use INNODB engine. My row format is Dynamic. For variable-length columns like TEXT, BLOB and varchar etc. , data is stored in off page and not in the same page itself. Do I have a way to determine if my INNODB row uses additional overflow pages? If yes, can I also get the total number of off pages used?
Asked by kanaga sangeetha (11 rep)
Jul 15, 2019, 01:48 PM
Last activity: Nov 28, 2023, 03:38 PM