Identifying who makes a lot of INSERT requests in MySQL

Question

Hello. Recently, I noticed that my MySQL server processes a lot of INSERT's. How can I detect user or DB on which is this activivty??

insert    33 k    97.96 k 44.21%

Answer 1

Look in your query logs. This will show every connect into MySQL, and show every command that they execute.

Answer 2

SHOW FULL PROCESSLIST will return every connection, user, and query currently active, if you have the PROCESS permission. That's more for immediate problems, but it has the least overhead.

If you use query logging, then instead of the regular query log (it can slow your server down noticeably) use the binary log to keep it minimal. It only tracks actions that change tables, like CREATE/DROP/ALTER and INSERT/UPDATE/REPLACE.