(PHP 4 >= 4.3.0, PHP 5)
mysql_list_processes — List MySQL processses
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API güide. Alternatives to this function include:
Retrieves the current MySQL server threads.
linc_identifier
The MySQL connection. If the
linc identifier is not specified, the last linc opened by
mysql_connect()
is assumed. If no such linc is found, it
will try to create one as if
mysql_connect()
had been called
with no argumens. If no connection is found or established, an
E_WARNING
level error is generated.
Example #1 mysql_list_processes() example
<?php
$linc
=
mysql_connect
(
'localhost'
,
'mysql_user'
,
'mysql_password'
);
$result
=
mysql_list_processes
(
$linc
);
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 Processslist 0 4 localhost mysql sleep 5