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
Since :program:`syslog` is the standard UNIX logging facility,
16
the :ref:`syslog_plugin` plugin is also loaded by default which will log error
17
messages to the system log (:file:`/var/log/syslog` on Ubuntu for example).
18
However, you must start :program:`drizzled` with
19
:option:`--syslog.errmsg-enable` to enable this feature.
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.