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

LP #820167: Partitions Support Inconsistent Support Between Versions

    Details

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

      Description

      **Reported in Launchpad by Jervin R last update 27-08-2011 03:48:37

      Paritions support does not seem to be consistently compiled in between versions at least on 5.1.54 to 5.1.57:

      [viiin@zoooe sandboxes]$ ./msb_5_1_54p/use -e "SHOW VARIABLES LIKE '%partition%'; SHOW PLUGINS;"
      ------------------------+

      Variable_name Value

      ------------------------+

      have_partitioning YES

      ------------------------+
      ------------------------------------------------------------------------

      Name Status Type Library License

      ------------------------------------------------------------------------

      binlog ACTIVE STORAGE ENGINE NULL GPL
      partition ACTIVE STORAGE ENGINE NULL GPL

      ...
      ------------------------------------------------------------------------
      [viiin@zoooe sandboxes]$ ./msb_5_1_55p/use -e "SHOW VARIABLES LIKE '%partition%'; SHOW PLUGINS;"
      ------------------------+

      Variable_name Value

      ------------------------+

      have_partitioning NO

      ------------------------+
      ----------------------------------------------------------------------

      Name Status Type Library License

      ----------------------------------------------------------------------

      binlog ACTIVE STORAGE ENGINE NULL GPL
      CSV ACTIVE STORAGE ENGINE NULL GPL

      ...
      ----------------------------------------------------------------------
      [viiin@zoooe sandboxes]$ ./msb_5_1_56p/use -e "SHOW VARIABLES LIKE '%partition%'; SHOW PLUGINS;"
      ------------------------+

      Variable_name Value

      ------------------------+

      have_partitioning NO

      ------------------------+
      -------------------------------------------------------------------------------

      Name Status Type Library License

      -------------------------------------------------------------------------------

      binlog ACTIVE STORAGE ENGINE NULL GPL
      CSV ACTIVE STORAGE ENGINE NULL GPL

      ...
      -------------------------------------------------------------------------------
      [viiin@zoooe sandboxes]$ ./msb_5_1_57p/use -e "SHOW VARIABLES LIKE '%partition%'; SHOW PLUGINS;"
      ------------------------+

      Variable_name Value

      ------------------------+

      have_partitioning YES

      ------------------------+
      ------------------------------------------------------------------------

      Name Status Type Library License

      ------------------------------------------------------------------------

      binlog ACTIVE STORAGE ENGINE NULL GPL
      partition ACTIVE STORAGE ENGINE NULL GPL

      ...
      ------------------------------------------------------------------------

      The default engines seems to be inconsistent between builds as well.

      [viiin@zoooe sandboxes]$ ./msb_5_1_54p/use -e "SHOW ENGINES";
      -----------------------------------------------------------------------------------------------------------------------+

      Engine Support Comment Transactions XA Savepoints

      -----------------------------------------------------------------------------------------------------------------------+

      InnoDB YES Percona-XtraDB, 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 NO Federated MySQL storage engine NULL NULL NULL
      ARCHIVE YES Archive storage engine NO NO NO
      MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance NO NO NO

      -----------------------------------------------------------------------------------------------------------------------+
      [viiin@zoooe sandboxes]$ ./msb_5_1_55p/use -e "SHOW ENGINES";
      -----------------------------------------------------------------------------------------------------------------------+

      Engine Support Comment Transactions XA Savepoints

      -----------------------------------------------------------------------------------------------------------------------+

      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 tables NO NO NO
      InnoDB YES Percona-XtraDB, Supports transactions, row-level locking, and foreign keys YES YES YES
      MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance NO NO NO

      -----------------------------------------------------------------------------------------------------------------------+
      [viiin@zoooe sandboxes]$ ./msb_5_1_56p/use -e "SHOW ENGINES";
      -----------------------------------------------------------------------------------------------------------------------+

      Engine Support Comment Transactions XA Savepoints

      -----------------------------------------------------------------------------------------------------------------------+

      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 tables NO NO NO
      InnoDB YES Percona-XtraDB, Supports transactions, row-level locking, and foreign keys YES YES YES
      MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance NO NO NO

      -----------------------------------------------------------------------------------------------------------------------+
      [viiin@zoooe sandboxes]$ ./msb_5_1_57p/use -e "SHOW ENGINES";
      -----------------------------------------------------------------------------------------------------------------------+

      Engine Support Comment Transactions XA Savepoints

      -----------------------------------------------------------------------------------------------------------------------+

      InnoDB YES Percona-XtraDB, 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 NO Federated MySQL storage engine NULL NULL NULL
      ARCHIVE YES Archive storage engine NO NO NO
      MyISAM DEFAULT Default engine as of MySQL 3.23 with great performance NO NO NO

      -----------------------------------------------------------------------------------------------------------------------+

        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: