Find logged in users mysql

SELECT SUBSTRING_INDEX(host, ':', 1) AS host_short,
       GROUP_CONCAT(DISTINCT user) AS users,
       COUNT(*) AS threads
FROM information_schema.processlist
GROUP BY host_short
ORDER BY COUNT(*), host_short;

Source: techonthenet.com

Similar codes

0 vote248 views1 answer
How to export table data from mysql table in sql format
SQL
3 votes272 views1 answer
Where id is in list sql
SQL
2 votes273 views1 answer
Db.relationship sqlalchemy flask
SQL
3 votes251 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
25 votes262 views5 answers
Uninstall mysql ubuntu
SQL
0 vote267 views1 answer
Connecting to my cloud sql server with c#
SQL
4 votes323 views1 answer
Oracle table statistics
SQL
0 vote259 views1 answer
Check for directory in bash
SQL
0 vote270 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote263 views1 answer
Connect to nginx server mysql remotly
SQL