Hello!
While working on m5 master I realised that the nova database has not had
any writes for a year or so:
root@db1133:/srv/sqldata/nova# ls -lhrt *.ibd | tail -n5
-rw-rw---- 1 mysql mysql 48M Apr 16 2019 instance_metadata.ibd
-rw-rw---- 1 mysql mysql 2.9G Apr 16 2019 instance_system_metadata.ibd
-rw-rw---- 1 mysql mysql 484M Apr 16 2019 block_device_mapping.ibd
-rw-rw---- 1 mysql mysql 304K Apr 17 2019 compute_nodes.ibd
-rw-rw---- 1 mysql mysql 128K Apr 26 2019 services.ibd
Same for nova_api
root@db1133:/srv/sqldata# ls -lhrt nova_api/*.ibd | tail -n5
-rw-rw---- 1 mysql mysql 128K May 23 2018 nova_api/flavor_extra_specs.ibd
-rw-rw---- 1 mysql mysql 128K May 23 2018 nova_api/cell_mappings.ibd
-rw-rw---- 1 mysql mysql 96K May 23 2018 nova_api/migrate_version.ibd
-rw-rw---- 1 mysql mysql 176K Apr 16 2019 nova_api/build_requests.ibd
-rw-rw---- 1 mysql mysql 364M Apr 16 2019 nova_api/request_specs.ibd
Can those be removed?
Thanks
Manuel