Tag: Performance Optimization
-
CPU Pinning (Optional)
CPU pinning (also called CPU affinity) is the practice of binding MaxScale threads to specific CPU cores. By default, the operating system scheduler moves threads between cores to balance load. While this is generally efficient, in high-concurrency workloads, context switching and cache invalidation can reduce performance and increase latency. Why Use CPU Pinning How to…
-
MaxScale Multiplexing and Caching – Part 6
Riley examines MaxScale’s caching engine, explaining how SELECT queries can be served from memory instead of the database to reduce latency and offload workload. The author details TTL behavior, invalidation rules, thread-level vs global caching, and practical scenarios where caching provides significant gains.
-
Running MariaDB on VMware: A Comprehensive Guide & Best Practices
Virtualising MariaDB on VMware vSphere / ESXi unlocks major benefits — like scalable provisioning, high availability, and more efficient hardware utilization. But without careful tuning, databases can suffer from latency, I/O bottlenecks, and resource contention. In this guide, Kester Riley outlines a holistic approach to building MariaDB VMs for performance and reliability.