Troubleshooting

The following general guidelines apply to troubleshooting InnoDB problems:
- When an operation fails, look at the MySQL server error log.
  - It is usually the file in the data directory that has a suffix of .err
- When troubleshooting, it is usually best to run the MySQL server from the command prompt, rather than through the mysqld_safe wrapper.
- Run CHECK TABLE on tables that may be corrupt.

Let us review the chapter.