server_status_queries.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Displays query statistics for the server
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 require_once 'libraries/common.inc.php';
  10 require_once 'libraries/server_common.inc.php';
  11 require_once 'libraries/ServerStatusData.class.php';
  12 if (PMA_DRIZZLE) {
  13     $server_master_status = false;
  14     $server_slave_status = false;
  15 } else {
  16     include_once 'libraries/replication.inc.php';
  17     include_once 'libraries/replication_gui.lib.php';
  18 }
  19
  20 $ServerStatusData = new PMA_ServerStatusData();
  21
  22 $response = PMA_Response::getInstance();
  23 $header   = $response->getHeader();
  24 $scripts  = $header->getScripts();
  25 $scripts->addFile('server_status_queries.js');
  26 /* < IE 9 doesn't support canvas natively */
  27 if (PMA_USR_BROWSER_AGENT == 'IE' && PMA_USR_BROWSER_VER < 9) {
  28     $scripts->addFile('jqplot/excanvas.js');
  29 }
  30
  31 // for charting
  32 $scripts->addFile('jqplot/jquery.jqplot.js');
  33 $scripts->addFile('jqplot/plugins/jqplot.pieRenderer.js');
  34 $scripts->addFile('jqplot/plugins/jqplot.canvasTextRenderer.js');
  35 $scripts->addFile('jqplot/plugins/jqplot.canvasAxisLabelRenderer.js');
  36 $scripts->addFile('jqplot/plugins/jqplot.dateAxisRenderer.js');
  37 $scripts->addFile('jqplot/plugins/jqplot.highlighter.js');
  38 $scripts->addFile('jqplot/plugins/jqplot.cursor.js');
  39 $scripts->addFile('jquery/jquery.tablesorter.js');
  40 $scripts->addFile('server_status_sorter.js');
  41
  42 // Add the html content to the response
  43 $response->addHTML('<div>');
  44 $response->addHTML($ServerStatusData->getMenuHtml());
  45 $response->addHTML(getQueryStatisticsHtml($ServerStatusData));
  46 $response->addHTML('</div>');
  47 exit;
  48
  49 /**
  50  * Returns the html content for the query statistics
  51  *
  52  * @param object $ServerStatusData An instance of the PMA_ServerStatusData class
  53  *
  54  * @return string
  55  */
  56 function getQueryStatisticsHtml($ServerStatusData)
  57 {
  58     $retval = '';
  59
  60     $hour_factor   = 3600 / $ServerStatusData->status['Uptime'];
  61     $used_queries = $ServerStatusData->used_queries;
  62     $total_queries = array_sum($used_queries);
  63
  64     $retval .= '<h3 id="serverstatusqueries">';
  65     /* l10n: Questions is the name of a MySQL Status variable */
  66     $retval .= sprintf(
  67         __('Questions since startup: %s'),
  68         PMA_Util::formatNumber($total_queries, 0)
  69     );
  70     $retval .= ' ';
  71     $retval .= PMA_Util::showMySQLDocu(
  72         'server-status-variables',
  73         'server-status-variables',
  74         false,
  75         'statvar_Questions'
  76     );
  77     $retval .= '<br />';
  78     $retval .= '<span>';
  79     $retval .= '&oslash; ' . __('per hour') . ': ';
  80     $retval .= PMA_Util::formatNumber($total_queries * $hour_factor, 0);
  81     $retval .= '<br />';
  82     $retval .= '&oslash; ' . __('per minute') . ': ';
  83     $retval .= PMA_Util::formatNumber($total_queries * 60 / $ServerStatusData->status['Uptime'], 0);
  84     $retval .= '<br />';
  85     if ($total_queries / $ServerStatusData->status['Uptime'] >= 1) {
  86         $retval .= '&oslash; ' . __('per second') . ': ';
  87         $retval .= PMA_Util::formatNumber($total_queries / $ServerStatusData->status['Uptime'], 0);
  88     }
  89     $retval .= '</span>';
  90     $retval .= '</h3>';
  91
  92     // reverse sort by value to show most used statements first
  93     arsort($used_queries);
  94
  95     $odd_row        = true;
  96     $perc_factor    = 100 / $total_queries; //(- $ServerStatusData->status['Connections']);
  97
  98     $retval .= '<table id="serverstatusqueriesdetails" class="data sortable noclick">';
  99     $retval .= '<col class="namecol" />';
 100     $retval .= '<col class="valuecol" span="3" />';
 101     $retval .= '<thead>';
 102     $retval .= '<tr><th>' . __('Statements') . '</th>';
 103     $retval .= '<th>';
 104     /* l10n: # = Amount of queries */
 105     $retval .= __('#');
 106     $retval .= '</th>';
 107     $retval .= '<th>&oslash; ' . __('per hour') . '</th>';
 108     $retval .= '<th>%</th>';
 109     $retval .= '</tr>';
 110     $retval .= '</thead>';
 111     $retval .= '<tbody>';
 112
 113     $chart_json = array();
 114     $query_sum = array_sum($used_queries);
 115     $other_sum = 0;
 116     foreach ($used_queries as $name => $value) {
 117         $odd_row = !$odd_row;
 118         // For the percentage column, use Questions - Connections, because
 119         // the number of connections is not an item of the Query types
 120         // but is included in Questions. Then the total of the percentages is 100.
 121         $name = str_replace(array('Com_', '_'), array('', ' '), $name);
 122         // Group together values that make out less than 2% into "Other", but only
 123         // if we have more than 6 fractions already
 124         if ($value < $query_sum * 0.02 && count($chart_json)>6) {
 125             $other_sum += $value;
 126         } else {
 127             $chart_json[$name] = $value;
 128         }
 129         $retval .= '<tr class="';
 130         $retval .= $odd_row ? 'odd' : 'even';
 131         $retval .= '">';
 132         $retval .= '<th class="name">' . htmlspecialchars($name) . '</th>';
 133         $retval .= '<td class="value">';
 134         $retval .= htmlspecialchars(PMA_Util::formatNumber($value, 5, 0, true));
 135         $retval .= '</td>';
 136         $retval .= '<td class="value">';
 137         $retval .= htmlspecialchars(
 138             PMA_Util::formatNumber($value * $hour_factor, 4, 1, true)
 139         );
 140         $retval .= '</td>';
 141         $retval .= '<td class="value">';
 142         $retval .= htmlspecialchars(
 143             PMA_Util::formatNumber($value * $perc_factor, 0, 2)
 144         );
 145         $retval .= '</td>';
 146         $retval .= '</tr>';
 147     }
 148     $retval .= '</tbody>';
 149     $retval .= '</table>';
 150
 151     $retval .= '<div id="serverstatusquerieschart"></div>';
 152     $retval .= '<div id="serverstatusquerieschart_data" style="display:none;">';
 153     if ($other_sum > 0) {
 154         $chart_json[__('Other')] = $other_sum;
 155     }
 156     $retval .= htmlspecialchars(json_encode($chart_json));
 157     $retval .= '</div>';
 158
 159     return $retval;
 160 }
 161
 162 ?>