Bug #23900 Numerous storage engines missing in Windows binaries
Submitted: 2 Nov 2006 17:10 Modified: 11 Dec 2006 4:24
Reporter: Markus Popp Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:5.1.12-beta-community-nt-log OS:Microsoft Windows (Windows)
Assigned to: Joerg Bruehe CPU Architecture:Any

[2 Nov 2006 17:10] Markus Popp
Description:
The MySQL 5.1.12 binaries lack a number of storage engines. I suspect that they only include the storage engines that went into the standard (not max) binaries earlier, but since there is no max version anymore, they should now be available in the default binaries.

The missing storage engines are FEDERATED (which I think is the most important one), EXAMPLE and BLACKHOLE.

How to repeat:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.12-beta-community-nt-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show engines;
+------------+---------+--------------------------------------------------------
----+--------------+-----+------------+
| Engine     | Support | Comment
    | Transactions | XA  | Savepoints |
+------------+---------+--------------------------------------------------------
----+--------------+-----+------------+
| ARCHIVE    | YES     | Archive storage engine
    | NO           | NO  | NO         |
| InnoDB     | DEFAULT | Supports transactions, row-level locking, and foreign k
eys | YES          | YES | YES        |
| MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance
    | NO           | NO  | NO         |
| CSV        | YES     | CSV storage engine
    | NO           | NO  | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables
    | NO           | NO  | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tabl
es  | NO           | NO  | NO         |
+------------+---------+--------------------------------------------------------
----+--------------+-----+------------+
6 rows in set (0.00 sec)
[6 Nov 2006 13:43] Valeriy Kravchuk
Thank you for a problem report.
[1 Dec 2006 11:57] Joerg Bruehe
Doing a test build with current tools, using the 5.1.15 sources;
it seems some tool change was not correctly propagated to the build machine.
[1 Dec 2006 11:58] Joerg Bruehe
Typo in above entry: 5.1.13 (thirteen), there is no 5.1.15 yet.
[1 Dec 2006 15:23] Joerg Bruehe
Extract of the "--report-features" output from that test build,
5.1.13 community   (formatting changed):

===== ENGINES =====
Engine      Support Comment                 Transactions  XA  Savepoints
EXAMPLE     YES     Example storage engine            NO  NO  NO
CSV         YES     CSV storage engine                NO  NO  NO
MyISAM      DEFAULT Default engine as ((...))         NO  NO  NO
BLACKHOLE   YES     /dev/null storage ((...))         NO  NO  NO
MRG_MYISAM  YES     Collection of identical ((...))   NO  NO  NO
InnoDB      DISABLED  Supports transactions, ((...))  YES YES YES
ARCHIVE     YES     Archive storage engine            NO  NO  NO
MEMORY      YES     Hash based, stored in ((...))     NO  NO  NO
FEDERATED   YES     Federated MySQL storage engine    YES NO  NO

I cannot explain the "InnoDB disabled" part, because various Innodb tests passed successfully,
but except of that it looks ok to me.
[11 Dec 2006 4:24] Paul Dubois
Noted in 5.1.15 changelog.

The MySQL 5.1.12 binaries for Windows were missing the FEDERATED,
EXAMPLE, and BLACKHOLE storage engines.