图 1 书接上回《MySQL InnoDB 架构 Buffer Pool、Change Buffer、自适应哈希索引、Log Buffer》，我们掌握了 InnoDB 引擎的内存架构。 数据最终要持久化到磁盘，其磁盘架构设计融合了复杂的存储结构和精巧的机制，本文将深入剖析其核心模块的设计原理，并通过图片辅助理解。

InnoDB is a powerful open-source storage engine for MySQL that gained much popularity during the recent years. This paper proposes methods for forensic analysis of InnoDB databases by analyzing the ...

Whenever data is being processed, there are many places where parts of the data are temporarily stored; thus forensic analysis can reveal past activities, create a (partial) timeline and recover ...

MySQL InnoDB Java Reader innodb-java-reader is a java implementation to access MySQL InnoDB storage engine file directly. With the library or command-line tool, it provides read-only features like ...

INNODB_LOCKS 和 INNODB_LOCK_WAITS 在MySQL 8.0已被移除，其实就是不鼓励我们用这两个表来获取表信息。 而我们还可以用show engine innodb status获取当前系统各个事务的加锁信息。

在看看innodb_page_size的官方描述： 第一个系统表空间数据文件 (ibdata1)的最小文件大小取决于innodb_page_size值 innodb_page_size只能在初始化MySQL实例之前配置，不能在之后修改。 如果没有指定值，则使用默认页面大小初始化实例。 MySQL 5.7增加了对32KB和64KB页面大小的支持。

The MySQL InnoDB vs. MyISAM database debate depends primarily on the data. While MySQL chose InnoDB as its underlying database engine since version 5.5, there are times when MyISAM makes more sense.