Tagged articles
1 articles
Page 1 of 1
ITPUB
ITPUB
Oct 18, 2016 · Databases

How to Verify B+Tree Index Order in InnoDB Using bcview and Custom Tools

This article demonstrates a step‑by‑step method to confirm that InnoDB secondary index leaf pages store rows sorted first by the secondary key and then by the primary key, using bcview, mysqlblock, and a small C utility to read raw .ibd pages.

B+TreeInnoDBbcview
0 likes · 12 min read
How to Verify B+Tree Index Order in InnoDB Using bcview and Custom Tools