maria-discuss team mailing list archive
Mailing list archive
Re: Are some MyISAM settings used for Aria
The article you linked is quite old, so I wanted to check the source code to find if something changed.
I didn't investigate much but I searched in MariaDB's master branch via GitHub. The search strings were 'read_rnd_buffer_size' and 'read-rnd-buffer-size'. I found nothing except for some test files and the variable initialization at server startup.
I repeated the same searches in MySQL master branch, and again, I found only tests and initialization.
Can you explain this? The variable is unused now?
Lun 24/4/17, jocelyn fournier <jocelyn.fournier@xxxxxxxxx> ha scritto:
Oggetto: Re: [Maria-discuss] Are some MyISAM settings used for Aria
A: "Sales" <info@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Data: Lunedì 24 Aprile 2017, 09:16
avr. 2017 3:28 AM, "Sales" <info@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
a écrit :
On Apr 23,
2017, at 4:12 PM, jocelyn fournier <jocelyn.fournier@xxxxxxxxx>
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
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 1M
join_buffer_size are not MyISAM specific settings, did you
try to modify/not modify only those ones ?
Really? So, the doc is
So, are you saying that is mistaken? If so, that would make
At least according to https://www.percona.com/blog/2007/07/24/what-exactly-is-read_rnd_buffer_size/
it's not. BTW it has been updated in the
mysql manual to mention it optimizes mrr for any engine
KB would need an update as well.
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp