FRM-less, transactional data dictionary is arguably the most
significant feature change announced MySQL 8.0 development
release. The server still has two separate dictionaries (MySQL,
InnoDB) but the infamous FRM files are finally being replaced
with transactional, InnoDB-based storage.
While this is interesting for various reasons, this particular
post will focus on the impact this change has on data dictionary
performance.
Test configuration Server configuration:
- Hardware: Amazon EC2 m4.4xlarge, 500GB, 15K IOPS
- OS: Debian Jessie
- MySQL versions tested: 5.7.15, 8.0.0-dmr
- Notable customer MySQL configuration values:
- innodb_buffer_pool_size = 4GB
- innodb_log_file_size = 256MB
- innodb_buffer_pool_dump_at_shutdown = 0
- innodb_buffer_pool_load_at_startup = 0
- …