share server list slow

Bug #1964089 reported by Maurice Escher
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Shared File Systems Service (Manila)
In Progress
Felipe Rodrigues

Bug Description


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:

Some more numbers:
select count(id) from share_servers;
select count(id) from network_allocations;
select count(id) from share_instances;
select count(id) from share_instance_export_locations;
select count(id) from share_networks;
select count(id) from share_network_subnets;

It is always joining share instances and share instance export locations in there
 - I think this is too heavy.

Can you help speeding this up?

Best regards,

Vida Haririan (vhariria)
Changed in manila:
importance: Undecided → Low
Changed in manila:
assignee: nobody → Carlos Eduardo (silvacarlose)
Revision history for this message
Vida Haririan (vhariria) wrote :
Changed in manila:
status: New → Triaged
Changed in manila:
assignee: Carlos Eduardo (silvacarlose) → Felipe Rodrigues (felipefutty)
Revision history for this message
Helena (helenadantas) wrote :

Two scenarios were used to reproduce this bug:

For the first scenario, 1000 shares and 50 shares servers were created (using 50 shares networks). The running time to list the share-servers was:
0.12s user 0.0s system
For the second scenario, 2000 shares and 100 shares servers were created (using 100 shares network). The running time to list the share-servers was:
0.22s user 0.1s system

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to manila (master)

Fix proposed to branch: master

Changed in manila:
status: Triaged → In Progress
Changed in manila:
milestone: none → bobcat-3
Changed in manila:
milestone: bobcat-3 → bobcat-rc1
Changed in manila:
milestone: bobcat-rc1 → caracal-1
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.