Enable InnoDB in MySQL

[aED]

Can anyone help me on how to enable InnoDB in MySQL

Code Select Expand


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


[aED]

Also while searching for ways on how to do it I found this It says that it uses more memory when InnoDB is enabled then how can it make my forum faster?

http://mediakey.dk/~cc/optimize-mysql-for-low-memory-use/comment-page-1/

[青山 素子]

If InnoDB is disabled, first check and see if skip-innodb is in the service script or my.cnf. If it is not, you'll either need to re-compile MySQL to include support, or see if your distribution has that engine broken out to a different package.

Also while searching for ways on how to do it I found this It says that it uses more memory when InnoDB is enabled then how can it make my forum faster?

Yes, additional database engines mean MySQL will use more memory. InnoDB is designed to lock only at the table row level, which means that unlike MyISAM, write operations to a table will not block read operations. This means that for very busy forums, you will have a speed increase because the table won't be locked as much.