Original MySQL API (
Mysql
)
2302
List of character sets that MySQL supports
20.7.2.5.45.
mysql_stat
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysql_stat
Get current system status
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the
future. Instead, the
MySQLi
or
PDO_MySQL
extension should be used. See
also
MySQL: choosing an API
guide and
related FAQ
for more information.
Alternatives to this function include:
mysqli_stat
PDO::getAttribute(PDO::ATTR_SERVER_INFO)
Description
string mysql_stat(
resource link_identifier
= =NULL);
mysql_stat
returns the current server status.
Parameters
link_identifier
The MySQL connection. If the link identifier is not specified, the
last link opened by
mysql_connect
is assumed. If no such link
is found, it will try to create one as if
mysql_connect
was called
with no arguments. If no connection is found or established, an
E_WARNING
level error is generated.
Return Values
Returns a string with the status for uptime, threads, queries, open tables, flush tables and queries
per second. For a complete list of other status variables, you have to use the
SHOW STATUS
SQL
command. If
link_identifier
is invalid,
NULL
is returned.
Examples
Example 20.73.
mysql_stat
example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$status = explode(' ', mysql_stat($link));
print_r($status);
?>
The above example will output something similar to:
Array
(
[0] => Uptime: 5380
[1] => Threads: 2
[2] => Questions: 1321299
[3] => Slow queries: 0
[4] => Opens: 26
[5] => Flush tables: 1
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...