I migrated our myISAM engine to InnoDB Engine and the performance is so poor after that and did some performance tuning based on above guidance. Now our MYSQL database is running faster and have a better performance. Thank for sharing
Comment: Pitfalls of converting to InnoDB
February 25, 2007 By 16 Comments
Why is this error happening ? I converted a big database to InnoDB and I’m seeing this error randomly, the amount of code to change is huge and I’m considering migrating back to myisam because of this. Is there anyway this error can be solved at the mysql server level ?
Comment: COUNT(*) for Innodb Tables
December 2, 2006 By 32 Comments
… be fixed. I forgot about this when I migrated a couple of table sot MyISAM. We were computing COUNT in order to… need a 100% accurate count. They just need lazy data. INNODB should add the ability to get this even if it…
