ROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Innodb too slow
>
> Hi Alexander,
> I believe that the the 'count()' function works differently under
> INNODB type tables. With MyISAM count(*) is stored in a 'table
> status' area, but INNODB must scan the tables
better
for you, but 'count(*)' is not impelemented the same way. Hope this
helps,
Ken
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 03, 2002 3:56 AM
Subject: Innodb too slow
> Hi,
&
Hi,
why innodb queries work MUCH slower (100 times) than if the table was of
myisam type? It's mysql 4.0.3 on FreeBSD 4.5 server. The innodb monitor
outputs many messages like the following, why are they there and what do
they mean?
Purge done for trx's n:o < 0 782 undo n:o < 0 0
Total number of
