Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Hi,
while testing the "no InnoDB Buffer Pool in core dumps" feature (details in [1]), I discovered that aria_pagecache_buffer_size is not dynamic. This is inconvenient as tuning needs restarting the server. In comparison, key_buffer_size is dynamic for a long time ([2]) and innodb_buffer_pool_size is dynamic since MariaDB 10.2 ([3]).
[2]: https://mariadb.com/kb/en/library/myisam-system-variables/#key_buffer_size
[3]: https://mariadb.com/kb/en/library/xtradbinnodb-server-system-variables/#innodb_buffer_pool_size
Please make aria_pagecache_buffer_size dynamic.
Note: the priority of this task is set as Major. The main motivation is that the default value for aria_pagecache_buffer_size is 128 MB, which is a lot. If the default value was much smaller (8 MB or less), the priority of this task might be lowered.
Related: MDEV-16607: Consider smaller defaults for MyISAM and Aria cache sizes.
Thanks in advance,
JFG