IBD File Documentation

Overview

Feature Value
File Extension .ibd
File Type InnoDB Database Table File
MIME Type application/octet-stream
Developer Oracle Corporation
Used By MySQL
Purpose To store database information for InnoDB tables
Storage Type File-per-table or Shared Tablespaces
Contains Data and Index pages
Compression Supported (Optional)
Encryption Supported (Optional)
File Structure Segmented into pages, typically 16KB size
Foreign Key Support Yes
ACID Compliance Yes
Transactional Support Yes
Row Format Types Redundant, Compact, Dynamic, Compressed
Tablespace Characteristics System, General, File-per-table, Undo, Temporary
Recoverability High - through log files
Space Management Paged
Default Page Size 16KB
Advantages High performance, reliability, full-text indexing, spatial indexes
Limitations File size can grow significantly, recovery can be complex without proper backup