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 roo

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