On Mon, Mar 23, 2020 at 1:57 PM Arturo Borrero Gonzalez < aborrero@wikimedia.org> wrote:

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.

Excellent! We can start by renaming the tables just to be fully sure

Could please this be tracked in phabricator anyway?

Yes, I didn't want to create a task just for a question, but now that the question is yes. There is one: https://phabricator.wikimedia.org/T248313

Thanks! Manuel.