Check For InnoDB Support

Last modified by Crucial on Sun, January 25, 2009 17:45
Source|Old Revisions  |  Back To Group

This is an old revision of the document!


According to the system requirements for Magento, the InnoDB storage engine for MySQL is required.

Here’s how to check if InnoDB is enabled:

1. Open up phpMyAdmin

2. Click on the Storage Engines link on the main screen.

3. If InnoDB is enabled, it will show up in blue:

You can also check if InnoDB is enabled from shell:

1. Connect to MySQL:

  1. mysql -u DBUSER -p

2. Run the following query:

  1. SHOW ENGINES;

3. You should see output similar to the following:

mysql> SHOW ENGINES;
+------------+----------+----------------------------------------------------------------+
| Engine     | Support  | Comment                                                        |
+------------+----------+----------------------------------------------------------------+
| MyISAM     | DEFAULT  | Default engine as of MySQL 3.23 with great performance         |
| MEMORY     | YES      | Hash based, stored in memory, useful for temporary tables      |
| InnoDB     | YES      | Supports transactions, row-level locking, and foreign keys     |
| BerkeleyDB | NO       | Supports transactions and page-level locking                   |
| BLACKHOLE  | YES      | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE    | YES      | Example storage engine                                         |
| ARCHIVE    | YES      | Archive storage engine                                         |
| CSV        | YES      | CSV storage engine                                             |
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables                 |
| FEDERATED  | YES      | Federated MySQL storage engine                                 |
| MRG_MYISAM | YES      | Collection of identical MyISAM tables                          |
| ISAM       | NO       | Obsolete storage engine                                        |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

If InnoDB is enabled, it will have a YES next to it.




 

Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs