On 3/23/20 9:35 AM, Manuel Arostegui wrote:
> 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?
>

I guess we are using the '_eqiad1' ones (suffix). In such cases, yes, they can
be removed.

Could please this be tracked in phabricator anyway?