- 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_list_processesList MySQL processes
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_thread_id
|
Description
resource mysql_list_processes(resource link_identifier= =NULL);Retrieves the current MySQL server threads.
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
A result pointer resource on success or
FALSE
on failure.
Examples
Example 2.41. mysql_list_processes
example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$result = mysql_list_processes($link);
while ($row = mysql_fetch_assoc($result)){
printf("%s %s %s %s %s\n", $row["Id"], $row["Host"], $row["db"],
$row["Command"], $row["Time"]);
}
mysql_free_result($result);
?>
The above example will output something similar to:
1 localhost test Processlist 0 4 localhost mysql sleep 5
See Also
mysql_thread_id
|
mysql_stat
|
User Comments
Add your own comment.