MySQL/Wordpress Performance Audit & Fix

projectn.com.br is running on MySQL and WordPress and, under high-traffic peaks, the database starts throwing performance-related errors that push CPU usage through the roof and bring the site down. I need a swift, thorough audit that pinpoints the root causes—whether it’s inefficient queries, missing indexes, mis-tuned MySQL settings, or something else—and an actionable plan that you can then implement so the site stays fast and stable.

Please start by running an in-depth analysis of the current MySQL configuration, slow-query logs, and server resources. From there, propose optimisations and, once approved, put them in place. I’m looking for concrete results: the site must load normally under our customary high traffic without database warnings or spikes.

Deliverables I expect:
• Diagnostic report detailing every bottleneck discovered
• Step-by-step optimisation plan with reasoning behind each change
• Implemented fixes on the live server (or staging if you prefer)
• Final load test showing stable performance and normal CPU levels

If you’re confident working with high-traffic MySQL environments and can move quickly, I’m ready to get started right away.