libraries/server_status.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * functions for displaying server status
   5  *
   6  * @usedby  server_status.php
   7  *
   8  * @package PhpMyAdmin
   9  */
  10 use PMA\libraries\ServerStatusData;
  11
  12 /**
  13  * Prints server status information: processes, connections and traffic
  14  *
  15  * @param ServerStatusData $ServerStatusData Server status data
  16  *
  17  * @return string
  18  */
  19 function PMA_getHtmlForServerStatus($ServerStatusData)
  20 {
  21     //display the server state General Information
  22     $retval  = PMA_getHtmlForServerStateGeneralInfo($ServerStatusData);
  23
  24     //display the server state traffic information
  25     $retval .= PMA_getHtmlForServerStateTraffic($ServerStatusData);
  26
  27     //display the server state connection information
  28     $retval .= PMA_getHtmlForServerStateConnections($ServerStatusData);
  29
  30     // display replication information
  31     if ($GLOBALS['replication_info']['master']['status']
  32         || $GLOBALS['replication_info']['slave']['status']
  33     ) {
  34         $retval .= PMA_getHtmlForReplicationInfo();
  35     }
  36
  37     return $retval;
  38 }
  39
  40 /**
  41  * Prints server state General information
  42  *
  43  * @param ServerStatusData $ServerStatusData Server status data
  44  *
  45  * @return string
  46  */
  47 function PMA_getHtmlForServerStateGeneralInfo($ServerStatusData)
  48 {
  49     $start_time = $GLOBALS['dbi']->fetchValue(
  50         'SELECT UNIX_TIMESTAMP() - ' . $ServerStatusData->status['Uptime']
  51     );
  52
  53     $retval  = '<h3>';
  54     $bytes_received = $ServerStatusData->status['Bytes_received'];
  55     $bytes_sent = $ServerStatusData->status['Bytes_sent'];
  56     $retval .= sprintf(
  57         __('Network traffic since startup: %s'),
  58         implode(
  59             ' ',
  60             PMA\libraries\Util::formatByteDown(
  61                 $bytes_received + $bytes_sent,
  62                 3,
  63                 1
  64             )
  65         )
  66     );
  67     $retval .= '</h3>';
  68     $retval .= '<p>';
  69     $retval .= sprintf(
  70         __('This MySQL server has been running for %1$s. It started up on %2$s.'),
  71         PMA\libraries\Util::timespanFormat($ServerStatusData->status['Uptime']),
  72         PMA\libraries\Util::localisedDate($start_time)
  73     ) . "\n";
  74     $retval .= '</p>';
  75
  76     return $retval;
  77 }
  78
  79 /**
  80  * Returns HTML to display replication information
  81  *
  82  * @return string HTML on replication
  83  */
  84 function PMA_getHtmlForReplicationInfo()
  85 {
  86     $retval = '<p class="notice clearfloat">';
  87     if ($GLOBALS['replication_info']['master']['status']
  88         && $GLOBALS['replication_info']['slave']['status']
  89     ) {
  90         $retval .= __(
  91             'This MySQL server works as <b>master</b> and '
  92             . '<b>slave</b> in <b>replication</b> process.'
  93         );
  94     } elseif ($GLOBALS['replication_info']['master']['status']) {
  95         $retval .= __(
  96             'This MySQL server works as <b>master</b> '
  97             . 'in <b>replication</b> process.'
  98         );
  99     } elseif ($GLOBALS['replication_info']['slave']['status']) {
 100         $retval .= __(
 101             'This MySQL server works as <b>slave</b> '
 102             . 'in <b>replication</b> process.'
 103         );
 104     }
 105     $retval .= '</p>';
 106
 107     /*
 108      * if the server works as master or slave in replication process,
 109      * display useful information
 110      */
 111     $retval .= '<hr class="clearfloat" />';
 112     $retval .= '<h3><a name="replication">';
 113     $retval .= __('Replication status');
 114     $retval .= '</a></h3>';
 115     foreach ($GLOBALS['replication_types'] as $type) {
 116         if (isset($GLOBALS['replication_info'][$type]['status'])
 117             && $GLOBALS['replication_info'][$type]['status']
 118         ) {
 119             $retval .= PMA_getHtmlForReplicationStatusTable($type);
 120         }
 121     }
 122
 123     return $retval;
 124 }
 125
 126 /**
 127  * Prints server state traffic information
 128  *
 129  * @param ServerStatusData $ServerStatusData Server status data
 130  *
 131  * @return string
 132  */
 133 function PMA_getHtmlForServerStateTraffic($ServerStatusData)
 134 {
 135     $hour_factor    = 3600 / $ServerStatusData->status['Uptime'];
 136     $retval  = '<table id="serverstatustraffic" class="data noclick">';
 137     $retval .= '<thead>';
 138     $retval .= '<tr>';
 139     $retval .= '<th>';
 140     $retval .= __('Traffic') . '&nbsp;';
 141     $retval .=  PMA\libraries\Util::showHint(
 142         __(
 143             'On a busy server, the byte counters may overrun, so those statistics '
 144             . 'as reported by the MySQL server may be incorrect.'
 145         )
 146     );
 147     $retval .= '</th>';
 148     $retval .= '<th>#</th>';
 149     $retval .= '<th>&oslash; ' . __('per hour') . '</th>';
 150     $retval .= '</tr>';
 151     $retval .= '</thead>';
 152     $retval .= '<tbody>';
 153     $retval .= '<tr>';
 154     $retval .= '<th class="name">' . __('Received') . '</th>';
 155     $retval .= '<td class="value">';
 156     $retval .= implode(
 157         ' ',
 158         PMA\libraries\Util::formatByteDown(
 159             $ServerStatusData->status['Bytes_received'], 3, 1
 160         )
 161     );
 162     $retval .= '</td>';
 163     $retval .= '<td class="value">';
 164     $retval .= implode(
 165         ' ',
 166         PMA\libraries\Util::formatByteDown(
 167             $ServerStatusData->status['Bytes_received'] * $hour_factor, 3, 1
 168         )
 169     );
 170     $retval .= '</td>';
 171     $retval .= '</tr>';
 172     $retval .= '<tr>';
 173     $retval .= '<th class="name">' . __('Sent') . '</th>';
 174     $retval .= '<td class="value">';
 175     $retval .= implode(
 176         ' ',
 177         PMA\libraries\Util::formatByteDown(
 178             $ServerStatusData->status['Bytes_sent'], 3, 1
 179         )
 180     );
 181     $retval .= '</td>';
 182     $retval .= '<td class="value">';
 183     $retval .= implode(
 184         ' ',
 185         PMA\libraries\Util::formatByteDown(
 186             $ServerStatusData->status['Bytes_sent'] * $hour_factor, 3, 1
 187         )
 188     );
 189     $retval .= '</td>';
 190     $retval .= '</tr>';
 191     $retval .= '<tr>';
 192     $retval .= '<th class="name">' . __('Total') . '</th>';
 193     $retval .= '<td class="value">';
 194     $bytes_received = $ServerStatusData->status['Bytes_received'];
 195     $bytes_sent = $ServerStatusData->status['Bytes_sent'];
 196     $retval .= implode(
 197         ' ',
 198         PMA\libraries\Util::formatByteDown(
 199             $bytes_received + $bytes_sent, 3, 1
 200         )
 201     );
 202     $retval .= '</td>';
 203     $retval .= '<td class="value">';
 204     $bytes_received = $ServerStatusData->status['Bytes_received'];
 205     $bytes_sent = $ServerStatusData->status['Bytes_sent'];
 206     $retval .= implode(
 207         ' ',
 208         PMA\libraries\Util::formatByteDown(
 209             ($bytes_received + $bytes_sent) * $hour_factor, 3, 1
 210         )
 211     );
 212     $retval .= '</td>';
 213     $retval .= '</tr>';
 214     $retval .= '</tbody>';
 215     $retval .= '</table>';
 216     return $retval;
 217 }
 218
 219 /**
 220  * Prints server state connections information
 221  *
 222  * @param ServerStatusData $ServerStatusData Server status data
 223  *
 224  * @return string
 225  */
 226 function PMA_getHtmlForServerStateConnections($ServerStatusData)
 227 {
 228     $hour_factor    = 3600 / $ServerStatusData->status['Uptime'];
 229     $retval  = '<table id="serverstatusconnections" class="data noclick">';
 230     $retval .= '<thead>';
 231     $retval .= '<tr>';
 232     $retval .= '<th>' . __('Connections') . '</th>';
 233     $retval .= '<th>#</th>';
 234     $retval .= '<th>&oslash; ' . __('per hour') . '</th>';
 235     $retval .= '<th>%</th>';
 236     $retval .= '</tr>';
 237     $retval .= '</thead>';
 238     $retval .= '<tbody>';
 239     $retval .= '<tr>';
 240     $retval .= '<th class="name">' . __('Max. concurrent connections') . '</th>';
 241     $retval .= '<td class="value">';
 242     $retval .= PMA\libraries\Util::formatNumber(
 243         $ServerStatusData->status['Max_used_connections'], 0
 244     );
 245     $retval .= '</td>';
 246     $retval .= '<td class="value">--- </td>';
 247     $retval .= '<td class="value">--- </td>';
 248     $retval .= '</tr>';
 249     $retval .= '<tr>';
 250     $retval .= '<th class="name">' . __('Failed attempts') . '</th>';
 251     $retval .= '<td class="value">';
 252     $retval .= PMA\libraries\Util::formatNumber(
 253         $ServerStatusData->status['Aborted_connects'], 4, 1, true
 254     );
 255     $retval .= '</td>';
 256     $retval .= '<td class="value">';
 257     $retval .= PMA\libraries\Util::formatNumber(
 258         $ServerStatusData->status['Aborted_connects'] * $hour_factor, 4, 2, true
 259     );
 260     $retval .= '</td>';
 261     $retval .= '<td class="value">';
 262     if ($ServerStatusData->status['Connections'] > 0) {
 263         $abortNum = $ServerStatusData->status['Aborted_connects'];
 264         $connectNum = $ServerStatusData->status['Connections'];
 265
 266         $retval .= PMA\libraries\Util::formatNumber(
 267             $abortNum * 100 / $connectNum,
 268             0, 2, true
 269         );
 270         $retval .= '%';
 271     } else {
 272         $retval .= '--- ';
 273     }
 274     $retval .= '</td>';
 275     $retval .= '</tr>';
 276     $retval .= '<tr>';
 277     $retval .= '<th class="name">' . __('Aborted') . '</th>';
 278     $retval .= '<td class="value">';
 279     $retval .= PMA\libraries\Util::formatNumber(
 280         $ServerStatusData->status['Aborted_clients'], 4, 1, true
 281     );
 282     $retval .= '</td>';
 283     $retval .= '<td class="value">';
 284     $retval .= PMA\libraries\Util::formatNumber(
 285         $ServerStatusData->status['Aborted_clients'] * $hour_factor, 4, 2, true
 286     );
 287     $retval .= '</td>';
 288     $retval .= '<td class="value">';
 289     if ($ServerStatusData->status['Connections'] > 0) {
 290         $abortNum = $ServerStatusData->status['Aborted_clients'];
 291         $connectNum = $ServerStatusData->status['Connections'];
 292
 293         $retval .= PMA\libraries\Util::formatNumber(
 294             $abortNum * 100 / $connectNum,
 295             0, 2, true
 296         );
 297         $retval .= '%';
 298     } else {
 299         $retval .= '--- ';
 300     }
 301     $retval .= '</td>';
 302     $retval .= '</tr>';
 303     $retval .= '<tr>';
 304     $retval .= '<th class="name">' . __('Total') . '</th>';
 305     $retval .= '<td class="value">';
 306     $retval .= PMA\libraries\Util::formatNumber(
 307         $ServerStatusData->status['Connections'], 4, 0
 308     );
 309     $retval .= '</td>';
 310     $retval .= '<td class="value">';
 311     $retval .= PMA\libraries\Util::formatNumber(
 312         $ServerStatusData->status['Connections'] * $hour_factor, 4, 2
 313     );
 314     $retval .= '</td>';
 315     $retval .= '<td class="value">';
 316     $retval .= PMA\libraries\Util::formatNumber(100, 0, 2);
 317     $retval .= '%</td>';
 318     $retval .= '</tr>';
 319     $retval .= '</tbody>';
 320     $retval .= '</table>';
 321
 322     return $retval;
 323 }
 324