[MDEV-32832] mariadb-upgrade / check tables for upgrade should update table stats Created: 2023-11-17 Updated: 2023-11-21 Resolved: 2023-11-19 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Upgrades |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
From Cecilia Lovlia, updating table statistics should be part of the upgrade process. After an upgrade its always hoped queries will be better. Running around to find analyze table is an effective downtime while you are in a place where a downgrade is hard. Lets simplify this for users. upgrade mechanism used: 1. uninstall |
| Comments |
| Comment by Sergei Golubchik [ 2023-11-19 ] |
|
I don't think updating statistics is part of the upgrade. The purpose of mariadb-upgade to modify the metadata (and data if needed) to work correctly in the new server version. |
| Comment by Michael Widenius [ 2023-11-21 ] |
|
My response from the zulipchat conversation: Normally Analyze table should not be needed when upgrading and statistics from previous versions should work "the same" for newer versions. |