# Server Monitoring & Logs

- [Overview of MariaDB Logs](/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](/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](/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](/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](/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](/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](/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](/docs/server/server-management/server-monitoring-logs/binary-log/row-binlog-events.md)
- [InnoDB-Based Binary Log](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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.