Missed engines in 5.0 .tar.gz

[Vadim Tkachenko]

Devananda

Update:

I tested this on the .tar.gz from this link:
http://www.percona.com/downloads/Percona-Server-5.0/Percona-Server-5.0.90-21/Linux/binary/

I'm not sure if other builds are affected, but it looks like the RPM may not be affected
(iow, it has ARCHIVE).

>
> Just downloaded from our site and MySQL downloads site, and loaded in sandbox with default
> configs, to compare the engine list. Ours is missing support for blackhole, federated,
> archive, csv, federated, and ndb.
>
> :(
>
>
> deva@deva-workbox:~/sandboxes/msb_5_0_90$ ./my sql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1
> Server version: 5.0.90 MySQL Community Server (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
> mysql [localhost] {msandbox} ((none)) > 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 | YES | Supports transactions, row-level locking, and foreign keys |
> | BerkeleyDB | NO | 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 | YES | CSV storage engine |
> | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
> | FEDERATED | YES | Federated MySQL storage engine |
> | MRG_MYISAM | YES | Collection of identical MyISAM tables |
> | ISAM | NO | Obsolete storage engine |
> +------------+----------+----------------------------------------------------------------+
> 12 rows in set (0.00 sec)
>
>
>
> deva@deva-workbox:~/sandboxes/msb_5_0_90p$ ./my sql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 4
> Server version: 5.0.90 Percona SQL, Revision 70
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
> mysql [localhost] {msandbox} ((none)) > 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 | YES | Supports transactions, row-level locking, and foreign keys |
> | BerkeleyDB | NO | Supports transactions and page-level locking |
> | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
> | EXAMPLE | NO | Example storage engine |
> | ARCHIVE | NO | 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)
>

[Vadim Tkachenko (vadim-tk)]

Please make .tar.gz build the same as RPM binary

[Yasufumi Kinoshita (yasufumi-kinoshita)]

If you want such engines, you should not execute any autoconf tools...

I remember re-autoconf removes several engines.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-409