I want to monitor mysql databases (to get a mail ) whenever a new database,table or database dropped.I am able to find the monitor under commands and schema
1) Number of databases created
2) Number of databases dropped
I ahve two questions here.
1) I want to get mail alert when a new database is created/Dropped.What is the script to be written in the Alert condition and what is critical and warning condition i need to mention
2)I tried enabling this monitor and it started sending mails as number of database created:0 every five minutes(mail alert will come 5 minutes) .I edited notify to NO in view advanced settings but still i am getting alerts and filling my inbox.I suspect the change has not gone to underlying monyog database.
Could you help me in resolving this two issues please