Bug #2328 Better documentation of the max_queries configuration parameter.
Submitted: 8 Jan 2004 16:36 Modified: 26 Jan 2005 17:26
Reporter: Daniel Wright Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version: OS:
Assigned to: Paul DuBois CPU Architecture:Any

[8 Jan 2004 16:36] Daniel Wright 
Description:
Regarding Section 4.4.7 of the mysql manual:

It would be nice to see more information on how the hourly stats are calculated.  Where is this information stored (does it survive a shutdown/startup or are all connections reset to zero when the daemon restarts)?  When is the hour up (does it go by clock hours, hours from the first user connection, hours from when the server was started, etc...)?  Does it actually count connections or is there an averaging formula involved?

Documentation should also explain how to find out the present connection usage for a user.  If I'm going to put a hard limit on my users, they need to be able to find out how close they are to that limit.  The information also has many possible uses for sysadmins as well.

How to repeat:
View here:

  http://www.mysql.com/doc/en/User_resources.html
[26 Jan 2005 17:26] Paul DuBois 
As the manual says, counts are evaluated as "within the last hour."

Counts do not persist across a restart. This has been noted in the
manual now.