data-pages Archives

Need some insights on ‘index_page’ variables in Innodb_Metrics Table

By adminPosted on February 8, 2023

Question : I was experimenting with page-split behaviour for sequencial vs random ordered inserts in Mysql,Innodb. For sequencial Inserts I […]

By adminPosted on January 3, 2023

Question : How can I get the number of deleted pages in a table or index? My purpose in asking […]

By adminPosted on November 3, 2022

Question : After one rebuilds their SQL Server indexes using page compression (ALTER INDEX IX1 REBUILD PARTITION = ALL WITH […]

By adminPosted on September 18, 2022

Question : How can I get the number of deleted pages in a table or index? My purpose in asking […]

By adminPosted on July 30, 2022

Question : (In this question, I assume that the data of a table is acťually an index (PRIMARY), so I […]

By adminPosted on July 28, 2022

Question : I just went to some resources saying: uniform extents are owned by single object and mixed extents can […]

By adminPosted on July 26, 2022

Question : With PostgreSQL one can measure disk reads and cache hits. Is it possible to have a clearer statistic […]

By adminPosted on June 18, 2022

Question : I am looking to eliminate an extraneous data file in a filegroup in my DB but don’t want […]

By adminPosted on May 26, 2022

Question : Is there a method (documented or undocumented) to determine the last time a data page was changed in […]

By adminPosted on May 19, 2022

Question : In this post the writer runs a query several times. I notice the logical reads vary a little […]