MariaDB + MySQL Governor on CloudLinux: High Load

A new account is generating very high MySQL load and huge binary logs, with impact on overall server load. Impact on server seems higher that account usage.

Reviewing MariaDB USER_STATISTICS table from information_schema (enabled plugin), compared usage of this account with next big user in various rows:
- CPU_TIME 12x higher
- BYTES_RECEIVED 3x
- BYTES_SENT 6x
- BINLOG_BYTES_WRITTEN 36x (getting 20Gb logs for 1 day)

There are sites logging 3x more connections generating lower load, so...

MariaDB + MySQL Governor on CloudLinux: High Load

from MySQL https://ift.tt/2DuQQ97
via IFTTT