May 25, 2012

Comment: Pitfalls of converting to InnoDB

… recent + standard. I’m using the PHP mysqli API and doing a basic insert into an InnoDB table. My database class starts a… insert SQL statement, and completes with a “$mysqli->commit()”. It works fine…….. …… until PHP bombs mid-way due to a coding bug. So the insert happens, but the script dies doing some other stuff before the commit