[racktables-users] Re: Racktables - Slow Query Speed after upgrade.

> I recently tried upgrading from 16.5 to 17.6.  Everything seemed ok
> running upgrade.php.  However the system is dogged by a slow query when
> clicking the Objects tab on the main page.  The query is taking about 50
> seconds rather than < 0.02 secs before upgrade.  I have tried to trace
> back by checking previous releases and the problem seems to start
> between upgrading from 16.6 and 17.0.  The query in the mysql slowlog is:

Hello.

All 0.17.x releases are normally a bit slower, than 0.16.x ones; that
was the price of enhanced filtering feature. But 60 seconds isn't
normal in any way for this query. How many objects and tags are there
in your database? Which MySQL server version do you use?

-- 
    Denis Ovsienko

Other related posts: