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

Need help with the Administration of your Joomla! site? Pop your questions in here.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
User avatar
ursitesion
Joomla! Apprentice
Joomla! Apprentice
Posts: 32
Joined: Tue Aug 10, 2010 12:52 pm
Location: Delhi, India
Contact:

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

Post by ursitesion » Tue Dec 10, 2013 6:04 am

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...

Locked

Return to “Administration - 1.0.x”