Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how see connected user?
0 views
Skip to first unread message
_mario.lat
Sep 27, 2006, 4:09:14 PM9/27/06
to
Hallo,
Some times my Db crash or say to many connections.
I'd like to see who cause that.
How can I see who is connected to mysql?
Thank you in advance for the time you'll spend for answering me.
Mario.
Some times my Db crash or say to many connections.
I'd like to see who cause that.
How can I see who is connected to mysql?
Thank you in advance for the time you'll spend for answering me.
Mario.
P.S. Any other suggestion is welcame!
Axel Schwenke
Sep 27, 2006, 6:44:53 PM9/27/06
to
"_mario.lat" <_mari...@libero.it> wrote:
> Some times my Db crash or say to many connections.
> I'd like to see who cause that.
> How can I see who is connected to mysql?
As long as MySQL is up and you can log into it [1] you can use the
SHOW [FULL] PROCESSLIST command to see all open connections.
http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
[1] MySQL reserves one connection for the superuser. So make sure
your application connects as non-superuser. Then you can connect
even if the database emits "too many connection" errors.
XL
--
Axel Schwenke, Senior Software Developer, MySQL AB
Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/
0 new messages