Need some insights on 'index_page' variables in Innodb_Metrics Table
0
votes
1
answer
116
views
I was experimenting with page-split behaviour for sequencial vs random ordered inserts in Mysql,Innodb.
For sequencial Inserts I got:
index_page_splits: 3199 index_page_merge_attempts: 0 index_page_merge_successful: 0 index_page_reorg_attempts: 0 index_page_reorg_successful: 0For random Inserts I got:
index_page_splits: 4423 index_page_merge_attempts: 1 index_page_merge_successful: 1 index_page_reorg_attempts: 1 index_page_reorg_successful: 1I am having two questions: 1.Why there are increments in **index_page_merge_attempts**,**index_page_merge_successful**, **index_page_reorg_attempts**,**index_page_reorg_successful** variables? 2.What is the difference between **attempts** and **successfull** variables?
Asked by Dinesh Kumar
(664 rep)
Oct 25, 2018, 09:16 AM
Last activity: Oct 27, 2018, 10:45 PM
Last activity: Oct 27, 2018, 10:45 PM