Innodb And Myisam Slow Queries


i have made a topic at Stackoverflow about slow queries -

Maybe someone can help me out of this problem. It seems that the models save() method is too slow?



first you have to find out where the problem is, is your database or your code, just do insert from mysql cli

Well, thanks to the extended feature set of InnoDB (foreign key constraints etc), inserts are alway more expensive on MyISAM. But given your alerting numbers, I think your MySQL server might be terribly misconfigured. Ho many records are you trying to save in one go? And can you run the exact same queries in MySQL using EXPLAIN EXTENDED?