The logging_query plugin logs queries to a CSV file.
To load this plugin, start drizzled with:
--plugin-add=logging_query
Loading the plugin may not enable or configure it. See the plugin’s Configuration and Variables.
See also
Plugin Options for more information about adding and removing plugins.
These command line options configure the plugin when drizzled is started. See Command Line Options for more information about specifying command line options.
Default : | false |
---|---|
Variable : | logging_query_enable |
Enable logging to CSV file.
Default : | |
---|---|
Variable : | logging_query_filename |
File to log to.
Default : | |
---|---|
Variable : | logging_query_pcre |
PCRE to match the query against.
Default : | 0 |
---|---|
Variable : | logging_query_threshold_big_examined |
Threshold for logging big queries by rows examined.
Default : | 0 |
---|---|
Variable : | logging_query_threshold_big_resultset |
Threshold for logging big queries by result set size.
Default : | 0 |
---|---|
Variable : | logging_query_threshold_slow |
Threshold for logging slow queries by execution time.
These variables show the running configuration of the plugin. See variables for more information about querying and setting variables.
logging_query_enable
Scope: Global Dynamic: No Option: --logging-query.enable Enable logging to CSV file.
logging_query_filename
Scope: Global Dynamic: No Option: --logging-query.filename File to log to.
logging_query_pcre
Scope: Global Dynamic: No Option: --logging-query.pcre PCRE to match the query against.
logging_query_threshold_big_examined
Scope: Global Dynamic: No Option: --logging-query.threshold-big-examined Threshold for logging big queries by rows examined.
logging_query_threshold_big_resultset
Scope: Global Dynamic: No Option: --logging-query.threshold-big-resultset Threshold for logging big queries by result set size.
logging_query_threshold_slow
Scope: Global Dynamic: No Option: --logging-query.threshold-slow Threshold for logging slow queries by execution time.
Sorry, there are no examples for this plugin.
Mark Atwood
This documentation applies to logging_query 0.2.
To see which version of the plugin a Drizzle server is running, execute:
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='logging_query'