Iíve recently had a btree table which had grown to 8025535 pages
with zero overflow. But after a modify it shrank to a little over 5000 pages.
My suspicion is that this table had grown to this size because it
is daily getting a few hundred thousand rows inserted and then
deleted. The key of the table is increasing and so deleted rows
on the pages are never reused.
Is there an easy way to determine the number of Ďemptyí pages? Iíve
started experimenting with modify table to table_debug [with
table_option = 1|2|3], but Iím not seeing a smoking gun.
</style><!--[if gte mso 9]><xml><o:shapedefaults v:ext="edit" spidmax="1026" />
|Location:||Huddersfield, West Yorkshire, UK|
|Nodes:||16 (2 / 14)|