[Mahesh]

You can Disable MySQL related charts from “Manage Dashboard charts” page.

Open Dashboard page –> On top-right corner you will see a link “Manage Dashboard Charts” click on it.

Now Select charts you do not want to see in Dashboard page and –> Click on “Disable”,

Similarly you can enable system related other charts from same page.

Note: These changes will be applied to all servers not specific to a particular server selected on Dashboard page,

Customization of charts on Dashboard page at server level is not implemented.

[Mahesh]

You can't edit content of email Alert.

We do have plan to implement different email subject templates for Mobile users and other users.

For people who access their mails on Mobile device for them currently it is difficult to make out what is wrong(Which particular counter has reached threshold value etc..) until opens an email to read in detail about subject and content.

[Mahesh]

Actually this is generic message we are showing in-case there is no query logged or by mistake user has specified incorrect file path for slow log section mentioned “General log” file path and vice-versa.

I have added your request regarding 3rd line:

Code:

Make sure you have given valid slow query log file. Slow Query Log and General Query Log have different formats. Make sure you have entered the correct filename. Click here to review settings for this connection

Program should have extra check, whether mentioned file path belongs to slow log or general log respectively or any other invalid file path.

[Mahesh]

We have this feature request in our issue tracking system.

We are busy with some important features like CSOs (Custom SQL Objects) and complete new interface.

Probably it will take another 2-3 months to implement this feature.

Thanks for your suggestion.

[Mahesh]

Quote:

Quote:

That means Percentage of full table scans (66.2%) ??

This value (66.2% in your case) indicates the percentage of rows that were accessed via full table scans.

To get more details for “Percentage of full table scan” counter, Click on it you can see Description, Formula and Advice.

Regards,

Mahesh

[Mahesh]

Which MONyog build are you using? Can you update to latest build v4.72

Please mention information listed below:

1) How many servers are registered?

2) Are you using SSH tunnel to connect to MySQL server?

3) Are you collecting OS metrics?

4) How much is the Data collection Interval time?

5) Processlist/proxy Sniffer is enabled?

6) Is Email Notification is enabled?

7) Mention OS where MONyog is running? If linux send us output of these commands:

i) uname -a

ii)cat /etc/issue

Also, You can create a support ticket by sending an email to '[email protected]'

[Mahesh]

You have created a ticket as well.

We will reply to you over ticket itself.

[Mahesh]

Install MONyog and register a problematic MySQL server. While registering enter valid details for what things you want to monitor.

For example:

If you want to monitor SSH server where MySQL server is running you can add this detail in SSH settings.

Again if you want to analyze slow log to find out slow running queries you can enter slow log file path details in “MySQL Query log” settings

Also you can enable sniffer to sniff real time queries and get notification for long running queries in “Sniffer Settings” etc..

Once you registered successfully select a server and GoTo Monitors page.

Here you might see some Warning/Critical events try to clear them by making changes to MySQL server's configuration file (my.cnf/my.ini file).

To find out problematic queries you can use Query Analyzer feature to get aggregated view of slow running queries.

Later you can optimize those queries by adding indexes, changing datatypes etc..

To optimize queries you may use SQLyog (MySQL GUI) which has several feature for optimizing query like 'Query profiler', 'Calculate Optimal Datatypes' and 'Find Redudant Indexes' etc..

This is continuous process in order to get optimum server performance.

I suggest refer MONyog help documentation and whitepaper from here:

http://www.webyog.com/doc/index.php

http://www.webyog.com/en/whitepapers/MONyogWhitePaper.pdf

Regards,

Mahesh

[Mahesh]

Please tell MONyog version you are using?

Also We need mysql.data file of a server for which bytes_sent shows spike of (4.2G) for a minute.

Please create a support ticket by sending an email to “[email protected]” for privacy.

We will provide you FTP details over ticket.

Thanks,

Mahesh

[Mahesh]

Then during that point-in-time bytes_sent value might be 0.

Please check History/Trend report without using any GROUP By option.

While generating chart uncheck option called “Group by” and see report and compare against point-in-time where graph dipped to 0 in monitors page.

For example:

If bytes_sent graph shows value 0 at 12:15:00 then generate report without using Group by option between 12:00:00 to 12:30:00 and check value at 12:15:00, Does value matches?

[Mahesh]

Quote:

I can see that the data is collected from the 'Bytes_Sent' global status item in MySQl itself, and that the data appears to be a cumulative total since the server came up.

Within the customisation page for the advisor I can see that the 'Graph' option is not enabled, however there is a Graph.

— Actually if a counter is UPTIME based(You can check by Editing counter definition) then MONyog shows Graph for those irrespective whether chart is Enabled/Disabled.

Quote:

The graph does not appear to show the data collected from the bytes_sent collection but much lower values.

– Currently I am assuming that this is the difference between the last 2 collections. Can anyone confirm / deny this?

— Graph always plots values based on Delta (difference between last 2 collections).

Quote:

– Secondly I am interested in what occurs if a collection fails. Can anyone provide this information? Is collection result data logged anywhere?

— If there is no connection between MONyog and MySQL server then data won't be collected and chart will show blank during that period, once MOnyog starts collecting data chart will populate based on newly collected data again.

MONyog does sends an alert if MySQL server is not reachable because of reasons like MySQL server is not running, Credintials were changed/wrong etc..

Collection result data will log information not only if there is active connection between MONyog and MySQL but also if there is no connection.

Quote:

We are seeing points on this graph which drop down to 0 at seemingly random intervals. (See Attachment)

I would like to identify whether this is a collection failure, a true network traffic interruption or just a quiet minute.

– Collection failure seems more likely as we are not experiencing any application problems and this server in question is under production load all day.

— Can you check History/Trend for “General Info” — “Available” group for a period you observe this. If there is “No” entry in report which matches exactly at time when bytes_sent graph shows 0, then we can conclude that there is a network related issue.

What does history/trend report shows during a period when bytes_received shows 0 in graph.

Also What does MONyog.log says during a period when bytes_sent shows 0.

I guess there might be network failure.

[Mahesh]

Can you please explain in detail problem you are facing with v4.62 ?

[Mahesh]

Currently MONyog retrieves system information of Linux OS only via /proc.

Please check Linux group in Monitors page after registering valid Linux server.

User defined command on Linux is not supported currently but we do have a plan to add custom counters for Linux.

We have not set priority tom implement this feature yet, it may take 3-4 months.

Thanks,

Mahesh

[Mahesh]

Hi,

Thanks for your information.

I think it will be better to have a screen sharing session to check reported issues.

Can you please create a ticket by sending an email to “[email protected]”

[Mahesh]

You may refer this blog post:

http://www.webyog.com/blog/2011/07/20/what-are-hardware-requirements-for-monyog/

[Author]

Posts