# InnoDB Troubleshooting Overview

As with most errors, first take a look at the contents of the [MariaDB error log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/error-log). If dealing with a deadlock, setting the [innodb\_print\_all\_deadlocks](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) option (off by default) will output details of all deadlocks to the error log.

It can also help to enable the various [InnoDB Monitors](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-monitors) relating to the problem you are experiencing. There are four types: the standard InnoDB monitor, the InnoDB Lock Monitor, InnoDB Tablespace Monitor and the InnoDB Table Monitor.

Running [CHECK TABLE](https://mariadb.com/docs/server/reference/sql-statements/table-statements/check-table) will help determine whether there are errors in the table.

For problems with the InnoDB Data Dictionary, see [InnoDB Data Dictionary Troubleshooting](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-troubleshooting/innodb-data-dictionary-troubleshooting).

## See Also

* [InnoDB Data Dictionary Troubleshooting](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-troubleshooting/innodb-data-dictionary-troubleshooting)
* [InnoDB Recovery Modes](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-troubleshooting/innodb-recovery-modes)
* [Error Codes](https://mariadb.com/docs/server/reference/error-codes)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}