Page 1 of 1

How to find number of concurrent/active users in my system

Posted: Tue Dec 10, 2013 6:04 am
by ursitesion
I have a Joomla 1.5.10 based Intranet system. Sometimes we see that number of DB threads are too high and performance become down. When I checked through Administrator section, I can see the number of logged-in users only. These number is between 1000-5000 only. is it correct to execute below query to find the concurrent active users:

Code: Select all

select count(*) from jos_session;
For example, If I execute above query and check the logged-in user through administrator, below is the data:

Code: Select all

select count(*) from jos_session; = 2628
logged-in users visible from admin section = 1545
Both results are not matching each other. Also, what is the best way to find the concurrent / active users in my system at a time?
Many thanks...