server_status.php

一个用PHP编写的

<div id="sectionlinks">
<?php
foreach ( $sections as $section_name => $section ) {
    if ( ! empty( $section['vars'] ) && ! empty( $section['title'] ) ) {
        echo '<a href="' . $PHP_SELF . '?' .
             PMA_generate_common_url() . '#' . $section_name . '">' .
             $section['title'] . '</a>' . "\n";
    }
}
?>
</div>

<h3><?php echo $strServerTrafficNotes; ?></h3>

<table id="serverstatustraffic" class="data">
<thead>
<tr>
    <th colspan="2"><?php echo $strTraffic . '&nbsp;' . PMA_showHint($strStatisticsOverrun); ?></th>
    <th>&oslash; <?php echo $strPerHour; ?></th>
</tr>
</thead>
<tbody>
<tr class="odd">
    <th class="name"><?php echo $strReceived; ?></th>
    <td class="value"><?php echo
        implode(' ',
            PMA_formatByteDown( $server_status['Bytes_received'], 3 ) ); ?></td>
    <td class="value"><?php echo
        implode(' ',
            PMA_formatByteDown(
                $server_status['Bytes_received'] * $hour_factor, 3 ) ); ?></td>
</tr>
<tr class="even">
    <th class="name"><?php echo $strSent; ?></th>
    <td class="value"><?php echo
        implode(' ',
            PMA_formatByteDown( $server_status['Bytes_sent'], 3 ) ); ?></td>
    <td class="value"><?php echo
        implode(' ',
            PMA_formatByteDown(
                $server_status['Bytes_sent'] * $hour_factor, 3 ) ); ?></td>
</tr>
<tr class="odd">
    <th class="name"><?php echo $strTotalUC; ?></th>
    <td class="value"><?php echo
        implode(' ',
            PMA_formatByteDown(
                $server_status['Bytes_received'] + $server_status['Bytes_sent'], 3 )
        ); ?></td>
    <td class="value"><?php echo
        implode(' ',
            PMA_formatByteDown(
                ($server_status['Bytes_received'] + $server_status['Bytes_sent'])
                * $hour_factor, 3 )
        ); ?></td>
</tr>
</tbody>
</table>

<table id="serverstatusconnections" class="data">
<thead>
<tr>
    <th colspan="2"><?php echo $strConnections; ?></th>
    <th>&oslash; <?php echo $strPerHour; ?></th>
    <th>%</th>
</tr>
</thead>
<tbody>
<tr class="odd">
    <th class="name"><?php echo $strMaxConnects; ?></th>
    <td class="value"><?php echo
        number_format( $server_status['Max_used_connections'], 0,
            $GLOBALS['number_decimal_separator'],
            $GLOBALS['number_thousands_separator']); ?>  </td>
    <td class="value">--- </td>
    <td class="value">--- </td>
</tr>
<tr class="even">
    <th class="name"><?php echo $strFailedAttempts; ?></th>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Aborted_connects'], 4, 0 ); ?></td>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Aborted_connects'] * $hour_factor,
            4, 2 ); ?></td>
    <td class="value"><?php echo
        $server_status['Connections'] > 0
      ? number_format(
            $server_status['Aborted_connects'] * 100 / $server_status['Connections'],
            2, $GLOBALS['number_decimal_separator'],
            $GLOBALS['number_thousands_separator'] ) . '%'
      : '--- '; ?></td>
</tr>
<tr class="odd">
    <th class="name"><?php echo $strAbortedClients; ?></th>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Aborted_clients'], 4, 0 ); ?></td>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Aborted_clients'] * $hour_factor,
            4, 2 ); ?></td>
    <td class="value"><?php echo
        $server_status['Connections'] > 0
      ? number_format(
            $server_status['Aborted_clients'] * 100 / $server_status['Connections'],
            2, $GLOBALS['number_decimal_separator'],
            $GLOBALS['number_thousands_separator']) . '%'
      : '--- '; ?></td>
