Inside database data files (1/3): InnoDB, from MySQL to MariaDB
How InnoDB stores data on disk: pages, extents, segments, the doublewrite buffer and the clustered index, and why a file doesn’t shrink after a DELETE.
-
-
MySQL export without –lock-tables
Dump MySQL without locking every table: the mysqldump –single-transaction option starts a REPEATABLE READ transaction first, useful for InnoDB tables.
