Re: How to get MySQL concurrent query nos.
Posted by:
Rick James
Date: September 05, 2010 11:49AM
SHOW GLOBAL STATUS LIKE 'Threads_running'; -- the number of threads actually doing something, as opposed to "Sleep" (SHOW PROCESSLIST). This number will always be at least 1, because you are running the SHOW.
SHOW VARIABLES LIKE 'max%connections'; -- show the overall max and the limit per user.
SHOW GLOBAL STATUS LIKE 'Max_used_connections'; -- shows the 'highwater' value for how many users were connected (but not necessarily non-Sleep).
If Max_used_connections gets close to max_connections, recommend you tune max_connections and/or wait_timeout. Better yet, get the users to disconnect when they are finished.
"concurrent" is a vague term; what are you really looking for?
Subject
Written By
Posted
Re: How to get MySQL concurrent query nos.
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.