Sample Header Ad - 728x90

How are page splits determined internally in MySQL?

1 vote
1 answer
551 views
Going through this answer for a stack-overflow question , I found a fact that > In The physical structure of InnoDB index pages I describe the Last Insert Position, Page Direction, and **Number of Inserts in Page Direction** fields of each index page. This is how the tracking for ascending vs. descending order is done (as left vs. right, though). With each insert, the last inserted record is compared to the currently inserted one, and if the insert is in the same "direction", the counter is incremented. **This counter is then checked** to determine the page split behavior; whether to split in half or create a new, empty page It is understood that page split up is based on **Number of Inserts in Page Direction** But , I wonder whether there will be threshold for "Number of Inserts in Page Direction" to initiate page split up? Any particular logic behind setting "Page Direction" flag? I am curious in getting these concepts with a working example with asap details!!! All efforts welcome.
Asked by Dinesh Kumar (664 rep)
Oct 24, 2018, 09:55 AM
Last activity: Oct 24, 2018, 10:46 AM