Hi Steed,
To answer your questions briefly:
— MONyog's Dashboard displays the number of statements executed on the server being monitored, and not how many records these statements modified/inserted/deleted.
— Number of records added to/removed from a table in MySQL has no direct correspondence to the number of INSERT/DELETE statements executed on the server. A single INSERT may add multiple records to a table; a single DELETE statement may delete an entire table with thousands of records — They are still counted as 1 statement.
— MONyog uses SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES to collect server-wide stats. So if you're unsure if MONyog is displaying the right stats, you could always cross-check by executing these queries directly on your MySQL server. For example, the number of INSERT statements executed on your MySQL server can be found through:
Code:
mysql> SHOW GLOBAL STATUS LIKE 'Com_insert';
+——————-+————+
| Variable_name | Value |
+——————-+————+
| Com_insert | 102384 |
+——————-+————+
1 row in set (0.00 sec)
mysql>
Add to this the value of 'Com_replace' and you effectively get the number of INSERT statements that were executed on your server.
