Comment 17 for bug 1918145

After several months of good performance with the FORCE INDEX patch. Here we go again with performance issues on RBAC model and it occured during a night without any intervention from us.

We will give it a try with your patch. Here's some figures about our status:

MariaDB [neutron]> select count(*) from networkrbacs;
+----------+
| count(*) |
+----------+
| 75512 |
+----------+
1 row in set (0.019 sec)

MariaDB [neutron]>

MariaDB [neutron]> select count(*) from keystone.project;
+----------+
| count(*) |
+----------+
| 3203 |
+----------+
1 row in set (0.001 sec)

MariaDB [neutron]> select count(*) from networks;
+----------+
| count(*) |
+----------+
| 103 |
+----------+
1 row in set (0.000 sec)

MariaDB [neutron]> select count(*) from networksegments;
+----------+
| count(*) |
+----------+
| 194 |
+----------+
1 row in set (0.000 sec)

Slawek / Rodolfo ? Can you have a closer on that issue if you can ?