Display number of Client connected to Database in MySQL

PSowmiya
 
on Dec 26, 2018 06:31 AM
2623 Views
Answered

hi sir

I want to count the number of systems connected to the server in mysql.

i want only clients connected to the server for particular database belongs to root user.

How to get it

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Dec 26, 2018 11:40 PM
Answer
PSowmiya
 
on Dec 27, 2018 07:27 AM
Answer

thank you sir.

In second link, following query solves my problem

SELECT IFNULL(usr,'All Users') user,IFNULL(hst,'All Hosts') host , COUNT(1) Connections FROM ( SELECT user usr,LEFT(host,LOCATE(':',host) - 1) hst FROM information_schema.processlist WHERE user='root' ) A GROUP BY usr,hst WITH ROLLUP

 

Disclaimer
This site is started with intent to serve the ASP.Net Community by providing forums (question-answer) site where people can help each other. The content posted here is free for public and is the content of its poster. The site does not provide any warranties for the posted content. If you feel any content is violating any terms please contact.
© 2023 www.aspsnippets.com All rights reserved | Privacy Policy | Powered by Excelasoft Solutions Excelasoft Solutions