maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "Aria" by paul.pech_41353. Please answer it at http://mariadb.com/kb/en/aria-system-variables-aria_block_size/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
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
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/aria-system-variables-aria_block_size/