> On Apr 23, 2017, at 4:12 PM, jocelyn fournier <jocelyn.fourn...@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_size <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.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp