Debian Codegraph @

releasenotes/notes/db-resource-indexes-8010c9a881277503.yaml

raw
1 ---
2 upgrade:
3 - |
4 The ``cinder-manage db sync`` command for this verison of cinder will add
5 additional database indexes. Depending on database size and complexity,
6 this will take time to complete for every single index to be created. On
7 MySQL or MariaDB, these indexes will only be created if an index does not
8 already exist with the same name:
9
10 * ``groups_deleted_project_id_idx``
11 * ``group_snapshots_deleted_project_id_idx``
12 * ``volumes_deleted_project_id_idx``
13 * ``volumes_deleted_host_idx``
14 * ``snapshots_deleted_project_id_idx``
15 * ``backups_deleted_project_id_idx``
16
17 An example of the SQL commands to generate these indexes can be found
18 in the `specific troubleshooting guide
19 <htts://docs.openstack.org/cinder/latest/admin/ts-db-cpu-spikes.html>`_.
20 fixes:
21 - |
22 `Bug #1952443 <https://bugs.launchpad.net/cinder/+bug/1952443>`_: Improve
23 performance for creating volume from image, listing volumes, snapshots,
24 backups, groups, and group_snapshots.