commandlinefu.com is the place to record those command-line gems that you return to again and again.
You can sign-in using OpenID credentials, or register a traditional username and password.
Subscribe to the feed for:
Count the number of active connections to a MySQL database.
The MySQL command "show processlist" gives a list of all the active clients.
However, by using the processlist table, in the information_schema database, we can sort and count the results within MySQL.
There are 9 alternatives - vote for the best!
This command will help you to find how many number of connection are made to given mysql and what are the different hosts connected to it with number of connection they are making.
If you can do better, submit your command here.
You must be signed in to comment.