[Maria-developers] read_buffer_size query
Hi I'm working on adding complete descriptions to the knowledgebase for all the server variables right now, and have a query on the read_buffer_size variable. The default in my MariaDB 10.0.1 seems to be 2097152, but it's listed on the MySQL docs with a default of 131072. I can't find a mention in the changelogs of this having changed - can anyone tell me in which version the change in default happened? Also, in the MySQL documentation, this variable is described as applying to MyISAM tables, while in the only short description on the Knowledgebase I can find, at https://kb.askmonty.org/en/mysqld-options-full-list/, it's described more generally, not specifically mentioning MyISAM. Does this variable apply to other storage engines as well now (Aria?), or still only MyISAM? thanks, ian gilfillan
Hi, Ian! On Mar 22, Ian Gilfillan wrote:
Hi
I'm working on adding complete descriptions to the knowledgebase for all the server variables right now, and have a query on the read_buffer_size variable. The default in my MariaDB 10.0.1 seems to be 2097152, but it's listed on the MySQL docs with a default of 131072. I can't find a mention in the changelogs of this having changed - can anyone tell me in which version the change in default happened?
The hard-coded default is still 131072. Probably, 2097152 comes from your my.cnf file, on debian it contains "read_buffer_size = 2M" line.
Also, in the MySQL documentation, this variable is described as applying to MyISAM tables, while in the only short description on the Knowledgebase I can find, at https://kb.askmonty.org/en/mysqld-options-full-list/, it's described more generally, not specifically mentioning MyISAM. Does this variable apply to other storage engines as well now (Aria?), or still only MyISAM?
MyISAM, Aria, and MERGE. Regards, Sergei
Hi Does the bulk insert optimization used for MyISAM tables - the cache determined by the bulk_insert_buffer_size system variable - also apply to Aria (or any other) tables in the same way? thanks, ian
Hi, Ian! On Apr 01, Ian Gilfillan wrote:
Does the bulk insert optimization used for MyISAM tables - the cache determined by the bulk_insert_buffer_size system variable - also apply to Aria (or any other) tables in the same way?
Only Aria and MyISAM use it. Regards, Sergei
Hi! On 1 Apr 2013, at 20:24, Ian Gilfillan <launchpad@greenman.co.za> wrote:
Does the bulk insert optimization used for MyISAM tables - the cache determined by the bulk_insert_buffer_size system variable - also apply to Aria (or any other) tables in the same way?
This is only MyISAM and Aria -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/
participants (3)
-
Colin Charles -
Ian Gilfillan -
Sergei Golubchik