> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-management/server-monitoring-logs.md).

# Server Monitoring & Logs

{% columns %}
{% column %}
{% content-ref url="/pages/lXh3qHmSssQJWIw1djbj" %}
[Overview of MariaDB Logs](/docs/server/server-management/server-monitoring-logs/overview-of-mariadb-logs.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An introductory guide to the various logs available in MariaDB, including the Error Log, General Query Log, Slow Query Log, and Binary Log, and how to enable or disable them.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/hbR7otsggvZk4rYq0Mnv" %}
[Securing MariaDB Logs](/docs/server/server-management/server-monitoring-logs/securing-mariadb-logs.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to harden MariaDB log files by implementing at-rest encryption, TLS for transit, strict OS permissions, and automated rotation to ensure data integrity and regulatory compliance.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/RzHhMQASSXz2OivfCOwY" %}
[Binary Log](/docs/server/server-management/server-monitoring-logs/binary-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand the binary log in MariaDB Server. This section explains its role in replication and point-in-time recovery, detailing its format, management, and use for data integrity.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/uxxahOfFbWRCZYKVIeXg" %}
[Error Log](/docs/server/server-management/server-monitoring-logs/error-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete Error Log guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples and best.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/jP5FCgRJVla5ZuxCDYoW" %}
[General Query Log](/docs/server/server-management/server-monitoring-logs/general-query-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete General Query Log guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TKtVZrTpYJkHDdv8x4ir" %}
[MyISAM Log](/docs/server/server-management/server-monitoring-logs/myisam-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains the MyISAM log (`myisam.log`), a specialized log for recording changes to MyISAM tables for debugging purposes, enabled via the `--log-isam` option.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/cyYKVCJGeHR3TMtKdX5N" %}
[Rotating Logs on Unix and Linux](/docs/server/server-management/server-monitoring-logs/rotating-logs-on-unix-and-linux.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A guide to using the `logrotate` utility on Linux to manage MariaDB log files, ensuring they don't consume excessive disk space by rotating, compressing, and archiving them.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/isP2mlWLO2stYTNlkywp" %}
[Slow Query Log](/docs/server/server-management/server-monitoring-logs/slow-query-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Utilize the slow query log in MariaDB Server. This section helps you identify and optimize inefficient queries, improving overall database performance and responsiveness.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/pU9w1TSlV70wonej1M95" %}
[SQL Error Log Plugin](/docs/server/server-management/server-monitoring-logs/sql-error-log-plugin.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Documentation for the SQL Error Log Plugin, which allows logging of errors sent to clients to a file, enabling analysis of application-side errors that might otherwise be missed.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QJkwTeXA4cLJU9PEtvmD" %}
[Transaction Coordinator Log](/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains the Transaction Coordinator Log (tc.log), used to maintain consistency in distributed transactions (XA) across multiple storage engines or servers.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zngfqd2yEp1jTfaW1l6h" %}
[Writing Logs Into Tables](/docs/server/server-management/server-monitoring-logs/writing-logs-into-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Instructions on directing the General Query Log and Slow Query Log to tables (`mysql.general_log`, `mysql.slow_log`) instead of files using the `log_output=TABLE` system variable.
{% endcolumn %}
{% endcolumns %}