Patch: control_global_slow

This patch similar to use_global_long_query_time. As it, patch allow choose variable scope for variables of slow_extended (settings slow query log).

This patch is included as part of slow_extended.

Version-Specific Information

Percona-Server Version Comments
5.1.47-11.0 Full functionality, except “all” option and link between user_global_long_query_time and use_global_log_slow_control=long_query_time available.
5.1.47-12.0 Full functionality available.

Variables Provided

use_global_log_slow_control

TypeSystem and command-line variable
ScopeGlobal
DynamicYes
Defaultnone

Specifies which variable is the global scope instead of local. Value is a “flag” variable - you can specify multiple values separated by commas

Value Explanation
none All variables use local scope
log_slow_filter Global variable log_slow_filter has effect (instead of local)
log_slow_rate_limit Global variable log_slow_rate_limit has effect (instead of local)
log_slow_verbosity Global variable log_slow_verbosity has effect (instead of local)
long_query_time Global variable long_query_time has effect (instead of local)
min_examined_row_limit Global variable min_examined_row_limit has effect (instead of local)
all Global variables has effect (instead of loval)

Related Reading

Please note that this is NOT a place to ask questions or report bugs. This comment system is only intended for users to share tips and documentation additions concerning particular document.
Please report bugs to https://bugs.launchpad.net/percona-project/+filebug and ask general questions in maillist Percona-discussions

Discussion

Enter your comment (wiki syntax is allowed):
TAQIB
 
patches/control_global_slow.txt · Last modified: 2010/07/07 13:40 by oleg.tsarev
 
Except where otherwise noted, content on this wiki is licensed under the following license:GNU Free Documentation License 1.2
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki