[Tͪ#n$;<:a4sX [1($sΆLH( $yZÆ *.zh;dTkZ8긤:/#_wHzJ0/{^>Ď\,-iᏬNP!- D+%h,7Ў!PɒNL/796RpǙ)v]\F#dr!`WFZc߿v{Ėо$= oBHL QP'rêt*``vK9i Y&~lH( $yZÆ *>hO5U^L }5}fB=Vyu+pucmƧT)yVϔ^I1 kh;^lkDx7})hVds{~,~.|䂑q.^H^Q%")Sj"~81 KQ#bJ|U{P e%q(~b~^?qW I Zz<[{X\3?OD e ƨ??/^|H.ve7Sl @rm1^ȝEj5HsJZ>7Y◅[حWi)"{ݪݦv&|4T+8CwU-wYu=_ YlG(KEa\7O uq_wj@ pZSm{L͔NӏDY m&i.zNH~耩H9#F1(viTSQ2-ˆ{w@Ds=9H?3Nᾣ1#Ɏz;؋VĦi6tWX 7g~eja1]U?Eٷw lE"&u=hD4Jncgt,]k<2c~`lUI+^@e~wjEa( !̼,ÁKc`" F-itgQ O3pA)eՊ6>0 x"BC(ڒYiD>#jcasjU u0/-Ʊ؃\FF,hfbyQjdL4"ۈcPБ^'F}hC~;̮m,u(;S$2Y5`ps|Vk{y A '幹C ppK)\j+anT3Nᾣ1#Ɏz.*gүpM%뿗D = q2V18.|/(S{ؐю2!)kah LkFݽ/q%lg6+Vz-6rahlW(C&jQ5ODѨ ^WK>4UD;|3ɑ{??hPd=E.o^vɴEP<É̟5] T'7,p7{nnvㅀwXn2G7:\*+Mi_r|ey3OP<2m|<\3?OD >ZS68%yu7 LkFݽ/q%lHgXIզŕ|e’ilzz/uƑ7*'KWFXNSbuEw4 "@FZhwLQjp9{h{y=ٟX :o:3+f{??hPd=E.o^vɴ 􋏂)kMe}=&rĭ5epL/ne,'a1NB۶gHo @hfbyQjdL4"ۈcPБ^'F}hC~;̮m,u(),K2vJ( ;R jl([H V}*'KWF-peWwDϚ kHxi9{h{y=ٟgg3T4p{',BV%!\37q{??hPd=E.o^vɴx}:8󱙩&nshj 7<&M{nnvㅀwXnV(̜ HuEM ti]-x d;XFs\3?OD >ZS68%yu7 LkFݽ/q%lHgXIզŕ|e’ilzz/uƑ7*'KWF#6!o>-79t|hT9{h{y=ٟt`Ƹ+v)Aq~:u({??hPd=E.o^vɴu \<1oo'ڟI?b6qGuORPn{nnvㅀwXnV(̜ HuE,_`5q9[Ksd;XFs\3?OD >ZS68%yu7 LkFݽ/q%lg6+Vz-6rahlW(C&@` pY WZooW'ЀcҎQCwU-wYu=jgh11UUuK7Ctv\ec4eE k[4sE65;lڣ!+Gż8.mH:\C\$;$lTo/klb;^E?#|d)V2Vb3x+ֹ]S=E.o^vɴodb_table_locks' => array( 'type' => PMA_ENGINE_DETAILS_TYPE_BOOLEAN, ), 'innodb_thread_concurrency' => array( 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, ), 'innodb_thread_sleep_delay' => array( 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, ), ); } /** * Returns the pattern to be used in the query for SQL variables * related to InnoDb storage engine * * @return string SQL query LIKE pattern */ public function getVariablesLikePattern() { return 'innodb\\_%'; } /** * Get information pages * * @return array detail pages */ public function getInfoPages() { if ($this->support < PMA_ENGINE_SUPPORT_YES) { return array(); } $pages = array(); $pages['Bufferpool'] = __('Buffer Pool'); $pages['Status'] = __('InnoDB Status'); return $pages; } /** * returns html tables with stats over inno db buffer pool * * @return string html table with stats */ public function getPageBufferpool() { // The following query is only possible because we know // that we are on MySQL 5 here (checked above)! // side note: I love MySQL 5 for this. :-) $sql = ' SHOW STATUS WHERE Variable_name LIKE \'Innodb\\_buffer\\_pool\\_%\' OR Variable_name = \'Innodb_page_size\';'; $status = $GLOBALS['dbi']->fetchResult($sql, 0, 1); $output = '' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' '; // not present at least since MySQL 5.1.40 if (isset($status['Innodb_buffer_pool_pages_latched'])) { $output .= ' ' . ' ' . ' ' . ' '; } $output .= ' ' . "\n" . '
' . "\n" . ' ' . __('Buffer Pool Usage') . "\n" . '
' . "\n" . ' ' . __('Total') . "\n" . ' : ' . Util::formatNumber( $status['Innodb_buffer_pool_pages_total'], 0 ) . ' ' . __('pages') . ' / ' . join( ' ', Util::formatByteDown( $status['Innodb_buffer_pool_pages_total'] * $status['Innodb_page_size'] ) ) . "\n" . '
' . __('Free pages') . '' . Util::formatNumber( $status['Innodb_buffer_pool_pages_free'], 0 ) . '
' . __('Dirty pages') . '' . Util::formatNumber( $status['Innodb_buffer_pool_pages_dirty'], 0 ) . '
' . __('Pages containing data') . '' . Util::formatNumber( $status['Innodb_buffer_pool_pages_data'], 0 ) . "\n" . '
' . __('Pages to be flushed') . '' . Util::formatNumber( $status['Innodb_buffer_pool_pages_flushed'], 0 ) . "\n" . '
' . __('Busy pages') . '' . Util::formatNumber( $status['Innodb_buffer_pool_pages_misc'], 0 ) . "\n" . '
' . __('Latched pages') . '' . Util::formatNumber( $status['Innodb_buffer_pool_pages_latched'], 0 ) . '
' . "\n\n" . '' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . '
' . "\n" . ' ' . __('Buffer Pool Activity') . "\n" . '
' . __('Read requests') . '' . Util::formatNumber( $status['Innodb_buffer_pool_read_requests'], 0 ) . "\n" . '
' . __('Write requests') . '' . Util::formatNumber( $status['Innodb_buffer_pool_write_requests'], 0 ) . "\n" . '
' . __('Read misses') . '' . Util::formatNumber( $status['Innodb_buffer_pool_reads'], 0 ) . "\n" . '
' . __('Write waits') . '' . Util::formatNumber( $status['Innodb_buffer_pool_wait_free'], 0 ) . "\n" . '
' . __('Read misses in %') . '' . ($status['Innodb_buffer_pool_read_requests'] == 0 ? '---' : htmlspecialchars( Util::formatNumber( $status['Innodb_buffer_pool_reads'] * 100 / $status['Innodb_buffer_pool_read_requests'], 3, 2 ) ) . ' %') . "\n" . '
' . __('Write waits in %') . '' . ($status['Innodb_buffer_pool_write_requests'] == 0 ? '---' : htmlspecialchars( Util::formatNumber( $status['Innodb_buffer_pool_wait_free'] * 100 / $status['Innodb_buffer_pool_write_requests'], 3, 2 ) ) . ' %') . "\n" . '
' . "\n"; return $output; } /** * returns InnoDB status * * @return string result of SHOW ENGINE INNODB STATUS inside pre tags */ public function getPageStatus() { return '
' . "\n"
        . htmlspecialchars(
            $GLOBALS['dbi']->fetchValue('SHOW ENGINE INNODB STATUS;', 0, 'Status')
        ) . "\n"
        . '
' . "\n"; } /** * returns string with filename for the MySQL helppage * about this storage engine * * @return string mysql helppage filename */ public function getMysqlHelpPage() { return 'innodb-storage-engine'; } /** * Gets the InnoDB plugin version number * * @return string the version number, or empty if not running as a plugin */ public function getInnodbPluginVersion() { return $GLOBALS['dbi']->fetchValue('SELECT @@innodb_version;'); } /** * Gets the InnoDB file format * * (do not confuse this with phpMyAdmin's storage engine plugins!) * * @return string the InnoDB file format */ public function getInnodbFileFormat() { return $GLOBALS['dbi']->fetchValue( "SHOW GLOBAL VARIABLES LIKE 'innodb_file_format';", 0, 1 ); } /** * Verifies if this server supports the innodb_file_per_table feature * * (do not confuse this with phpMyAdmin's storage engine plugins!) * * @return boolean whether this feature is supported or not */ public function supportsFilePerTable() { return ( $GLOBALS['dbi']->fetchValue( "SHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table';", 0, 1 ) == 'ON' ); } }