- 2.5 MySQL Functions
- 2.5.1 mysql_affected_rows
- 2.5.2 mysql_client_encoding
- 2.5.3 mysql_close
- 2.5.4 mysql_connect
- 2.5.5 mysql_create_db
- 2.5.6 mysql_data_seek
- 2.5.7 mysql_db_name
- 2.5.8 mysql_db_query
- 2.5.9 mysql_drop_db
- 2.5.10 mysql_errno
- 2.5.11 mysql_error
- 2.5.12 mysql_escape_string
- 2.5.13 mysql_fetch_array
- 2.5.14 mysql_fetch_assoc
- 2.5.15 mysql_fetch_field
- 2.5.16 mysql_fetch_lengths
- 2.5.17 mysql_fetch_object
- 2.5.18 mysql_fetch_row
- 2.5.19 mysql_field_flags
- 2.5.20 mysql_field_len
- 2.5.21 mysql_field_name
- 2.5.22 mysql_field_seek
- 2.5.23 mysql_field_table
- 2.5.24 mysql_field_type
- 2.5.25 mysql_free_result
- 2.5.26 mysql_get_client_info
- 2.5.27 mysql_get_host_info
- 2.5.28 mysql_get_proto_info
- 2.5.29 mysql_get_server_info
- 2.5.30 mysql_info
- 2.5.31 mysql_insert_id
- 2.5.32 mysql_list_dbs
- 2.5.33 mysql_list_fields
- 2.5.34 mysql_list_processes
- 2.5.35 mysql_list_tables
- 2.5.36 mysql_num_fields
- 2.5.37 mysql_num_rows
- 2.5.38 mysql_pconnect
- 2.5.39 mysql_ping
- 2.5.40 mysql_query
- 2.5.41 mysql_real_escape_string
- 2.5.42 mysql_result
- 2.5.43 mysql_select_db
- 2.5.44 mysql_set_charset
- 2.5.45 mysql_stat
- 2.5.46 mysql_tablename
- 2.5.47 mysql_thread_id
- 2.5.48 mysql_unbuffered_query
Copyright 1997-2012 the PHP Documentation Group.
mysql_statGet current system status
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_connectis assumed. If no such link is found, it will try to create one as ifmysql_connectwas called with no arguments. If no connection is found or established, anE_WARNINGlevel 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 2.52. 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
[6] => Open tables: 17
[7] => Queries per second avg: 245.595
)
Example 2.53. Alternative
mysql_stat
example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$result = mysql_query('SHOW STATUS', $link);
while ($row = mysql_fetch_assoc($result)) {
echo $row['Variable_name'] . ' = ' . $row['Value'] . "\n";
}
?>
The above example will output something similar to:
back_log = 50 basedir = /usr/local/ bdb_cache_size = 8388600 bdb_log_buffer_size = 32768 bdb_home = /var/db/mysql/ bdb_max_lock = 10000 bdb_logdir = bdb_shared_data = OFF bdb_tmpdir = /var/tmp/ ...
See Also
mysql_get_server_info
|
mysql_list_processes
|
User Comments
Add your own comment.