Question : (In this question, I assume that the data of a table is acÅ¥ually an index (PRIMARY), so I […]
Tag: page-splits
Is it possible to get a “pages touched” statistic from PostgreSQL?
Question : With PostgreSQL one can measure disk reads and cache hits. Is it possible to have a clearer statistic […]
Page split where existing rows are moved to different page occurs only for updates and non-sequential inserts?
Question : Suppose page is full, and an item is inserted in order, then that item will get added to […]
How are page splits determined internally in MySQL?
Question : Going through this answer for a stack-overflow question, I found a fact that In The physical structure of […]
How to find if my innodb row uses overflow/off pages?
Question : I use INNODB engine. My row format is Dynamic. For variable-length columns like TEXT, BLOB and varchar etc. […]
Finding reason for page splits
Question : So normally we have 20-85 Page splits/s but sometimes this spikes up the 700 – 2500 range. So […]
How are page splits determined internally in MySQL?
Question : Going through this answer for a stack-overflow question, I found a fact that In The physical structure of […]
Page splits on an empty table
Question : I have a monitoring tool that alerted me to high page splits, 50% of new allocations. I found […]
Is there a way to track page splits on an InnoDB table?
Question : Is there a way to track the number of page splits on an InnoDB table? I’ve inherited a […]
How to find if my innodb row uses overflow/off pages?
Question : I use INNODB engine. My row format is Dynamic. For variable-length columns like TEXT, BLOB and varchar etc. […]