</tr>
<tr class="even">
    <th class="name"><?php echo $strTotalUC; ?></th>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Connections'], 4, 0 ); ?></td>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Connections'] * $hour_factor,
            4, 2 ); ?></td>
    <td class="value"><?php echo
        number_format( 100, 2, $GLOBALS['number_decimal_separator'],
            $GLOBALS['number_thousands_separator'] ); ?>%</td>
</tr>
</tbody>
</table>

<hr class="clearfloat" />

<h3><?php echo
    sprintf( $strQueryStatistics,
        number_format($server_status['Questions'],
            0, $GLOBALS['number_decimal_separator'],
            $GLOBALS['number_thousands_separator'] ) ); ?></h3>

<table id="serverstatusqueriessummary" class="data">
<thead>
<tr>
    <th><?php echo $strTotalUC; ?></th>
    <th>&oslash; <?php echo $strPerHour; ?></th>
    <th>&oslash; <?php echo $strPerMinute; ?></th>
    <th>&oslash; <?php echo $strPerSecond; ?></th>
</tr>
</thead>
<tbody>
<tr class="odd">
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Questions'], 3, 0 ); ?></td>
    <td class="value"><?php echo
        PMA_formatNumber( $server_status['Questions'] * $hour_factor,
            3, 2 ); ?></td>
    <td class="value"><?php echo
        PMA_formatNumber(
            $server_status['Questions'] * 60 / $server_status['Uptime'],
            3, 2 ); ?></td>
    <td class="value"><?php echo
        PMA_formatNumber(
            $server_status['Questions'] / $server_status['Uptime'],
            3, 2 ); ?></td>
</tr>
</tbody>
</table>

<div id="serverstatusqueriesdetails">
<?php
// number of tables to split values into
$tables         = 2;
$rows_per_table = (int) ceil( count( $sections['com']['vars'] ) / $tables );
$current_table  = 0;
$odd_row        = true;
$countRows      = 0;
$perc_factor    = 100 / ( $server_status['Questions'] - $server_status['Connections'] );
foreach ( $sections['com']['vars'] as $name => $value ) {
    $current_table++;
    if ( $countRows === 0 || $countRows === $rows_per_table ) {
        $odd_row = true;
        if ( $countRows === $rows_per_table ) {
            echo '    </tbody>' . "\n";
            echo '    </table>' . "\n";
        }
?>
    <table id="serverstatusqueriesdetails<?php echo $current_table; ?>" class="data">
    <col class="namecol" />
    <col class="valuecol" span="3" />
    <thead>
        <tr><th colspan="2"><?php echo $strQueryType; ?></th>
            <th>&oslash; <?php echo $strPerHour; ?></th>
            <th>%</th>
        </tr>
    </thead>
    <tbody>
<?php
    } else {
        $odd_row = !$odd_row;
    }
    $countRows++;

// For the percentage column, use Questions - Connections, because
// the number of connections is not an item of the Query types
// but is included in Questions. Then the total of the percentages is 100.
    $name = str_replace( 'Com_', '', $name );
    $name = str_replace( '_', ' ', $name );
?>
        <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>">
            <th class="name"><?php echo htmlspecialchars( $name ); ?></th>
            <td class="value"><?php echo PMA_formatNumber( $value, 3, 0 ); ?></td>
            <td class="value"><?php echo
                PMA_formatNumber( $value * $hour_factor, 3, 2 ); ?></td>
            <td class="value"><?php echo
                number_format( $value * $perc_factor, 2,
                    $GLOBALS['number_decimal_separator'],
                    $GLOBALS['number_thousands_separator'] ); ?>%</td>
        </tr>
<?php
}
?>
    </tbody>
    </table>
</div>

