[rt-users] Re: Slow Queries

Ruslan Zakirov ruslan.zakirov at gmail.com
Sun Oct 22 17:17:04 EDT 2006


AFAIK RT doesn't execute such queries, I think you should look into
your customizations.

On 10/22/06, Asif Iqbal <vadud3 at gmail.com> wrote:
> Resending my question in case anyone missed to catch it the first time around.
>
> On 10/9/06, Asif Iqbal <vadud3 at gmail.com> wrote:
> > Hi
> >
> > I am noticing from my slow log file (5 secs) that the following query
> > on mysql 4.0.24 is taking a 11 secs
> >
> > # Query_time: 11  Lock_time: 0  Rows_sent: 299925  Rows_examined: 983836
> > use rt3;
> > SELECT * FROM Transactions where Transactions.type = 'create';
> >
> > Now looking at the explain I see
> >
> > mysql> explain SELECT * FROM Transactions where Transactions.type = 'create';
> > +--------------+------+---------------+------+---------+------+--------+-------------+
> > | table        | type | possible_keys | key  | key_len | ref  | rows
> > | Extra       |
> > +--------------+------+---------------+------+---------+------+--------+-------------+
> > | Transactions | ALL  | NULL          | NULL |    NULL | NULL | 984572
> > | Using where |
> > +--------------+------+---------------+------+---------+------+--------+-------------+
> >
> > It has to go thru about 1 million rows and not using any index.
> >
> > Is there any index, that I can create, to improve this w/o hurting any
> > other query?
> >
> > --
> > Asif Iqbal
> > PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
> >
>
>
> --
> Asif Iqbal
> PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.



More information about the rt-users mailing list