Tune MySQL performance on Arm-based platforms
Review frequently asked questions
These FAQs were drafted with an approved AI-assisted workflow and reviewed by Arm contributors before publication. Human technical review remains part of the process so the final page reflects engineering rigor, accuracy, and Arm editorial standards.
Run the same repeatable workload before and after the change and compare throughput, latency, and profiles. Change one parameter at a time or use a designed experiment so results are attributable to specific settings.
Use an option file for persistent tuning so changes are reviewable, version controlled, and applied on restart. The examples in the Learning Path target the
[mysqld] group. Command-line flags are suitable for temporary tests.In general, locally attached SSD storage performs best, but network-based storage can also perform well. Test the storage technologies and file systems you have, and review disk scheduling behavior with your workload.
Evaluate them before or alongside MySQL tuning because operating system settings, kernel memory management, compiler choices, and library versions can affect throughput and latency. Treat them as part of the same performance experiment set.
Enable huge pages for MySQL and size them based on the InnoDB buffer pool. This aligns page allocation with the primary memory consumer in typical MySQL deployments.