mysql_list_processes(3) php man page | unix.com

MYSQL_LIST_PROCESSES(3) 						 1						   MYSQL_LIST_PROCESSES(3)

mysql_list_processes - List MySQL processes

SYNOPSIS
       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:

		     omysqli_thread_id(3)

       resource mysql_list_processes ([resource  $link_identifier = NULL])

DESCRIPTION
	Retrieves the current MySQL server threads.

	      o $
		link_identifier -The MySQL connection. If the link identifier is not specified,  the  last  link  opened  by  mysql_connect(3)	is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	A result pointer resource on success or FALSE on failure.

       Example #1

	      mysql_list_processes(3) 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
", $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

       mysql_thread_id(3), mysql_stat(3).

PHP Documentation Group 												   MYSQL_LIST_PROCESSES(3)