RE: InnoDb Table Performance problem

2004-02-12 Thread Michael McTernan
: 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, and generally it is going very well, with the exception of one

Re: InnoDb Table Performance problem

2004-02-12 Thread Chris Nolan
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, and generally it is going very well

Re: InnoDb Table Performance problem

2004-02-12 Thread Benoit St-Jean
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

RE: InnoDb Table Performance problem

2004-02-12 Thread Michael McTernan
PROTECTED] Sent: 12 February 2004 14:04 To: Michael McTernan Cc: Mysql Subject: Re: InnoDb Table Performance problem 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

RE: InnoDb Table Performance problem

2004-02-12 Thread Michael McTernan
. Thanks, Mike -Original Message- From: Chris Nolan [mailto:[EMAIL PROTECTED] Sent: 12 February 2004 12:23 To: Michael McTernan Cc: Benoit St-Jean; Mysql Subject: Re: InnoDb Table Performance problem Michael McTernan wrote: Hi, SELECT COUNT(*) for InnoDB tables is a know

Re: InnoDb Table Performance problem

2004-02-12 Thread Chris Nolan
- From: Benoit St-Jean [mailto:[EMAIL PROTECTED] 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

RE: InnoDb Table Performance problem

2004-02-12 Thread Michael McTernan
Subject: Re: InnoDb Table Performance problem Michael McTernan wrote: Hi there, I would try to sum it up like this: 1. Discs work best when used as purely sequential devices. 2. Inserting those BLOBs takes up space somewhere. Strictly speaking, on the disc they may very well be in between

Re: InnoDb Table Performance problem

2004-02-11 Thread Benoit St-Jean
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