Since the tables you want to check are MyISAM, you can use just one query. For any given table or tables using MyISAM, here is that query:
SET @SecondsAgo = 60;
data_length MYDSize,index_length MYISize,
AND table_schema NOT IN ('information_schema','performance_schema','mysql')
AND update_time > (NOW() - INTERVAL @SecondsAgo SECOND)
ORDER BY update_time DESC;
For each MyISAM table, you will get the following:
- table name and database
- number of rows in the table
- last time the table was updated
You can set
@SecondsAgo to choose how granular to scan for changes.
If many tables or the same set of tables appear from this query, you will see which tables are experiencing the most frequent writes and the most growth.
I will leave it to your to determine the weirdness from the results.