Every time I update or publish a movie post from WordPress admin (wp-admin), my server load spikes dramatically for 1–2 minutes. Sometimes MariaDB (MySQL) uses over 2000% CPU during this period, and the site slows down or becomes unresponsive temporarily.
Here are some details about my setup:
• Server: AMD Ryzen 9 5950X, 128 GB RAM, NVMe SSD
• Software: LiteSpeed + MariaDB (MySQL) + Redis
• Database is optimized: indexes on postmeta, options, etc. are already in place
• Caching plugin: WP-Optimize with Redis object cache
• Traffic: 3,500+ concurrent users at peak (movie streaming website)
The issue ONLY happens when I update a movie, so I strongly suspect it’s related to the DBMovies plugin logic (possibly due to save_post or external API fetches).
Can you please:
1. Confirm if DBMovies fetches or processes any heavy data on update?
2. Suggest how we can defer or disable some of this heavy processing during movie updates?
3. Offer any best practices for high-traffic servers to avoid this?
Thanks in advance for any help or guidance — happy to provide logs or slow queries if needed.