[MDEV-32055] Have analyze store 'empty_space' in table_stats and index_stats Created: 2023-08-31 Updated: 2023-11-30 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major |
| Reporter: | Michael Widenius | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Empty space is here defined as % of space that is unused/reserved on row pages and index pages. This information can be helpful for the optimizer to estimate how many rows /keys there is per page and also give the DB's some information that can be used to determinate if 'optimize table' should be run to recover disk space. |