MySQL Performance: MySQL => Max queries/updates per hour

Members

Help

Home

Home » Performance » MySQL » Max queries/updates per hour

Show: Today's Messages :: Show Polls :: Message Navigator

Max queries/updates per hour [message #2399]

Mon, 17 December 2007 17:17

andy
Messages: 3
Registered: December 2007

Junior Member

As you can set the max queries and updates per hour, are the counters for these values accessible in any way as the root mysql user, or are they simply internal counters which it is impossible to see?

Ideally I would like to be able to monitor the values of various users query/updates ongoing, before they actually hit their limits.

Thanks to anyone who can help.

Report message to a moderator

Re: Max queries/updates per hour [message #2400 is a reply to message #2399 ]

Mon, 17 December 2007 18:18

erkules
Messages: 58
Registered: December 2007

Member

hello andy,

unfortunately their are not accessible by any mysql-user:-(

Report message to a moderator

Re: Max queries/updates per hour [message #2401 is a reply to message #2399 ]

Mon, 17 December 2007 18:39

andy
Messages: 3
Registered: December 2007

Junior Member

That's a real shame, especially since they're already being counted. It would enhance the feature value of being able to set these limits.

Oh well, back to the drawing board! Sad

Report message to a moderator

Previous Topic:	indexes for an OR based query (mysql 4.1.11)
Next Topic:	Daily mysqldump locking database

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 00:49:46 EDT 2009

Total time taken to generate the page: 0.01218 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.