Table Fragmentation Feature Suggestion

[Enea]

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

[peterlaursen]

You can integrate this into MONog yourself using the ‘Custom SQL Object’ feature.

 

 

links:

htlp://blog.webyog.com/2011/12/16/monitor-your-mysql-servers-like-never-before-use-csos/

http://blog.webyog.com/2011/12/19/how-to-add-a-simple-custom-object-in-monyog/

 

and two documentation pages:

https://static.webyog.com/docs/MONyog/MONyog_MySQL_Monitor_Custom_SQL_Objects.htm

https://static.webyog.com/docs/MONyog/Add_Custom_SQL_Objects_MONyog_Monitor_Advisor.htm

[peterlaursen]

First link should be 

 

http://blog.webyog.com/2011/12/16/monitor-your-mysql-servers-like-never-before-use-csos/

 

(it was not inserted as a clickable link in previous post)

[Author]

Posts