Optimize Aria

When I want to use aria I need to configure the standard myisam variables in my my.ini or something new ? like aria_key_buffer_size or I dont know :)?

I hope you understand...

Answer Answered by Michael Widenius in this comment.

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.

Comments

Comments loading...
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.