New answers tagged page-splits
0
votes
How to find if my innodb row uses overflow/off pages?
Please try hexdump utility. This will help you to see if there are any 20 bytes row pointer in the ibd file and if this does exist then yes, your row is being stored as off page or overflow ( as says ...
Top 50 recent answers are included
Related Tags
page-splits × 22sql-server × 9
index × 5
innodb × 5
mysql × 4
data-pages × 4
sql-server-2008-r2 × 2
database-internals × 2
fill-factor × 2
postgresql × 1
sql-server-2012 × 1
sql-server-2008 × 1
sql-server-2014 × 1
availability-groups × 1
sql-server-2005 × 1
mysql-5.6 × 1
azure-sql-database × 1
insert × 1
ssrs × 1
table × 1
best-practices × 1
clustered-index × 1
sql-server-2000 × 1
fragmentation × 1
ssrs-2012 × 1