0

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for:

  1. Knowing what source is using the MySQL server most. (server ip?)
  2. What tables or queries contribute most to the bandwidth.
  3. Understand if something malicious is happening that I should fix.

I am running on AWS RDS and its using MariaDB.

Safwan Erooth
  • 273
  • 1
  • 6
  • Have you tried using `SHOW PROCESSLIST`? See `https://mariadb.com/kb/en/mariadb/show-processlist/` – Gmck Dec 18 '15 at 18:15
  • Yes, wanted more depth into it. – Safwan Erooth Dec 19 '15 at 14:14
  • 1
    One thing I have used for years for troubleshooting and diagnosis is the Percona Toolkit. You may want to give that a look. `https://www.percona.com/doc/percona-toolkit/2.2/index.html` – Gmck Dec 20 '15 at 20:23

0 Answers0