Check For InnoDB Support

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

This is an old revision of the document!


The InnoDB storage engine for MySQL is required for Magento. Here’s how to check if this 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