CODEWITHSUNDEEP
mysqlperformanceinnodbmyisam
Roman Koncek
Roman Koncek

Reputation: 13

InnoDB to MyISAM conversion strange performance behaviour

this may be a very trivial question but i dont understand it, because afaik MyISAM should be faster

i have a database containing all MyISAM tables except one - it's simple N:M joining table with ~130k records. i dont know why only this table is InnoDB, but it wasnt intentional :) It has indexes on both foreign keys pointing to its associated tables.

I tried to change the table to MyISAM, cause i tought it would boost the performance, but instead, queries involved this table was like 50x slower (i even tried to recreate the indexes, but it didnt help). Why is that?

Upvotes: 0

Views: 262

Answers (1)

Jonathan Williamson
Jonathan Williamson

Reputation: 1189

I suspect your replacement indexes aren't getting used. Have you tried analysing the query plan with EXPLAIN? This should show you whether your indexes are being used, and how.

Just enter "EXPLAIN [yourquery];" into the MySQL console.

Upvotes: 2

Related Questions