Media Gallery causing excessive database load

We've noticed that XFMG is causing an undue load on our database. The most common XFMG queries account for more than half our database CPU time, despite requests numbering in the low hundreds of thousands over a 7-day period. Meanwhile, the XF core and our numerous other add-ons make hundreds of millions of requests without issue in the same time period.

Recently, XFMG has caused spikes to 100% CPU usage on our very large DB (10 vCPUs and 64GB RAM), which in turn causes response delays...

Read more

Читать далее...