mysql_list_processes(3) [php man page]

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)

MYSQL_STAT(3)								 1							     MYSQL_STAT(3)

mysql_stat - Get current system status

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_stat(3)

		     o PDO::getAttribute

       string mysql_stat ([resource  $link_identifier = NULL])

DESCRIPTION

       mysql_stat(3) returns the current server status.

	      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.

	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.

       Example #1

	      mysql_stat(3) 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

	      Alternative mysql_stat(3) 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'] . "
";
	      }
	      ?>

	      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/

       mysql_get_server_info(3), mysql_list_processes(3).

PHP Documentation Group 													     MYSQL_STAT(3)