[pankajk1608]

Hello,

 

Currently we do not have the option to export the data in processlist tab as CSV. We have added your request in our wishlist, priority for it is not decided though.

 

 

Regards,

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

Please provide us with the following:

 

1. Can you please check if there is any error in browser’s console window. To do this right click anywhere in the browser window when you are in Monitors page and select “Inspect Element“, then select Console tab. Now refresh the page and see if there is any error in console. Please send us the screenshot, if you get any error there.

 

2. Please send us the complete MONyog.log file, based on your installation and OS it can be found in 

Windows:

ProgramDataWebyogMONyogMONyog.log

Linux System:

for RPM: /usr/local/MONyog/MONyog.log

for .tar: /MONyog/MONyog.log

 

You can create a support ticket at [email protected], and send us the MONyog.log file there.

 

Regards,

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

This issue related to the curl library crash while resolving too many hostnames was fixed in our latest release MONyog-6.51. You can go ahead and upgrade and the issue will be fixed.

 

Regards,

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

Currently MONyog does not support filtering based on a table or a query. We have added your request in our wish-list, priority is not decided though.

 

Regards,

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

We have upgraded our SQLite library in our latest release MONyog-6.51, can you please upgrade and see if the problem persists?

 

Also, please send us the complete MONyog.log file to “[email protected]”, so that we could look into the issue.

 

Regards,

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

Please provide us with the following information:

 

1. Are you using a direct connection or ssh connection to connect to your server through MONyog?

 

2. Is the user specified in the above error being used in any other applications other than MONyog?

 

3. Do you have any CSO (Custom SQL Object) enabled in MONyog?

 

4.  Please send us the MONyog.log file, based on your installation and OS it can be found at:

Windows:

ProgramDataWebyogMONyogMONyog.log

Linux System:

for RPM: /usr/local/MONyog/MONyog.log
for .tar: /MONyog/MONyog.log

 

Also, please create a support ticket at [email protected], and we will continue there.

 

Regards,

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

You are getting the error because the query you are running is too long for ‘performance_schema’ table of your server to return.MONyog uses performance schema statement digest table(events_statements_summary_by_digest and events_statements_history_long) to get this information for “Explain Plans” .If the query exceeds ‘1024’ bytes,then you will only get to see the truncated query upto 1024 bytes in MONyog as this much query is only returned by the server.This value is by default and you can change this value to your need,refer here: http://dev.mysql.com/doc/refman/5.6/en/performance-schema-statement-digests.html

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

You can have the mail alerts for the counters “Number of databases created” and “Number of databases dropped” by putting a small script in the space provided for “Alert Condition”,so that you will get an alert whenever a database is created or dropped. First of all, you discard all the changes that you have made till now (since you are getting the false mail alerts,there may be some error in your script), to do this, go to “Customize -> Manage changes -> Discard your changes(by clicking on the actions button)”. After this write the  following script in the “Alert Condition” box of the counter “Number of databases created” :

 

function()

{

if(this.Value >=1)

   return “Critical”;

else

   return “None”;

}

 

Please make sure that you have the notification alerts enabled for your server. 

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

MONyog can send you mail for different parameters of your MySQL server,depending on how you have configured the notification/alert settings for those in MONyog,however,MONyog cannot send you a consolidated report containing the parameters.You can set up alert values for the different counters and you will get the alerts separately for those.

 

You can have the consolidated report containing the values for all the counters by using “Export as CSV” option manually.You can use “Export as CSV” from the drop down list of each server to get the different values for your server at any given point of time at one place.

Click on ‘Monitors’ ->click on the arrow beside server’s name(a downward pointing arrow) -> Select “Export as CSV” from the drop down menu->the file will download.

You will get a CSV file containig the current values of all the counters.

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

You can use “Export as CSV” from the drop down list of each server to get the different values for your server at any given point of time at one place.

Click on ‘Monitors’ ->click on the arrow beside server’s name(a downward pointing arrow) -> Select “Export as CSV” from the drop down menu->the file will download.

You will get a CSV file containig the current values of all the counters.

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

MONyog sends alerts only when the slave stops running,and what you are saying is an unexpected behaviour.We would like to see the screenshots of your customize settings page of the counter ‘Slave running?’ and also the notification setting page so that we could look into the problem that you are facing.

 

1. For screenshot of customize settings page of the counter ‘Slave running?’ do:

– click on the counter ‘slave running’-> customize-> then on the top right hand corner click ‘view advanced’-> take the full screenshot of this page.

 

2. For screenshot of notification setting page,do:

 

-Edit server -> notification settings -> (SMTP or SNMP must be enabled here) take the screenshot of this entire page.

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

MONyog already has this group  named ‘Replication’ in which there are differnet counters related to replication.In this group,the counter ‘Slave running?’ shows alert when the server stops running as a slave.All you need to do is enable Notification Settings to get the mail for the alerts.You can do this by :

 

1. Edit server -> Notification settings -> click yes on “Send Notification over mail(SMTP)” or click yes on “Send Notification over SNMP”

 

2.Now click on the ‘Configure Mail settings’ which appears after clicking yes in “”Send Notification over mail(SMTP)” or “Send Notification over SNMP”.

 

3. Give your email id in the blank ‘Your email’ and save the settings

 

You will get your alerts on the email id you entered.

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

MONyog already has this group  named ‘Replication’ in which there are differnet counters related to replication.In this group,the counter ‘Slave running?’ shows alert when the server stops running as a slave.All you need to do is enable Notification Settings to get the mail for the alerts.You can do this by :

 

1. Edit server -> Notification settings -> click yes on “Send Notification over mail(SMTP)” or click yes on “Send Notification over SNMP”

 

2.Now click on the ‘Configure Mail settings’ which appears after clicking yes in “”Send Notification over mail(SMTP)” or “Send Notification over SNMP”.

 

3. Give your email id in the blank ‘Your email’ and save the settings

 

You will get your alerts on the email id you entered.

 

Regards

Pankaj

Team MONyog.

[pankajk1608]

Hello,

 

MONyog has this ‘Real Time’ feature using which you can see the databases which are being used and how much load it is causing.To view this

1.Go in the Real Time section.

2.Select the server from the drop down menu then select new session and then hit start button.

3.After this,click onto the databases tab,and it will show you the databases being currently used and how much load they are causing.

 

Regards,

Pankaj

[Author]

Posts