phpmyadmin/libraries/Partition.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Library for extracting information about the partitions
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * base Partition Class
  14  *
  15  * @package PhpMyAdmin
  16  */
  17 class PMA_Partition
  18 {
  19     /**
  20      * returns array of partition names for a specific db/table
  21      *
  22      * @param string $db    database name
  23      * @param string $table table name
  24      *
  25      * @access  public
  26      * @return array   of partition names
  27      */
  28     static public function getPartitionNames($db, $table)
  29     {
  30         if (PMA_Partition::havePartitioning()) {
  31             return PMA_DBI_fetch_result(
  32                 "SELECT `PARTITION_NAME` FROM `information_schema`.`PARTITIONS`"
  33                 . " WHERE `TABLE_SCHEMA` = '" . $db
  34                 . "' AND `TABLE_NAME` = '" . $table . "'"
  35             );
  36         } else {
  37             return array();
  38         }
  39     }
  40
  41     /**
  42      * checks if MySQL server supports partitioning
  43      *
  44      * @static
  45      * @staticvar boolean $have_partitioning
  46      * @staticvar boolean $already_checked
  47      * @access  public
  48      * @return boolean
  49      */
  50     static public function havePartitioning()
  51     {
  52         static $have_partitioning = false;
  53         static $already_checked = false;
  54
  55         if (! $already_checked) {
  56             if (PMA_MYSQL_INT_VERSION >= 50100) {
  57                 if (PMA_MYSQL_INT_VERSION < 50600) {
  58                     if (PMA_DBI_fetch_value(
  59                         "SHOW VARIABLES LIKE 'have_partitioning';"
  60                     )) {
  61                         $have_partitioning = true;
  62                     }
  63                 } else {
  64                     // see http://dev.mysql.com/doc/refman/5.6/en/partitioning.html
  65                     $plugins = PMA_DBI_fetch_result("SHOW PLUGINS");
  66                     foreach ($plugins as $value) {
  67                         if ($value['Name'] == 'partition') {
  68                             $have_partitioning = true;
  69                             break;
  70                         }
  71                     }
  72                 }
  73                 $already_checked = true;
  74             }
  75         }
  76         return $have_partitioning;
  77     }
  78 }
  79 ?>