Knowledgebase

How to Tune MySQL / MariaDB InnoDB Buffer Pool for Speed Print

  • 0

Accelerate database-heavy apps by caching hot tables in RAM.

Step-by-Step Instructions

  1. Set innodb_buffer_pool_size to ~50% of available RAM on dedicated DB servers (or 25–30% on shared web+DB servers).
  2. Restart MariaDB and monitor query times.
# In /etc/mysql/mariadb.conf.d/50-server.cnf:
innodb_buffer_pool_size = 2G

Pro Tip: Never allocate more than 70% of total RAM to MySQL to avoid OOM kills.

Need assistance? Open a ticket in the A1 Client Area or contact our 24/7 NOC Engineering Team on WhatsApp at +1 (406) 229-9597.


Was this answer helpful?

« Back