"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/administration/logging.rst" (6 May 2012, 1514 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

drizzled

Logging

Error Messages

Error messages are also handled by plugins. Drizzle loads the errmsg_stderr_plugin plugin by default which prints error messages to STDERR. In many cases, this is sufficient if STDERR is redirected to a log file when starting Drizzle <starting_and_stopping_drizzled>.

Note that beginning with the first Drizzle 7.1 Beta 2011.10.28 drizzled will also log messages via syslog and this is in addition to using STDOUT and STDERR. This functionality is provided by the syslog_plugin plugin. (For example on Ubuntu these messages are written to /var/log/syslog).

Queries

The query_log_plugin plugin is the most feature-complete and flexible query logging plugin. It logs queries to a file with a consistent, easy-to-parse format, and all of its options are dynamic, so once the plugin is loaded, logging can be enabled and disabled at runtime.

Drizzle does not load the query_log_plugin plugin by default, so you must load it when starting Drizzle.

The syslog_plugin plugin also provides basic query logging to the system log. Although the plugin is loaded by default, you must enable query logging by specifying --syslog.logging-enable and one of the threshold options, such as --syslog.logging-threshold-slow. The plugin is not dynamic, so once query logging is enabled, you must restart Drizzle to disable or change its settings.