Tag: Performance Optimization

  • 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.