Performance Tuning

Performance Tuning — 1 posts tagged

· 8 min read

MariaDB MySQL Performance Tuning: Buffer Pool, Slow Log, Indexes

Install MySQL or MariaDB on Linux, then tune innodb_buffer_pool_size, enable the slow query log, fix indexes with EXPLAIN, and lock down remote access.