SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:15 AM
| ||||
| ||||
 how see connected user? 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. P.S. Any other suggestion is welcame!      |
|
02-28-2008, 08:15 AM
| ||||
| ||||
| Re: how see connected user? "_mario.lat" <_mario.lat@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/...ocesslist.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/ |
Linear Mode
