1
.. _logging_query_plugin:
6
The :program:`logging_query` plugin logs queries to a CSV file.
8
.. _logging_query_loading:
13
To load this plugin, start :program:`drizzled` with::
15
--plugin-add=logging_query
17
Loading the plugin may not enable or configure it. See the plugin's
18
:ref:`logging_query_configuration` and :ref:`logging_query_variables`.
20
.. seealso:: :ref:`drizzled_plugin_options` for more information about adding and removing plugins.
22
.. _logging_query_configuration:
27
These command line options configure the plugin when :program:`drizzled`
28
is started. See :ref:`command_line_options` for more information about specifying
33
.. option:: --logging-query.enable
36
:Variable: :ref:`logging_query_enable <logging_query_enable>`
38
Enable logging to CSV file.
40
.. option:: --logging-query.filename
43
:Variable: :ref:`logging_query_filename <logging_query_filename>`
47
.. option:: --logging-query.pcre ARG
50
:Variable: :ref:`logging_query_pcre <logging_query_pcre>`
52
PCRE to match the query against.
54
.. option:: --logging-query.threshold-big-examined
57
:Variable: :ref:`logging_query_threshold_big_examined <logging_query_threshold_big_examined>`
59
Threshold for logging big queries by rows examined.
61
.. option:: --logging-query.threshold-big-resultset
64
:Variable: :ref:`logging_query_threshold_big_resultset <logging_query_threshold_big_resultset>`
66
Threshold for logging big queries by result set size.
68
.. option:: --logging-query.threshold-slow
71
:Variable: :ref:`logging_query_threshold_slow <logging_query_threshold_slow>`
73
Threshold for logging slow queries by execution time.
75
.. _logging_query_variables:
80
These variables show the running configuration of the plugin.
81
See `variables` for more information about querying and setting variables.
83
.. _logging_query_enable:
85
* ``logging_query_enable``
89
:Option: :option:`--logging-query.enable`
91
Enable logging to CSV file.
93
.. _logging_query_filename:
95
* ``logging_query_filename``
99
:Option: :option:`--logging-query.filename`
103
.. _logging_query_pcre:
105
* ``logging_query_pcre``
109
:Option: :option:`--logging-query.pcre`
111
PCRE to match the query against.
113
.. _logging_query_threshold_big_examined:
115
* ``logging_query_threshold_big_examined``
119
:Option: :option:`--logging-query.threshold-big-examined`
121
Threshold for logging big queries by rows examined.
123
.. _logging_query_threshold_big_resultset:
125
* ``logging_query_threshold_big_resultset``
129
:Option: :option:`--logging-query.threshold-big-resultset`
131
Threshold for logging big queries by result set size.
133
.. _logging_query_threshold_slow:
135
* ``logging_query_threshold_slow``
139
:Option: :option:`--logging-query.threshold-slow`
141
Threshold for logging slow queries by execution time.
143
.. _logging_query_examples:
148
Sorry, there are no examples for this plugin.
150
.. _logging_query_authors:
157
.. _logging_query_version:
162
This documentation applies to **logging_query 0.2**.
164
To see which version of the plugin a Drizzle server is running, execute:
166
.. code-block:: mysql
168
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='logging_query'