Date: Mon, 29 Nov 2004 14:03:32 +0100
To: [EMAIL PROTECTED]
From: Philippe de Rochambeau [EMAIL PROTECTED]
Subject: Number of connections to a database
Message-Id: [EMAIL PROTECTED]
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at a given time, using SQL or a scripting language such
as php, perl, etc. ?
Many thanks.
Philippe
Perhaps this will help.
mysql SHOW STATUS LIKE 'threads_connected';
+---+---+
| Variable_name | Value |
+---+---+
| Threads_connected | 5 |
+---+---+
1 row in set (0.00 sec)
mysql SHOW STATUS LIKE '%connect%';
+--+---+
| Variable_name| Value |
+--+---+
| Aborted_connects | 2 |
| Connections | 74|
| Max_used_connections | 27|
| Threads_connected| 5 |
+--+---+
4 rows in set (0.00 sec)
Connections: Total number of connections made since the MySQL server was
last restarted.
Max_used_conections: Maximum number of simultaneous connections since
the MySQL server was last restarted.
Threads_connected: Current number of connections.
--
Jon Stephens, Technical Writer
MySQL AB www.mysql.com
Office: +61 (7) 3388 2228
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
