Re: How to get MySQL concurrent query nos.
Sorry, I totally misunderstood your question. Having re-read it I am not sure you can actually calculate that definitively.
There are some columns in the mysql.user table to restrict a user if you wish to a max # of questions,updates etc. So you could look at those, but you would most likely run out of system resources long before you got the max users logged in and running.
For your server:
Look at:
SHOW GLOBAL VARIABLES LIKE '%max_conn%'
That gives you the max # of users that can login.
But I really don't know how to calc the # of queries per user??
Shawn
Subject
Written By
Posted
Re: How to get MySQL concurrent query nos.
August 24, 2010 02:53PM
September 05, 2010 11:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.