MYSQL_LIST_PROCESSES(3) 1 MYSQL_LIST_PROCESSES(3)mysql_list_processes - List MySQL processesSYNOPSIS
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)
Check Out this Related Man Page
MYSQL_GET_SERVER_INFO(3) 1 MYSQL_GET_SERVER_INFO(3)mysql_get_server_info - Get MySQL server infoSYNOPSIS
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_get_server_info(3)
o PDO::getAttribute
string mysql_get_server_info ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the MySQL server version.
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 the MySQL server version on success or FALSE on failure.
Example #1
mysql_get_server_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL server version: %s
", mysql_get_server_info());
?>
The above example will output something similar to:
MySQL server version: 4.0.1-alpha
mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_proto_info(3), phpversion(3).
PHP Documentation Group MYSQL_GET_SERVER_INFO(3)
I have a lot of files getting this on a new install of phpmysql 4.3.4
any ideas what would be causing this...
Fatal error: Call to undefined function: mysql_connect() in /home/httpd/vhosts/ucandevelopments.com/httpdocs/includes/functions/database.php on line 19 (4 Replies)
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Hi,
I have data in the following format:
data1
data2 data3 data4
data5 data6
data7 data8 data9
data10
I require the final output to be:
data1
data1
data1
data1
i only require the 1st line but I need to replicate it in n rows where n is the number of rows where data... (4 Replies)
I am trying to learn how to install HORDE for work and I found this link:
Installing Horde on Centos 5.x - William Lindley - wlindley.com
I am at this step now:
You'll need to use the MySQL root password. Then, in your database administration screen for MySQL, set the password for the new... (2 Replies)
Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So... (12 Replies)
Hi,
I have a system under test, and I use a script that does a ps.
The output, is in the following format, it's basically the timestamp, followed by the rss and vsize.
09:03:57 68404 183656 68312 181944 69860 217360 67536 182564 69072 183172 69032 199276
09:04:27 68752 183292 70000 189020... (5 Replies)
Hi,
I want to test a var, $inputPin to see if is 3 digits in a row or not in a Bash script.
I am getting stuck on the regex to do this.
And the equality test if it is in an if statement as below?
-ne is for comparing numbers
But I guess it would be != in this case
if \{3,3\]}]
... (6 Replies)
Anyone have a clue about this?
I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level.
Does anyone know a work... (5 Replies)
Hi guys.
We can can connect to mysql server from command line with some user. but when using mysql_connect() it says:
access is denied for user 'someuser'@'localhost' (using password: YES)
what should i do? (6 Replies)
Hi, I want to move a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
I already use this script but doesn't work as I expected.
CHECK_KEYWORD="$( mysql -uroot -p123456 smsd -N... (7 Replies)
Hi,
I'm on a Raspberry Pi with Raspbian Wheezy.
I urgently need to get MySQL running with PHP, but I get an error.
For example:
$con=mysql_connect("127.0.0.1","root","******","ids");
gives
PHP Fatal error: Call to undefined function mysql_connect()
So, I found I needed to install some... (2 Replies)
I get a "not found" error from this
localhost/choice.php
ethan@meow:~$ ping 127.0.0.1
PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.025 ms
64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.036 m
and this
ethan@meow:~$ mysql -u... (4 Replies)