To optimize the key_buffer_size, you need to review the key_read statistics: MariaDB [(none)]> SHOW STATUS LIKE "key%"; +------------------------+---------+ | Variable_name | Value | +------------------------+---------+ | Key_blocks_not_flushed | 0 | |…