Description:
[15 Jun 13:10] Jon Stephens
This is from a fresh pull, build using compile-amd64-debug-max:
mysql> SELECT VERSION();
+-------------------+
| VERSION() |
+-------------------+
| 5.1.20-beta-debug |
+-------------------+
1 row in set (0.00 sec)
mysql> SHOW ENGINES;
+------------+---------+----------------------------------------------------------------+-
-------------+-----+------------+
| Engine | Support | Comment |
Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+-
-------------+-----+------------+
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
YES | YES | YES |
| 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 |
YES | NO | NO |
| ARCHIVE | YES | Archive storage engine |
NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
NO | NO | NO |
+------------+---------+----------------------------------------------------------------+-
-------------+-----+------------+
8 rows in set (0.00 sec)
mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;
+------------+---------+----------------------------------------------------------------+-
-------------+-----+------------+
| ENGINE | SUPPORT | COMMENT |
TRANSACTIONS | XA | SAVEPOINTS |
+------------+---------+----------------------------------------------------------------+-
-------------+-----+------------+
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
YES | YES | YES |
| 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 |
YES | NO | NO |
| ARCHIVE | YES | Archive storage engine |
NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
NO | NO | NO |
+------------+---------+----------------------------------------------------------------+-
-------------+-----+------------+
8 rows in set (0.00 sec)
I have verified that all the NDB executables were built, but where are the columns for
NDB? They should be present, and have the value DISABLED.
Were the server built without NDB support at all, then the columns should also be there,
but have the value NO.
See http://dev.mysql.com/doc/refman/5.1/en/show-engines.html
How to repeat:
see http://bugs.mysql.com/bug.php?id=27684
