Date: Wed, 18 Sep 2002 05:46:39 -0400
From: [EMAIL PROTECTED]
InnoDB table
============
Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And
Cod>'059336') Or Nom>'a2618' Order by Nom ASC, Cod ASC Limit 50;
Time:0.08 secs.
Handler_read_next: 1850
MyIsam table
============
Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And
Cod>'059336') Or Nom>'a2618' Order by Nom ASC, Cod ASC Limit 50;
Time:0.00 secs.
Handler_read_next: 49
Fix:
-
Synopsis:optimizer bug in selecting fields that donīt belong to the index used by
mysql/innodb
Exectutable: mysqld-max-nt
---------------------------------------------------------------------------------------------------
Since I have the same, but worst, problem with poor performance with
innoDB compared to myISAM, it's not some fluke. However, since an
award was just issued for innoDB, it's probably not the optimizer as
you suggest.
I'd bet that the problem is in the table conversion.
ALTER TABLE xxxx TYPE=innoDB
is not the right way to convert.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
