Re: Is it possible to get current status of MAX_QUERIES_PER_HOUR
Posted by: Tore Krudtaa
Date: October 24, 2007 04:51AM

Hi and thanks for reply...

When looking at result from SHOW VARIABLES

then all info I can get, related to query, is this:

ft_query_expansion_limit 20
have_query_cache YES
long_query_time 10

query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 20971520
query_cache_type DEMAND
query_cache_wlock_invalidate OFF
query_prealloc_size 8192

then related to queri
log_queries_not_using_indexes OFF
log_slow_queries OFF

I cannot see that any of the above does give any information about e.g.
current status of MAX_QUERIES_PER_HOUR

Do you have any specific information about which variables are related to these:

MAX_QUERIES_PER_HOUR
MAX_UPDATES_PER_HOUR
MAX_CONNECTIONS_PER_HOUR
MAX_USER_CONNECTIONS

I'm not asking about how to set these limits for a given database, but how to get the current status....
e.g. What has been the peak max_queries_per hour etc... and when did it occur... etc...

Options: ReplyQuote


Subject
Written By
Posted
Re: Is it possible to get current status of MAX_QUERIES_PER_HOUR
October 24, 2007 04:51AM


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.