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

Hi Denis,

Sorry I am not entirely sure if I am looking in the right place:


mysql> SELECT COUNT(*) from RackObject;
+----------+
| COUNT(*) |
+----------+
|      875 |
+----------+


mysql> SELECT COUNT(*) from TagStorage ;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+

mysql-server-5.1.30



Denis Ovsienko wrote:
>> 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?
>
>   

-- 
Simon Cox
Systems Administrator

The Bunker, Ash Radar Station,
Marshborough Road,
Ash
KENT CT13 0PL
United Kingdom

t: 01304 814 890
f: 01304 814 899
e: simon.cox@xxxxxxxxxxxxx
w: www.thebunker.net
PGP on Key Servers

Other related posts: