From wiki
Jump to navigation Jump to search

My tweaks

20191029 pi2 key_buffer_size from 16 to 8 MiB as there are hardly any myIsam tables

20191129 pi2 is down 20191129 on hpbox tmp_table_size and max_heap_table_size set from 16 to 32 MiB

Rate of temporary tables being written to disk: 13.72 per hour, this value should be less than 1 per hour

20191129 on hpbox key_buffer_size set from 16 to 8 MiB

max % MyISAM key buffer ever used: 1%, this value should be above 95%