The Ultimate Guide to High Availability with MariaDB

Comments - MONyog Table Alert

7 years, 8 months ago Sibin AS
Re: MONyog Table Alert
This comment has the status of 'removed' and can only be seen by you.

You can create a Custom SQL Object (CSO) in MONyog to monitor the table size of a particular table. You may use the below query to create a CSO,

SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME";

Please specify the database_name and table_name you would wish to monitor in place of ‘$DB_NAME’ and ‘$TABLE_NAME’ in the above query.

You may refer our documentation on creating new CSO and CSC (Custom SQL Counter for the new CSO), here >> http://monyogkb.webyog.com/article/67-new-csos-and-cscs

You may write to support@webyog.com if you have any further queries. Sibin (Webyog)

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.