| 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: | |
| Category: | MySQL Server: Packaging | Severity: | S3 (Non-critical) |
| Version: | 5.1.12-beta-community-nt-log | OS: | Windows (Windows) |
| Assigned to: | Joerg Bruehe | CPU Architecture: | Any |
[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.
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)