The Ultimate Guide to High Availability with MariaDB

Comments - Optimize Aria

10 years, 7 months ago Michael Widenius
Re: Optimize Aria [Answer]

Aria has most of the same variables that MyISAM has, but with an Aria prefix.

If you use Aria instead of MyISAM, then you should make key-buffer-size smaller and aria-pagecache-buffer-size bigger.

See https://mariadb.com/kb/en/aria-server-system-variables/ for a full list of variables you can use to optimize Aria. In most cases you only have to set aria-pagecache-buffer-size to a reasonable value.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.