Agent sent a lot of queries to the database

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.

https://releem.com

GNU General Public License v3.0

257 stars 28 forks source link

Agent sent a lot of queries to the database #374

Closed drupaladmin closed 2 days ago

drupaladmin commented 2 days ago

An agent was stacking my database. 30k queries per unit of time... The machine was running out of juice. Turned the agent off.

drupaladmin commented 2 days ago

Thanks for reaching out. We're checking it now. I'll keep you informed.

drupaladmin commented 2 days ago

Analyzed metrics and queries.

I've sent a screenshot of the query analytics The biggest load was created by the first 2 queries, they were executed 3.6 billion times in the last ~3 days.

The agent sends queries to the database no more than once per second.

I am also sending a graph of the number of queries per second. You can enable the agent, there is no bug.

Please let me know if you have any questions, I'll be happy to help.