The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Aria System Variables: aria_block_size

Hi

Are there any guidelines on how to decide what block sizes to use for Aria index pages?

We've just switched from MySQL and MyISAM to MariaDB and Aria and noticed a significant drop in performance when full table scans are necessary.

In our environment we have 10.000+ databases each with about 20 tables. Each database is usually smaller than 30 - 40 MB (90% of this is contained in roughly 3-4 tables, all other tables usually contain just a couple of rows).

Am I correct in assuming that in this case (many comparatively small tables) a small block size (say 2048) could help to improve performance, while for huge tables a larger block size (the default value) is recommended?

Any other tips on how to fine tune Aria in particular and MariaDB in general for our use case are highly appreciated.

Thanks for a great product and a well written documentation!

Yours

Paul

Answer Answered by Ian Gilfillan in this comment.

For full table scans, the default PAGE format is slower than the DYNAMIC and FIXED formats. Perhaps this explains the difference in your case. See the Aria FAQ.

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.