[Mahesh]

Hello,

By default `[background=rgb(255, 255, 204)]Admin[/background]` password is blank, you can login without specifying any password.

Incase you have specified a password for `[background=rgb(255, 255, 204)]admin[/background]` user then you should remove it from “MONyog.ini” file and restart MONyog service.

“MONyog.ini” file can be found in /MONyog/ directory.

You can refer FAQ entry #8 here:

https://static.webyog.com/docs/MONyog/MONyog.htm#FAQ.htm

Let us know if you need any help.

[Mahesh]

Please edit a server –> `Notification settings` –> `Send notificaiton when alertable` change value from 5 (default value) to 1 to get immedite alert for Warning/Critical events.

[Mahesh]

Hello,

You can create a alert/monitor for max_connections variable if you hit a threshold

1) Click on a “Max_allowed” monitor from “Current Connections” group

2) Click on “Customize” –> “View Advanced” and do the changes as mentioned in screenshot (alert_condition.png)

Note: Warning and Critical values you can specify depending on your requirement.

[Mahesh]

Only Replication, Processlist, Real-Time and Disk info executes queries on demand, hence # of query execution on servers depends on # of users accessing these features.

[Mahesh]

Make sure that MySQL server detail entered is correct, also are you getting this error only on PROCESSLIST page?

You can go through this link wherein causes of communication errors has been mentioned http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html

[Mahesh]

This is because value of 'innodb_log_waits' most of the time remains to '0' and We do not always INSERT into [snapshot_master]. Only if the particular metric was changed since last time something was INSERTED for that metric we will INSERT again. So if you want to find the value of a metric at some particular time you will need to find the most recent value stored before that particular time for that particular metric.

MySQL documentation says `Innodb_log_waits` – The number of times that the log buffer was too small and a wait was required for it to be flushed before continuing.

[Mahesh]

Please let us know these details:

i) How much is data collection interval for 'piscesdb01' server ?

ii) How many MySQL servers you have registered?

c) Zip and attach MONyog.log file here, if file is too big then create a support ticket by sending an email to '[email protected]' we will share our FTP server details

[Mahesh]

Currently it's not possible to configure a proxy in MONyog to check for update-check, but You can subscribe to our blog from here:

http://blog.webyog.com/category/monyog/

Regards,

Mahesh

[Mahesh]

In Notification settings there is an option 'Send notification when alert-able'= 5 (This is default settings and indicates that if a counter stays in alertable state for 5 consecutive data collection then only email notification will be sent, you can change it to 1 to get immediate notification if a counter reaches it's threshold value)

Let us know if you need any help.

[Mahesh]

MONyog uses SMTP server details from “Tools” –> “Mail Settings” make sure it sends “Test Mail” successfully and then give recipient email-id(s) for a registered server, save it and restart this server, recipient should get an alert mail.

[Mahesh]

Quote:

What is the best way to improve the retrieval speed of historical data? Reduce the data retention timeframe? Increase the collection interval? Disable as many monitors as we can

–> There is an option you can either view History report grouped by “Minutes”, “Hours”, “Weeks” etc .. you can choose as per your requirement.You have given 32 days as data retention timeframe, if you think you want to get historical data for a month you can keep it otherwise change it (default is 7 days). Also as you have mentioned data collection as 5 seconds, MONyog will work for such a small interval but it's recommended to use data collection interval as 5 minutes (5 minutes is default collection interval)

If you can share “mysql.data” and “system.data” with us it will be better also it does not contain any authentication details about your server.

You can create a support ticket by sending an email to [email protected] , I will share our FTP server details there for privacy concern.

Quote:

Is there a way to tell MONyog it can use more system resources?

–> MONyog configuration does not have any limit on use of system resources, it's dependant on OS.

[Mahesh]

VIEW/EXPLAIN option is enable only for queries and for other threads such as replication, SLEEP you can't get view icon.

Make sure that 'Info' column in PROCESSLIST page shows query, to get VIEW/EXPLAIN option.

[Mahesh]

SMTP settings applies to MONyog configuration, on top of this you need to configure each server to receive notifications email.

Register/Edit server –> Notification settings tab –> You should specify recipient email addresses separated by comma to whom you want to send notification emails in case there are critical alerts. (Refer attached screenshot)

[Mahesh]

Ok.. can you create a support ticket by sending an email to '[email protected]' for privacy.

We may have a screen sharing session to resolve this problem.

[Mahesh]

@dvanhollen

i) Make sure that SSH connection from MONyog is working? (If you are able to connect to Linux host using putty, FileZilla standard SSH client then MONyog should also be able to connect to Linux host)

ii) You have to give Linux details in Add/Edit server –> SSH settings section, also you have to enable 'Linux' group from 'Advanced settings' –> Monitors section (Refer attached screenshots) to get OS metrics.

[Author]

Posts