InnoDB
Discover InnoDB, the default storage engine for MariaDB Server. Learn about its transaction-safe capabilities, foreign key support, and high performance for demanding workloads.
Last updated
Was this helpful?
Discover InnoDB, the default storage engine for MariaDB Server. Learn about its transaction-safe capabilities, foreign key support, and high performance for demanding workloads.
An overview of the InnoDB storage engine, detailing its support for ACID transactions, row-level locking, and crash recovery.
Learn about the different file formats supported by InnoDB, such as Antelope and Barracuda, and how they impact table features and storage.
A list of constraints and limits within the InnoDB engine, including maximum table size, column counts, and index key lengths.
This page explains how InnoDB manages AUTO_INCREMENT columns, including initialization behavior, gap handling, and potential restart effects.
Understand how group commit works with InnoDB to improve performance by reducing the number of disk syncs required during transaction commits.
Explore how InnoDB uses asynchronous I/O on various operating systems to handle multiple read and write requests concurrently without blocking.
Complete InnoDB Buffer Pool guide for MariaDB. Complete reference documentation for implementation, configuration, and usage with comprehensive examples and.
Learn about the change buffer, an optimization that delays secondary index writes to reduce I/O overhead for non-unique index modifications.
This feature allows for the secure deletion of data by overwriting deleted records in tablespaces and logs to prevent data recovery.
The doublewrite buffer is a storage area where InnoDB writes pages before writing them to the data file, preventing data corruption from partial page writes.
Detailed description of the innodb_flush_method variable, its various settings, and effects.
InnoDB employs Row-Level Locking with Shared (S) and Exclusive (X) locks, along with Intention locks, to manage concurrent transaction access.
Retain the full InnoDB write-ahead log history (from MariaDB 13.0) by archiving log files, enabling point-in-time recovery and incremental backups.
InnoDB Monitors, such as the Standard, Lock, and Tablespace monitors, provide detailed internal state information to the error log for diagnostics.
This feature enables transparent page-level compression for tables using algorithms like LZ4 or Zlib, reducing storage requirements.
Learn about the background processes that flush dirty pages from the buffer pool to disk, including adaptive flushing algorithms to optimize I/O.
The purge process is a garbage collection mechanism that removes old row versions from the undo log that are no longer required for MVCC.
The undo log stores the "before" image of data modified by active transactions, supporting rollbacks and consistent read views.
The redo log is a disk-based transaction log used during crash recovery to replay incomplete transactions and ensure data durability.
InnoDB Strict Mode enforces stricter SQL compliance, returning errors instead of warnings for invalid CREATE TABLE options or potential data loss.
Complete guide to InnoDB system variables for MariaDB. Complete reference for buffer pool, I/O tuning, transaction settings, and optimization for production use.
This page is outdated. It's left in place because release notes for old MariaDB versions refer to it (MariaDB < 10.3).
Understand InnoDB's architecture for MariaDB Enterprise Server. This section details its components and their interactions, focusing on performance, scalability, and reliability for enterprise workloa
Perform online DDL operations with InnoDB in MariaDB Server. Learn how to alter tables without blocking read/write access, ensuring high availability for your applications.
Explore InnoDB row formats in MariaDB Server. Understand different formats like Compact, Dynamic, and Compressed, and how they impact storage efficiency and performance for your data.
Manage InnoDB tablespaces in MariaDB Server. Understand their role in data organization, performance, and recovery, including file-per-table and shared tablespaces.
Troubleshoot InnoDB issues in MariaDB Server. Find solutions and best practices for common problems, ensuring your InnoDB-based applications run smoothly and efficiently.
Learn about InnoDB operations in MariaDB Enterprise Server. This section covers critical management tasks, including configuration, performance tuning, and troubleshooting for enterprise-grade deploym
Last updated
Was this helpful?
Was this helpful?