Monitoring in mysql

Question

Please tell me how can I track the insertion rate per second for a table with mysql?

Thank!

Answer 1

You can control it in real time just by doing something like this

• Count the number of lines
• Wait xseconds
• Count the number of lines, find the delta ybetween two values
• rate = y/x

If you do not want to do this in real time, you can analyze the MySQL binary log to see how many insert statements have been executed and received timestamps.

, , , . , , ...

SELECT count(*) AS inserted 
FROM table 
WHERE unix_timestamp(created) BETWEEN unix_timestamp()-3600 AND unix_timestamp();

, ( ), - munin ( , , ).

Answer 2

SHOW STATUS LIKE 'Handler_write'

, . , . .