If you could post your table schema (SHOW CREATE TABLE table_name) and
then give an example of the query that is slow on InnoDB that would help
us give a better analysis. Right now it sounds like something is wrong,
InnoDB is likely to be slightly slower than MyISAM because of
transaction overhead
Suggestions? Check your indexes. It sounds as though they aren't what they
used to be. When you converted to InnoDB, did you accidentally move the
data to a slower drive? If so, you may want to move it back to where you
had the MyISAM tables.
Shawn Green
Database Administrator
Unimin Corporatio
HELLO
>> does anybody know if Foreign keys increase the performance of select
querys?
>> example.
>> DB1 has only INNODB tables.
>> DB2 has the same structure as DB1 with all possible foreign keys.
>>
> is the same query faster on DB1 or DB2?
>
>Why should it increase performance?
At the moment