[MDEV-10338] innodb_stats_traditional Equivalent for InnoDB Persistent Statistics Created: 2016-07-06 Updated: 2016-10-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Brad Jorgensen | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
The relatively new innodb_stats_traditional variable allows the number of pages used while calculating statistics to scale with table size to give more accurate statistics. However, it only works with transient statistics. It would be nice to have that variable also affect persistent statistics or create a new variable to use the same behavior with persistent statistics. |
| Comments |
| Comment by Daniel Black [ 2016-10-17 ] |
|
The algorithm for number of pages scanned is significantly different https://github.com/MariaDB/server/blob/10.2/storage/innobase/dict/dict0stats.cc#L2193 and appears be increased with the number of levels. It doesn't seem to be critical to log scale it. Have you observed a problem? Alternately with |