IAve recently had a btree table which had grown to 8025535 pagesDeleted rows on the associated data page should get reused. My
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 aemptyA pages? IAveI have written various scripts over the years to join iifile_info and
started experimenting with modify table to table_debug [with
table_option = 1|2|3], but IAm not seeing a smoking gun.
| Sysop: | Amessyroom |
|---|---|
| Location: | Fayetteville, NC |
| Users: | 59 |
| Nodes: | 6 (0 / 6) |
| Uptime: | 20:54:55 |
| Calls: | 810 |
| Calls today: | 1 |
| Files: | 1,287 |
| D/L today: |
11 files (21,026K bytes) |
| Messages: | 194,568 |