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

OPTIMIZE my.cnf

I need help for optimize my.cnf what parameters are important and the optimal values? I have a server with 8 core, 64 GB Memory, raid 10 and engine=innodb

I want that MariaDB use a lot of memory too

Thanks.

Answer Answered by Federico Razzoli in this comment.

You need to change only few options. The most important thing is that you reserve enough memory for InnoDB's buffer pool.

My advice is that you read these great resources:

Of course if it's a development machine memory is less important and you can also consider disabling some features (storage engines, network capabilities).

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.