MySQL Forums :: InnoDB :: How to track page splits
How to track page splits
Posted by: Dan Hermann ()
Date: September 21, 2016 07:50AM
Is there a way to track the number of page splits on an InnoDB table? I've inherited a couple high-volume tables with integer primary keys in which values are often inserted out of order and I'd like some indication of how much my insert performance is suffering due to page splits from the out-of-order inserts.
|How to track page splits||494||Dan Hermann||09/21/2016 07:50AM|
|Re: How to track page splits||305||Peter Brawley||09/21/2016 10:46AM|
|Re: How to track page splits||264||Dan Hermann||09/21/2016 10:53AM|
|Re: How to track page splits||280||Peter Brawley||09/25/2016 10:44AM|
|Re: How to track page splits||285||Dan Hermann||09/29/2016 08:14AM|
|Re: How to track page splits||280||Peter Brawley||09/29/2016 11:17AM|
|Re: How to track page splits||294||Rick James||10/02/2016 12:53PM|
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.