I find the following select useful to see how much MyISAM tables are fragmented:
select engine, table_schema,table_name, round(data_length/1024/1024) as ldata, round(index_length/1024/1024) as lindex, round(data_free/1024/1024) as lfree, round(data_free/data_length*100,2) as unused from information_schema.tables where round(data_free/1024/1024) > 0;
It could be useful if this information could be directly integrated in MONyog.
For example it would be nice to get alerts for tables > 1Gb if the unused space > 20%
Edit: I posted in the wrong forum, but I can’t delete or move the post to the correct one