Mysql 5.7 MyISAM

  • key_buffer_size

the size of the index buffers held in memory, which affects the speed of index reads

recommend: 25% or more of the available server memory

A good way to determine whether to adjust the value is to compare the key_read_requests value, which is the total value of requests to read an index, and the key_reads values, the total number of requests that had to be read from disk.

Related