Drupal and transient MySQL errors
Posted by cafuego on Wednesday 27 May 2009.A while ago Arjen Lentz blogged about transient MySQL errors that can occur when using a transactional storage engine, like say InnoDB.
Since I'm a fan of the reliability and automated recovery that InnoDB provides, I use it for all the Drupals that I host. However, on a very busy site, this may lead to deadlocks. These in turn lead to users seeing errors, which is something I'd like to avoid. Especially if the error could be prevented.