gt; From: Chris Nolan [mailto:[EMAIL PROTECTED]
> Sent: 12 February 2004 17:28
> To: Michael McTernan
> Cc: Mysql; Benoit St-Jean
> Subject: Re: InnoDb Table Performance problem
>
>
> Michael McTernan wrote:
>
> >Hi there,
> >
> >
> >
> >&
o complete. Using the FORCE INDEX(date) predicate,
the query time drops to about 2 seconds.
Thanks,
Mike
You're welcome! I hope that this helps you out!
Regards,
Chris
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 12:23
To: Michael McTernan
partitioning
between the tables on disk.
I'm guessing that the real problem here is that some of my queries are
secretly doing table scans when they shouldn't, and that is causing a huge
slowdown, although I might split the BLOB column into a different table such
that table scans don
Original Message-
> From: Benoit St-Jean [mailto:[EMAIL PROTECTED]
> Sent: 12 February 2004 14:04
> To: Michael McTernan
> Cc: Mysql
> Subject: Re: InnoDb Table Performance problem
>
>
> Michael McTernan wrote:
>
> >Hi,
> >
> >
> >
> >
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
BLO
Sent: 11 February 2004 22:47
To: Michael McTernan
Cc: Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB,
gt; To: Michael McTernan
> Cc: Mysql
> Subject: Re: InnoDb Table Performance problem
>
>
> Michael McTernan wrote:
>
> >Hi there,
> >
> >I'm making something similar to a file revision control system, and using
> >MySQL on Linux as the database to drive
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table holds
