/admin/phpMyAdmin_old/libraries/engines/innodb.lib.php

https://bitbucket.org/steve_delbar/iepsm-projet-de-d-veloppement-internet-2013 · PHP · 193 lines · 182 code · 6 blank · 5 comment · 7 complexity · b598a929e9946a78df2eed393f419d38 MD5 · raw file 

    

  1. <?php
    2. 

  2. /* $Id: innodb.lib.php,v 2.5 2005/03/26 23:34:26 rabus Exp $ */
    3. 

  3. // vim: expandtab sw=4 ts=4 sts=4:
    4. 

  4. 

  5. class PMA_StorageEngine_innodb extends PMA_StorageEngine {
    6. 

  6.     function getVariables() {
    7. 

  7.         return array(
    8. 

  8.             'innodb_data_home_dir' => array(
    9. 

  9.                 'title' => $GLOBALS['strInnoDBDataHomeDir'],
    10. 

  10.                 'desc'  => $GLOBALS['strInnoDBDataHomeDirDesc']
    11. 

  11.             ),
    12. 

  12.             'innodb_data_file_path' => array(
    13. 

  13.                 'title' => $GLOBALS['strInnoDBDataFilePath']
    14. 

  14.             ),
    15. 

  15.             'innodb_autoextend_increment' => array(
    16. 

  16.                 'title' => $GLOBALS['strInnoDBAutoextendIncrement'],
    17. 

  17.                 'desc'  => $GLOBALS['strInnoDBAutoextendIncrementDesc'],
    18. 

  18.                 'type'  => PMA_ENGINE_DETAILS_TYPE_NUMERIC
    19. 

  19.             ),
    20. 

  20.             'innodb_buffer_pool_size' => array(
    21. 

  21.                 'title' => $GLOBALS['strInnoDBBufferPoolSize'],
    22. 

  22.                 'desc'  => $GLOBALS['strInnoDBBufferPoolSizeDesc'],
    23. 

  23.                 'type'  => PMA_ENGINE_DETAILS_TYPE_SIZE
    24. 

  24.             )
    25. 

  25.         );
    26. 

  26.     }
    27. 

  27. 

  28.     function getVariablesLikePattern () {
    29. 

  29.         return 'innodb\\_%';
    30. 

  30.     }
    31. 

  31. 

  32.     function getInfoPages () {
    33. 

  33.         if ($this->support < PMA_ENGINE_SUPPORT_YES) {
    34. 

  34.             return array();
    35. 

  35.         }
    36. 

  36.         $pages = array();
    37. 

  37.         if (PMA_MYSQL_INT_VERSION >= 50002) {
    38. 

  38.             $pages['bufferpool'] = $GLOBALS['strBufferPool'];
    39. 

  39.         }
    40. 

  40.         $pages['status'] = $GLOBALS['strInnodbStat'];
    41. 

  41.         return $pages;
    42. 

  42.     }
    43. 

  43. 

  44.     function getPage($id) {
    45. 

  45.         global $cfg;
    46. 

  46. 

  47.         switch ($id) {
    48. 

  48.             case 'bufferpool':
    49. 

  49.                 if (PMA_MYSQL_INT_VERSION < 50002) {
    50. 

  50.                     return FALSE;
    51. 

  51.                 }
    52. 

  52.                 // rabus: The following query is only possible because we know
    53. 

  53.                 // that we are on MySQL 5 here (checked above)!
    54. 

  54.                 // side note: I love MySQL 5 for this. :-)
    55. 

  55.                 $res = PMA_DBI_query('SHOW STATUS WHERE Variable_name LIKE \'Innodb\\_buffer\\_pool\\_%\' OR Variable_name = \'Innodb_page_size\';');
    56. 

  56.                 $status = array();
    57. 

  57.                 while ($row = PMA_DBI_fetch_row($res)) {
    58. 

  58.                     $status[$row[0]] = $row[1];
    59. 

  59.                 }
    60. 

  60.                 PMA_DBI_free_result($res);
    61. 

  61.                 unset($res, $row);
    62. 

  62.                 $output = '<table>' . "\n"
    63. 

  63.                         . '    <thead>' . "\n"
    64. 

  64.                         . '        <tr>' . "\n"
    65. 

  65.                         . '            <th colspan="4">' . "\n"
    66. 

  66.                         . '                ' . $GLOBALS['strBufferPoolUsage'] . "\n"
    67. 

  67.                         . '            </th>' . "\n"
    68. 

  68.                         . '        </tr>' . "\n"
    69. 

  69.                         . '    </thead>' . "\n"
    70. 

  70.                         . '    <tfoot>' . "\n"
    71. 

  71.                         . '        <tr>' . "\n"
    72. 

  72.                         . '            <th>' . "\n"
    73. 

  73.                         . '                ' . $GLOBALS['strTotalUC'] . "\n"
    74. 

  74.                         . '            </th>' . "\n"
    75. 

  75.                         . '            <th colspan="3">' . "\n"
    76. 

  76.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_total']) . '&nbsp;' . $GLOBALS['strInnoDBPages'] . '&nbsp;/ ' . join('&nbsp;', PMA_formatByteDown($status['Innodb_buffer_pool_pages_total'] * $status['Innodb_page_size'])) . "\n"
    77. 

  77.                         . '            </th>' . "\n"
    78. 

  78.                         . '        </tr>' . "\n"
    79. 

  79.                         . '    </tfoot>' . "\n"
    80. 

  80.                         . '    <tbody>' . "\n"
    81. 

  81.                         . '        <tr>' . "\n"
    82. 

  82.                         . '            <td bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    83. 

  83.                         . '                &nbsp;' . $GLOBALS['strFreePages'] . '&nbsp;' . "\n"
    84. 

  84.                         . '            </td>' . "\n"
    85. 

  85.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    86. 

  86.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_free']) . "\n"
    87. 

  87.                         . '            </td>' . "\n"
    88. 

  88.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    89. 

  89.                         . '                &nbsp;' . $GLOBALS['strDirtyPages'] . '&nbsp;' . "\n"
    90. 

  90.                         . '            </td>' . "\n"
    91. 

  91.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    92. 

  92.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_dirty']) . "\n"
    93. 

  93.                         . '            </td>' . "\n"
    94. 

  94.                         . '        </tr>' . "\n"
    95. 

  95.                         . '        <tr>' . "\n"
    96. 

  96.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    97. 

  97.                         . '                &nbsp;' . $GLOBALS['strDataPages'] . '&nbsp;' . "\n"
    98. 

  98.                         . '            </td>' . "\n"
    99. 

  99.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    100. 

  100.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_data']) . "\n"
    101. 

  101.                         . '            </td>' . "\n"
    102. 

  102.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    103. 

  103.                         . '                &nbsp;' . $GLOBALS['strPagesToBeFlushed'] . '&nbsp;' . "\n"
    104. 

  104.                         . '            </td>' . "\n"
    105. 

  105.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    106. 

  106.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_flushed']) . "\n"
    107. 

  107.                         . '            </td>' . "\n"
    108. 

  108.                         . '        </tr>' . "\n"
    109. 

  109.                         . '        <tr>' . "\n"
    110. 

  110.                         . '            <td bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    111. 

  111.                         . '                &nbsp;' . $GLOBALS['strBusyPages'] . '&nbsp;' . "\n"
    112. 

  112.                         . '            </td>' . "\n"
    113. 

  113.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    114. 

  114.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_misc']) . "\n"
    115. 

  115.                         . '            </td>' . "\n"
    116. 

  116.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    117. 

  117.                         . '                &nbsp;' . $GLOBALS['strLatchedPages'] . '&nbsp;' . "\n"
    118. 

  118.                         . '            </td>' . "\n"
    119. 

  119.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    120. 

  120.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_pages_latched']) . "\n"
    121. 

  121.                         . '            </td>' . "\n"
    122. 

  122.                         . '        </tr>' . "\n"
    123. 

  123.                         . '    </tbody>' . "\n"
    124. 

  124.                         . '</table>' . "\n\n"
    125. 

  125.                         . '<br />' . "\n\n"
    126. 

  126.                         . '<table>' . "\n"
    127. 

  127.                         . '    <thead>' . "\n"
    128. 

  128.                         . '        <tr>' . "\n"
    129. 

  129.                         . '            <th colspan="4">' . "\n"
    130. 

  130.                         . '                ' . $GLOBALS['strBufferPoolActivity'] . "\n"
    131. 

  131.                         . '            </th>' . "\n"
    132. 

  132.                         . '        </tr>' . "\n"
    133. 

  133.                         . '    </thead>' . "\n"
    134. 

  134.                         . '    <tbody>' . "\n"
    135. 

  135.                         . '        <tr>' . "\n"
    136. 

  136.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    137. 

  137.                         . '                &nbsp;' . $GLOBALS['strReadRequests'] . '&nbsp;' . "\n"
    138. 

  138.                         . '            </td>' . "\n"
    139. 

  139.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    140. 

  140.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_read_requests']) . "\n"
    141. 

  141.                         . '            </td>' . "\n"
    142. 

  142.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    143. 

  143.                         . '                &nbsp;' . $GLOBALS['strWriteRequests'] . '&nbsp;' . "\n"
    144. 

  144.                         . '            </td>' . "\n"
    145. 

  145.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    146. 

  146.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_write_requests']) . "\n"
    147. 

  147.                         . '            </td>' . "\n"
    148. 

  148.                         . '        </tr>' . "\n"
    149. 

  149.                         . '        <tr>' . "\n"
    150. 

  150.                         . '            <td bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    151. 

  151.                         . '                &nbsp;' . $GLOBALS['strBufferReadMisses'] . '&nbsp;' . "\n"
    152. 

  152.                         . '            </td>' . "\n"
    153. 

  153.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    154. 

  154.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_reads']) . "\n"
    155. 

  155.                         . '            </td>' . "\n"
    156. 

  156.                         . '            <td bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    157. 

  157.                         . '                &nbsp;' . $GLOBALS['strBufferWriteWaits'] . '&nbsp;' . "\n"
    158. 

  158.                         . '            </td>' . "\n"
    159. 

  159.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    160. 

  160.                         . '                ' . htmlspecialchars($status['Innodb_buffer_pool_wait_free']) . "\n"
    161. 

  161.                         . '            </td>' . "\n"
    162. 

  162.                         . '        </tr>' . "\n"
    163. 

  163.                         . '        <tr>' . "\n"
    164. 

  164.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    165. 

  165.                         . '                &nbsp;' . $GLOBALS['strBufferReadMissesInPercent'] . '&nbsp;' . "\n"
    166. 

  166.                         . '            </td>' . "\n"
    167. 

  167.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    168. 

  168.                         . '                ' . ($status['Innodb_buffer_pool_read_requests'] == 0 ? '---' : htmlspecialchars(number_format($status['Innodb_buffer_pool_reads'] * 100 / $status['Innodb_buffer_pool_read_requests'], 2, $GLOBALS['number_decimal_separator'], $GLOBALS['number_thousands_separator'])) . '&nbsp;%') . "\n"
    169. 

  169.                         . '            </td>' . "\n"
    170. 

  170.                         . '            <td bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
    171. 

  171.                         . '                &nbsp;' . $GLOBALS['strBufferWriteWaitsInPercent'] . '&nbsp;' . "\n"
    172. 

  172.                         . '            </td>' . "\n"
    173. 

  173.                         . '            <td align="right" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n"
    174. 

  174.                         . '                ' . ($status['Innodb_buffer_pool_write_requests'] == 0 ? '---' : htmlspecialchars(number_format($status['Innodb_buffer_pool_wait_free'] * 100 / $status['Innodb_buffer_pool_write_requests'], 2, $GLOBALS['number_decimal_separator'], $GLOBALS['number_thousands_separator'])) . '&nbsp;%') . "\n"
    175. 

  175.                         . '            </td>' . "\n"
    176. 

  176.                         . '        </tr>' . "\n"
    177. 

  177.                         . '    </tbody>' . "\n"
    178. 

  178.                         . '</table>' . "\n";
    179. 

  179.                 return $output;
    180. 

  180.             case 'status':
    181. 

  181.                 $res = PMA_DBI_query('SHOW INNODB STATUS;');
    182. 

  182.                 $row = PMA_DBI_fetch_row($res);
    183. 

  183.                 PMA_DBI_free_result($res);
    184. 

  184.                 return '<pre>' . "\n"
    185. 

  185.                       . htmlspecialchars($row[0]) . "\n"
    186. 

  186.                       . '</pre>' . "\n";
    187. 

  187.             default:
    188. 

  188.                 return FALSE;
    189. 

  189.         }
    190. 

  190.     }
    191. 

  191. }
    192. 

  192. 

  193. ?>
    194.