9
Error messages are also handled by plugins. Drizzle loads the
10
:ref:`errmsg_stderr_plugin` plugin by default which prints error messages
11
to ``STDERR``. In many cases, this is sufficient if ``STDERR`` is
12
redirected to a log file when
13
:ref:`starting Drizzle <starting_and_stopping_drizzled>`.
15
Note that beginning with the first ``Drizzle 7.1 Beta 2011.10.28`` drizzled
16
will **also** log messages via syslog and this is *in addition* to using
17
``STDOUT`` and ``STDERR``. This functionality is provided by the
18
:ref:`syslog_plugin` plugin. (For example on Ubuntu these messages are written
19
to :file:`/var/log/syslog`).
24
The :ref:`query_log_plugin` plugin is the most feature-complete and flexible
25
query logging plugin. It logs queries to a file with a consistent,
26
easy-to-parse format, and all of its options are dynamic, so once the plugin
27
is loaded, logging can be enabled and disabled at runtime.
29
Drizzle does not load the :ref:`query_log_plugin` plugin by default, so you
30
must load it when starting Drizzle.
32
The :ref:`syslog_plugin` plugin also provides basic query logging to
33
the system log. Although the plugin is loaded by default, you must
34
enable query logging by specifying :option:`--syslog.logging-enable`
35
and one of the threshold options, such as
36
:option:`--syslog.logging-threshold-slow`. The plugin is not dynamic,
37
so once query logging is enabled, you must restart Drizzle to disable
38
or change its settings.