Query Logging

The logging_query plugin logs queries to a CSV file.

Loading

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.

Configuration

These command line options configure the plugin when drizzled is started. See Command Line Options for more information about specifying command line options.

--logging-query.enable
Default:false
Variable:logging_query_enable

Enable logging to CSV file.

--logging-query.filename
Default:
Variable:logging_query_filename

File to log to.

--logging-query.pcre ARG
Default:
Variable:logging_query_pcre

PCRE to match the query against.

--logging-query.threshold-big-examined
Default:0
Variable:logging_query_threshold_big_examined

Threshold for logging big queries by rows examined.

--logging-query.threshold-big-resultset
Default:0
Variable:logging_query_threshold_big_resultset

Threshold for logging big queries by result set size.

--logging-query.threshold-slow
Default:0
Variable:logging_query_threshold_slow

Threshold for logging slow queries by execution time.

Variables

These variables show the running configuration of the plugin. See variables for more information about querying and setting variables.

  • logging_query_pcre

    Scope:Global
    Dynamic:No
    Option:--logging-query.pcre

    PCRE to match the query against.

Examples

Sorry, there are no examples for this plugin.

Authors

Mark Atwood

Version

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'

Changelog

v0.2

  • First release.

Table Of Contents

Previous topic

Gearman Logging

Next topic

User Statistics

This Page