[Mahesh]

You make sure that in “Notification settings” –> “Notify when server restarts” option is checked and try again.

 

1) What is the MONyog version you are using? Try using the latest GA build and update us.

2) Are you getting other email-notification alerts?

 

 

Regards,

Team MONyog

[Mahesh]

Hi,

 

Edit a slave server –> Advanced settings –> Replication select “Yes” for “Is this replication slave?” and click on “Save All” 

Now slave should appear in “Replication” tab.

 

Also, to get email notification first you should specify SMTP settings in Tools -> Mail settings and add recipient email addresses in (Edit server –> Notification settings)

 

 

Regards,

Team MONyog

[Mahesh]

Hi,

You can achive this using a CSO and CSC feature of a MONyog to monitor output of Custom SQL query, please refer these blog posts:

http://blog.webyog.com/2011/12/16/monitor-your-mysql-servers-like-never-before-use-csos/
http://blog.webyog.com/2011/12/19/how-to-add-a-simple-custom-object-in-monyog/

Note: You have to write a query where hosts that is connecting not in “a”, “b” and “c” are listed.

[Mahesh]

We will check this issue against v5.5.33 and update the status

[Mahesh]

Hi,

 

These errors are related to Real-time session. We need “MONyog.log” file to debug this issue you can upload it to our FTP server.

For privacy reason please create a support ticket by sending an email to “[email protected]”, we will continue discussion there and share FTP server details.

 

 

 

Regards,

Mahesh 

[Mahesh]

Hi,

 

You can see that there are SQLite files namely connection.data, mysql.data, system.data, sniffer.data in this file MONyog stores metadata about MySQL server.

 

You have to use SQLite client v3.7 or above to view the content of these database files.

You can download and configure latest SQLite client from https://sqlite.org/2014/sqlite-autoconf-3080300.tar.gz

[Mahesh]

Hi,

 

Please tell us these information to debug crash issue:

 

1. How many servers you are monitoring

2. Approximate number of users who accesses MONyog UI in organization

3. Real-Time session was running on MONyog?

 

 

Regards,

Team MONyog

[Mahesh]

You are welcome! and I hope you will love the application.

[Mahesh]

Hi,

 

Real-Time — Statement chart plots values based on type of queries executed on your MySQL server every 5 seconds. 

You can calculate the difference of the output shown in this query every 5 seconds and check against MONyog Real-Time interface.

 

For example: Execute this query now, note down the output and again execute the same query after 5 seconds, note down the output value and compare it with MONyog.

 

/* to get # of inserts executed */

SHOW GLOBAL STATUS LIKE ‘com_insert’;

 

/* to get # of selects executed */

SHOW GLOBAL STATUS LIKE ‘com_select’;

 

 

You will notice that in lower pane `Queries` tab does not show exact # of queries as values shown on upper pane for Statements charts, this is because MONyog sniffs data every 1 second using Show Full Processlist; query and hence short lived queries (queries which takes < 1 second) won't be shown in `Queries` tab.

 

Let us know if you need any help.

 

 

 

Regards,

Team MONyog

[Mahesh]

You can monitor MySQL cluster using MONyog

 

1) Register a Galera Cluster Node in MONyog – Specify Hostname, port and valid credentials in “MySQL settings” and click on “Test Connection”

If the connection is successful, click on “Save ALL”

2) Now, Enable “Galera” group from “Customize” –> “Manage monitor groups”

3) Now open Monitors page, select a group called “Galera” and you can see monitors values under this group.

 

You can see in Galera group there are ~10 important monitors MONyog has, MONyog gets these statistics information about Galera Cluster from these status variables,

http://www.codership.com/wiki/doku.php?id=galera_status_0.8

 

 

 

Regards,

Team MONyog

[Mahesh]

Hi,

 

Y-axis value for Database Transactions of 4.883K means (4.883 * 1024=5000) transactions happened between last two data collections (Default data collection interval is 5 minutes).

 

 

Regards,

Mahesh

[Mahesh]

OK .. We have replied to this question on a ticket system. 

[Mahesh]

Real-Time feature was not avialable in v3.76, you can still get your original queries in Query Analyzer by for (Slow, general and Sniffer) output.

We do understand that show query should show original query along with a query replaced with a placeholder `?`

This change we are planning to implement in Real-Time in next public release itself, you can get first query in it's original form along with a query replaced with ?

[Mahesh]

Hi James,

We do have a plan to show First executed query in original format when user clicks on `Show query`.

FYI, you can get original query by click on `Explain Plan` link next to `Show query`. If you are monitoring MySQL v5.5 above then EXPLAIN for Insert, Delete and update also available.

Thanks for you suggestion.

Regards,

Team MONyog

[Mahesh]

Hello,

We think you have changed MONyog port to 80 and hence MONyog is not starting on it because webserver like Apache or IIS runs on port 80.

1) Make sure that MONyog is running on port 5555 (default port 5555) and no other service is accessing this port ?

2) You can edit and see port number for MONyog in MONyog.ini file, it should be 5555, you can change it to other port where no other service is running?

Let us know if this helps.

Regards,

Team MONyog

[Author]

Posts