On Apr 23, 2017, at 4:12 PM, jocelyn fournier <jocelyn.fournier@gmail.com> wrote:
Hi Steve,
Le 23/04/2017 à 19:32, Sales a écrit :
On our system, Mariadb 10.1.22, with aria_used_for_temp_tables = ON, we have a set of MyISAM settings carried over from an earlier setup. Those settings are:
key_buffer_size=256M myisam_sort_buffer_size = 64M join_buffer_size=512K bulk_insert_buffer_size=512M read_rnd_buffer_size = 1M read_rnd_buffer_size and join_buffer_size are not MyISAM specific settings, did you try to modify/not modify only those ones ?
HTH, Jocelyn
Really? So, the doc is wrong? https://mariadb.com/kb/en/mariadb/server-system-variables/#read_rnd_buffer_s... <https://mariadb.com/kb/en/mariadb/server-system-variables/#read_rnd_buffer_size> Says, MyISAM. So, are you saying that is mistaken? If so, that would make sense. True about join_buffer_size, it was mistakingly added within a comment block noting the purpose, when, and MyISAM (false). Good catch. Thanks! That may well be the entire discrepancy.