|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
30/03/2006, 03h46
|
#1 |
Messages: n/a
Hébergeur: |
Is it possible to get the number of connections to a particular database?
Is it possible to determine number of connections to a particular
database in MySQL? If yes..can anyone show me the way to do it in DML or normal query form? ? Thanks for replying and ing out!!! |
|
|
30/03/2006, 04h58
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Is it possible to get the number of connections to a particulardatabase?
sooseong.ng@gmail.com wrote:
> Is it possible to determine number of connections to a particular > database in MySQL? If yes..can anyone show me the way to do it in DML > or normal query form? > ? Thanks for replying and ing out!!! You can get this information with the "SHOW PROCESSLIST" statement. Or at the command-line with "mysqladmin processlist". There doesn't seem to be any syntax for limiting the output to a specific database, but one of the columns returned is the database name, so you can do some filtering yourself (e.g. with grep). See http://dev.mysql.com/doc/refman/5.0/...ocesslist.html Regards, Bill K. |
|
|
|
| Outils de la discussion | |
|
|
