Hi, there,
I am in the middle of replacing a MyISAM database with InnoDB.
Queries show table status and select count are extremely slow which
gave me some pain. I am wondering if there are any other queries on
InnoDB that are significantly slower than those on MyISAM other than
these two?
Total row count is cached in the header for MyISAM tables. InnoDB has
no such mechanism for this because transactions make it impossible to
keep an exact row count. In order for InnoDB to get a row count it
has to do a full scan inside a transaction which will take a long
time. One way around
what about other functions like doing a min() or max()? are those slow
limitations of innodb tables as well?
On Mon, 14 Feb 2005 15:52:21 -0600, Eric Bergen [EMAIL PROTECTED] wrote:
Total row count is cached in the header for MyISAM tables. InnoDB has
no such mechanism for this because
min() and max() can use indexes so they shouldn't be slower.
On Mon, 14 Feb 2005 17:13:07 -0700, Ryan McCullough
[EMAIL PROTECTED] wrote:
what about other functions like doing a min() or max()? are those slow
limitations of innodb tables as well?
On Mon, 14 Feb 2005 15:52:21 -0600, Eric