We have issue with PHP-FPM + unoptimized SQL queries for the plugin(s).
Our PHP-FPM threads for the site which use the plugins grow fast in memory use and eventually become unresponsive.
The log attached is slow SQL query log. It indicates there’s a great number of queries generated by plugin(s) which are not using indexes and contribute to higher load.
We want to make sure the schema of the plugin and the queries generated by it are good for scalability / big database.