Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 439 total)
  • Author
    Posts
  • in reply to: #34827
    Mahesh
    Member

    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

    in reply to: #34825
    Mahesh
    Member

    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

    in reply to: #34824
    Mahesh
    Member

    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.

    in reply to: #34821
    Mahesh
    Member

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

    in reply to: #34823
    Mahesh
    Member

    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 

    in reply to: #34774
    Mahesh
    Member

    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

    in reply to: #34778
    Mahesh
    Member

    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

    in reply to: #34767
    Mahesh
    Member

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

    in reply to: #34765
    Mahesh
    Member

    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

    in reply to: #34761
    Mahesh
    Member

    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,

     

     

     

    Regards,

    Team MONyog

    in reply to: #34753
    Mahesh
    Member

    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

    in reply to: #34752
    Mahesh
    Member

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

    in reply to: #34729
    Mahesh
    Member

    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 ?

    in reply to: #34726
    Mahesh
    Member

    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

    in reply to: #34695
    Mahesh
    Member

    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

Viewing 15 posts - 16 through 30 (of 439 total)