# Server Monitoring & Logs - [Overview of MariaDB Logs](https://mariadb.com/docs/server/server-management/server-monitoring-logs/overview-of-mariadb-logs.md): 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. - [Securing MariaDB Logs](https://mariadb.com/docs/server/server-management/server-monitoring-logs/securing-mariadb-logs.md): 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. - [Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log.md): 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. - [Overview of the Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/overview-of-the-binary-log.md): Introduction to the purpose and structure of the binary log, explaining how it records data changes (DML) and structure changes (DDL) for replication and recovery. - [Activating the Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/activating-the-binary-log.md): Instructions for enabling the binary log using the --log-bin option and configuring the log file basename and index file. - [Binary Log Formats](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/binary-log-formats.md): Detailed comparison of the three binary logging formats: Statement-based (SBR), Row-based (RBR), and Mixed, including their pros, cons, and configuration via binlog\_format. - [Using and Maintaining the Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/using-and-maintaining-the-binary-log.md): Complete binary log maintenance: PURGE BINARY LOGS/RESET MASTER, expire\_logs\_days & binlog\_expire\_logs\_seconds, FLUSH BINARY LOGS, and SHOW SLAVE STATUS. - [Row Binlog Events](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/row-binlog-events.md) - [InnoDB-Based Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/innodb-based-binary-log.md): MariaDB 12.3 introduces a new binary log implementation that stores binlog events directly into InnoDB-managed tablespaces instead of separate flat files on disk. - [Compressing Events to Reduce Size of the Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/compressing-events-to-reduce-size-of-the-binary-log.md): Guide to using the \`log\_bin\_compress\` system variable to compress binary log events, reducing storage usage and network bandwidth during replication. - [Flashback](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/flashback.md): Explains how to use the Flashback feature (via \`mysqlbinlog --flashback\`) to rollback transactions by reversing the binary log events, useful for recovering from accidental data modifications. - [Group Commit for the Binary Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/group-commit-for-the-binary-log.md): Describes the group commit optimization, which improves performance by committing multiple transactions to the binary log in a single disk I/O operation. - [Relay Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/relay-log.md): Overview of the relay log, a set of log files created by a replica server to store events received from the primary's binary log before executing them. - [Selectively Skipping Replication of Binlog Events](https://mariadb.com/docs/server/server-management/server-monitoring-logs/binary-log/selectively-skipping-replication-of-binlog-events.md): Learn techniques to bypass specific replication events. This guide explains how to ignore individual transactions or errors to restore replication flow after a stoppage. - [Error Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/error-log.md): Complete Error Log guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples and best. - [General Query Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/general-query-log.md): Complete General Query Log guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples. - [MyISAM Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/myisam-log.md): Explains the MyISAM log (\`myisam.log\`), a specialized log for recording changes to MyISAM tables for debugging purposes, enabled via the \`--log-isam\` option. - [Rotating Logs on Unix and Linux](https://mariadb.com/docs/server/server-management/server-monitoring-logs/rotating-logs-on-unix-and-linux.md): 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. - [Slow Query Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log.md): Utilize the slow query log in MariaDB Server. This section helps you identify and optimize inefficient queries, improving overall database performance and responsiveness. - [Slow Query Log Overview](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log/slow-query-log-overview.md): Complete Slow Query Log Overview guide for MariaDB. Complete reference documentation for implementation, configuration, and usage for production use. - [EXPLAIN in the Slow Query Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log/explain-in-the-slow-query-log.md): Describes how to configure MariaDB to automatically write the \`EXPLAIN\` plan for slow queries to the log using the \`log\_slow\_verbosity\` system variable. - [log\_slow\_always\_query\_time System Variable](https://mariadb.com/docs/server/server-management/server-monitoring-logs/slow-query-log/log_slow_always_query_time-system-variable.md): Documentation for the \`log\_slow\_always\_query\_time\` variable, which forces queries executed by a specific function or user to be logged regardless of their execution time. - [SQL Error Log Plugin](https://mariadb.com/docs/server/server-management/server-monitoring-logs/sql-error-log-plugin.md): 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. - [Transaction Coordinator Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log.md): Explains the Transaction Coordinator Log (tc.log), used to maintain consistency in distributed transactions (XA) across multiple storage engines or servers. - [Transaction Coordinator Log Overview](https://mariadb.com/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log/transaction-coordinator-log-overview.md): Explains the purpose of the Transaction Coordinator (TC) log (\`tc.log\`), which maintains consistency for XA transactions that affect multiple storage engines, and how to configure it. - [Heuristic Recovery with the Transaction Coordinator Log](https://mariadb.com/docs/server/server-management/server-monitoring-logs/transaction-coordinator-log/heuristic-recovery-with-the-transaction-coordinator-log.md): Describes the process of heuristic recovery using the TC log to resolve "in-doubt" transactions that may occur after a server crash during a 2-phase commit. - [Writing Logs Into Tables](https://mariadb.com/docs/server/server-management/server-monitoring-logs/writing-logs-into-tables.md): 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. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/server-management/server-monitoring-logs.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.