#innodb

MySQL "ERROR 1146: Table doesn't exist": the database, the case, or the files

Fix MySQL ERROR 1146 "Table doesn't exist": check the database you are in, the case of the name on Linux, migrations, and tables that exist on disk but not in InnoDB.

Beginner · 3 min read

Deadlock found

Databases

MySQL "Deadlock found when trying to get lock": read the report, retry, and stop the cycle

Fix MySQL error 1213 "Deadlock found when trying to get lock": read SHOW ENGINE INNODB STATUS, retry the transaction, lock rows in the same order and add missing indexes.

Intermediate · 4 min read