Tag: InnoDB
4 articles
MySQL InnoDB Storage Structure: Tablespace, Segment, Exte...
InnoDB storage structure: Tablespace, Segment, Extent, Page, Row. Row formats: REDUNDANT, COMPACT, DYNAMIC, COMPRESSED
MySQL InnoDB Disk Structure: Tablespace, Log System, Data...
InnoDB disk structure: system tablespace, file-per-table tablespace, general tablespace, temporary tablespace, Doublewrite Buffer, Redo Log, Undo Log - complete storage architecture guide.
MySQL InnoDB Storage Structure: Buffer Pool and Log Mecha...
InnoDB memory structure: Buffer Pool, Change Buffer, Adaptive Hash Index, Log Buffer - this article provides an in-depth analysis of principles and practical applications.
MySQL Storage Engines: InnoDB vs MyISAM Deep Comparison
MySQL storage engine comparison: InnoDB, MyISAM, Memory, Archive - transactions, locking mechanisms, index structures. This article provides in-depth analysis of principles and practical applications.