| 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. |