<div id="serverstatussection">
<?php
//Unset used variables
unset(
    $tables, $rows_per_table, $current_table, $countRows, $perc_factor,
    $hour_factor, $sections['com'],
    $server_status['Aborted_clients'], $server_status['Aborted_connects'],
    $server_status['Max_used_connections'], $server_status['Bytes_received'],
    $server_status['Bytes_sent'], $server_status['Connections'],
    $server_status['Questions'], $server_status['Uptime']
);

foreach ( $sections as $section_name => $section ) {
    if ( ! empty( $section['vars'] ) ) {
?>
    <table class="data" id="serverstatussection<?php echo $section_name; ?>">
    <caption class="tblHeaders">
        <a class="top"
           href="<?php echo $PHP_SELF . '?' .
                 PMA_generate_common_url() . '#_top'; ?>"
           name="<?php echo $section_name; ?>"><?php echo $strPos1; ?>
            <?php echo
                ($GLOBALS['cfg']['MainPageIconic']
              ? '<img src="' . $GLOBALS['pmaThemeImage'] .
                's_asc.png" width="11" height="9" align="middle" alt="" />'
              : '' ); ?>
        </a>
<?php
if ( ! empty( $section['title'] ) ) {
    echo $section['title'];
}
?>
    </caption>
    <col class="namecol" />
    <col class="valuecol" />
    <col class="descrcol" />
    <thead>
        <tr>
            <th><?php echo $strVar; ?></th>
            <th><?php echo $strValue; ?></th>
            <th><?php echo $strDescription; ?></th>
        </tr>
    </thead>
<?php
        if ( ! empty( $links[$section_name] ) ) {
?>
    <tfoot>
        <tr class="tblFooters">
            <th colspan="3" class="tblFooters">
<?php
            foreach ( $links[$section_name] as $link_name => $link_url ) {
                echo '<a href="' . $link_url . '">' . $link_name . '</a>' . "\n";
            }
            unset( $link_url, $link_name );
?>
            </th>
        </tr>
    </tfoot>
<?php
        }
?>
    <tbody>
<?php
        $odd_row = false;
        foreach ( $section['vars'] as $name => $value ) {
            $odd_row = !$odd_row;
?>
        <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>">
            <th class="name"><?php echo htmlspecialchars($name); ?></th>
            <td class="value"><?php
            if ( isset( $alerts[$name] ) ) {
                if ( $value > $alerts[$name] ) {
                    echo '<span class="attention">';
                } else {
                    echo '<span class="allfine">';
                }
            }
            if ( '%' === substr( $name, -1, 1 ) ) {
                echo number_format( $value, 2,
                    $GLOBALS['number_decimal_separator'],
                    $GLOBALS['number_thousands_separator'] ) . ' %';
            } elseif ( is_numeric( $value ) && $value == (int) $value ) {
                echo PMA_formatNumber( $value, 3, 0 );
            } elseif ( is_numeric( $value ) ) {
                echo PMA_formatNumber( $value, 3, 2 );
            } else {
                echo htmlspecialchars( $value );
            }
            if ( isset( $alerts[$name] ) ) {
                echo '</span>';
            }
            ?></td>
            <td class="descr">
            <?php
            if ( isset( $GLOBALS['strShowStatus' . $name . 'Descr'] ) ) {
                echo $GLOBALS['strShowStatus' . $name . 'Descr'];
            }

            if ( isset( $links[$name] ) ) {
                foreach ( $links[$name] as $link_name => $link_url ) {
                    echo ' <a href="' . $link_url . '">' . $link_name . '</a>' .
                        "\n";
                }
                unset( $link_url, $link_name );
            }
            ?>
            </td>
        </tr>
<?php
        }
        unset( $name, $value );
?>
    </tbody>
    </table>
<?php
    }
}
unset( $section_name, $section, $sections, $server_status, $odd_row, $alerts );
?>
</div>
</div>
<?php


/**
 * Sends the footer
 */
require_once './libraries/footer.inc.php';
?>