MySQL Forums
Forum List  »  Newbie

Re: How to get MySQL concurrent query nos.
Posted by: Shawn Taylor
Date: August 24, 2010 02:53PM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: How to get MySQL concurrent query nos.
August 24, 2010 02:53PM


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.