| Metric | Standard InnoDB | indodb21 | Improvement | | :--- | :--- | :--- | :--- | | Transactions Per Second (TPS) | 2,450 | 3,870 | | | P99 Latency (Read) | 24 ms | 9 ms | -62.5% | | Crash Recovery Time (30GB buffer) | 127 sec | 18 sec | -85.8% | | Replication Lag (Mixed workload) | 4.2 sec | 0.7 sec | -83.3% |
[mysqld] innodb_adaptive_hash_index_parts = 16 innodb_log_write_ahead_size = 8192 innodb_buffer_pool_instances = 8 indodb21_enable_parallel_recovery = ON indodb21_lock_free_trx_sys = ON After restart, check: indodb21
SELECT VERSION(); Download the optimized .cnf file from the official repository (or use the following snippet): | Metric | Standard InnoDB | indodb21 |
You need MySQL 8.0.21 or higher. Run: