Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-409

LP #583095: Missed engines in 5.0 .tar.gz

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Vadim Tkachenko last update 01-06-2010 12:55:06

      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)
      >

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: