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
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 ?