Difference between revisions of "Talk:MariaDB/MySQL"
Jump to navigation
Jump to search
(Created page with "My tweaks 20191029 pi2 key_buffer_size from 16 to 8 MiB as there are hardly any myIsam tables") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
20191029 pi2 key_buffer_size from 16 to 8 MiB as there are hardly any myIsam tables | 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% | ||
Latest revision as of 00:07, 30 November 2019
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%