[Sysadmins] InnoDB в MySQL

[Eugene Prokopiev]

Здравствуйте!

А у нас в MySQL откючена поддержка InnoDB или я чего-то не понимаю?

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     | DISABLED | Supports transactions, row-level locking, and 
foreign keys     |
| BerkeleyDB | DISABLED | Supports transactions and page-level locking 
                  |
| BLACKHOLE  | YES      | /dev/null storage engine (anything you write 
to it disappears) |
| EXAMPLE    | NO       | Example storage engine 
                  |
| ARCHIVE    | YES      | Archive storage engine 
                  |
| CSV        | NO       | CSV storage engine 
                  |
| ndbcluster | NO       | Clustered, fault-tolerant, memory-based tables 
                 |
| FEDERATED  | NO       | Federated MySQL storage engine 
                  |
| MRG_MYISAM | YES      | Collection of identical MyISAM tables 
                  |
| ISAM       | NO       | Obsolete storage engine 
                  |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)


-- 
С уважением, Прокопьев Евгений