Display number of Client connected to Database in MySQL

Question

hi sir I want to count the number of systems connected to the server in mysqli want only clients connected to the server for particular database belongs to root userHow to get it

dharmendr · Accepted Answer

Hi PSowmiyaRefer below linkshttpswwwcommandlinefucomcommandsview9938displaythenumberofconnectionstoamysqldatabasehttpsdbastackexchangecomquestions115309viewactivemysqlconnectionsperuser

PSowmiya · Answer

thank you sirIn second link following query solves my problemSELECT IFNULLusr39All Users39 userIFNULLhst39All Hosts39 host  COUNT1 Connections FROM  SELECT user usrLEFThostLOCATE3939host  1 hst FROM informationschemaprocesslist WHERE user39root39  A GROUP BY usrhst WITH ROLLUP

Display number of Client connected to Database in MySQL

Company

Explore

Follow us

Contact Us