Nginx Runbooks

Debugging 504 Gateway Timeouts During Traffic Spikes: Nginx FastCGI & MySQL Pooling

How an unindexed wp_postmeta query triggered cascading PHP-FPM process lockups and 504 Gateway Timeouts under 300 concurrent users, and how buffer tuning and composite indexes stabilized the server at 12% CPU.