[GUIDE] Optimizing MySQL Queries for Massive XenForo Forums As your forum grows past 500k posts, default MySQL configurations will cause high CPU spikes and slow page loads. Here is how to tweak your my.cnf for maximum throughput. Key Configurations to Modify: Open your MySQL configuration...