Hi,
listing share servers (on xena) is taking too long or even timing out.
$ time manila share-server-list
manila share-server-list 0.98s user 0.28s system 0% cpu 5:16.89 total
I see it in the slow-queries.log of my mariadb: https://paste.opendev.org/show/bWQWZKPi5TIezltlKkx2/
Some more numbers:
select count(id) from share_servers;
1199
select count(id) from network_allocations;
3515
select count(id) from share_instances;
16402
select count(id) from share_instance_export_locations;
42332
select count(id) from share_networks;
367
select count(id) from share_network_subnets;
557
It is always joining share instances and share instance export locations in there
https://opendev.org/openstack/manila/src/branch/stable/xena/manila/db/sqlalchemy/api.py#L4195-L4201
- I think this is too heavy.
Can you help speeding this up?
Best regards,
Maurice
This issue may be similar to https:/ /bugs.launchpad .net/manila/ +bug/1831094
Additional information is at https:/ /meetings. opendev. org/meetings/ manila/ 2022/manila. 2022-03- 17-15.00. log.html