Database Performance Tuning and Optimization with MariaDB

To get the best performance possible and to deliver significant performance improvements without hardware upgrades, you need to optimize memory, storage and network usage based on current hardware and workloads – and it can be done with small configuration changes.

First, you have to know what configuration changes can be made and where – database, operating system or application. Second, you have to know when and why to make them.

We’ll explain recommended configuration changes for high-performance production deployments, demonstrate enterprise tools for monitoring and diagnosing performance issues.

Join us to learn how to:

• Modify the default configuration for production hardware
• Improve the performance temporary tables
• Optimize memory usage with caches and buffer pools
• Reduce disk IO with InnoDB and Linux optimizations
• Support many short-lived and/or concurrent connections
• Use a database proxy (MaxScale) to improve performance
• Use available network bandwidth more efficiently
• Monitor performance with Monyog, an agentless solution for MariaDB