Janusz Krzysztofik wrote:
> ...
> I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
> ASPseek application. I decided to try InnoDB in order to be able
> to update tables while performing time consuming selects.
> After converting all tables to InnoDB I noticed a big difference
>
Hi,
> > > You are not using any indicies, because there aren't any that could be
> > > used in this query.
> > > Try adding an index on (status,deleted)
> >
> > I wonder: how many possible different values would such an index
> > return?
>
> mysql> select distinct status, deleted from urlword;
> +
Martijn Tonies wrote:
>
> Hi,
>
> > You are not using any indicies, because there aren't any that could be
> > used in this query.
> > Try adding an index on (status,deleted)
>
> I wonder: how many possible different values would such an index
> return?
mysql> select distinct status, deleted fr
Hi,
> You are not using any indicies, because there aren't any that could be
> used in this query.
> Try adding an index on (status,deleted)
I wonder: how many possible different values would such an index
return? If this is a (very) low value, won't the index make things
slower (if it's being u
TED]
> Envoyé : lundi 24 novembre 2003 13:58
> A : [EMAIL PROTECTED]
> Objet : Big difference in MyISAM and InnoDB SELECT speed
>
> Hello,
>
> I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
> ASPseek application. I decided to try InnoDB in order to
De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED]
Envoyé : lundi 24 novembre 2003 13:58
A : [EMAIL PROTECTED]
Objet : Big difference in MyISAM and InnoDB SELECT speed
Hello,
I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
ASPseek application. I decided to try InnoDB in order to
evant one).
>
> Have you done an EXPLAIN on your query ?
>
> May be an index on (origin,status,deleted) could help.
>
> Marc.
>
> -Message d'origine-
> De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED]
> Envoyé : lundi 24 novembre 2003 13:58
> A : [E
nvoyé : lundi 24 novembre 2003 13:58
A : [EMAIL PROTECTED]
Objet : Big difference in MyISAM and InnoDB SELECT speed
Hello,
I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
ASPseek application. I decided to try InnoDB in order to be able
to update tables while performing time cons
Hello,
I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
ASPseek application. I decided to try InnoDB in order to be able
to update tables while performing time consuming selects.
After converting all tables to InnoDB I noticed a big difference
in processing speed of one of the
