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

> mysql> SELECT COUNT(*) from RackObject;
> +----------+
> | COUNT(*) |
> +----------+
> |      875 |
> +----------+
> 
> 
> mysql> SELECT COUNT(*) from TagStorage ;
> +----------+
> | COUNT(*) |
> +----------+
> |        0 |
> +----------+
> 
> mysql-server-5.1.30

That's fine and shouldn't require more, than 1-2 seconds, even
uncached. Unless you have a really populated Port table, it is most
likely a problem of a broken table index. Could you make a schema dump
of your database (mysqldump --no-data racktables) and compare it with
the file "install/init-structure.sql" from tar.gz? I wonder if the
following tables do have the same spec, as they should have:

Port
RackObject
TagStorage
RackSpace
Rack
RackRow

-- 
    Denis Ovsienko

Other related posts: