Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 66 Next 30 Older Entries

Displaying posts with tag: MONyog (reset)

Webinar – Monitoring MySQL and MariaDB databases with MONyog. Register now
+0 Vote Up -0Vote Down

Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

Date: Tuesday, July 8, 2014
Time: 10:00 am PT
Presenter: Rohit Nadhani (CEO, Webyog)
Register your spot for free

  [Read more...]
MONyog MySQL Monitor 6.0 Has Been Released
+1 Vote Up -0Vote Down

Changes (as compared to 5.72) include:

* The MONyog API is enhanced with more options to manage servers registered in MONyog. Options now include calls to add/edit/remove servers. Refer documentation for full details.
* MONyog now supports Query analysis using Performance Schema tables (events_statements_summary_by_digest and events_statements_history_long tables). This feature is supported only for MySQL 5.6.14 and MariaDB 10.0 and above.
* Explain plan is available in Query analyzer for Slow_log table based logging and Processlist sniffer.
* An example query is now shown in detailed query view in

  [Read more...]
MONyog MySQL Monitor 5.57 Has Been Released
+0 Vote Up -0Vote Down

This is the current (and supposed to be the last) MONyog release in the 5.5x series.  Refer online documentation for details of changes in this and previous releases.  The major scope of all releases in 5.5x series has been improving stability, performance and responsiveness under heavy load -  such as large number of servers both registered and displayed at the same time, user activity by multiple users at the same time, ‘query sniffer’ running in the background etc.  We have worked with a number of customers using MONyog in such demanding environments during the 5.5x development phase.

  [Read more...]
How to Monitor MySQL Replication?
+3 Vote Up -0Vote Down

Just setting up MySQL replication is not enough, you would need to periodically monitor your slaves to ensure they continue to work seamlessly. Here is a basic overview of the Slave variables to monitor and the tools that will help you monitor those with ease.

Top variables to monitor on your slaves

Replication is best monitored by checking the following variables-

  • SLAVE_RUNNING: This is a global status variable and its value can be checked using SHOW GLOBAL STATUS like 'slave_running'. It can either be ‘ON’ or ‘OFF’.

    If slave_running is ‘ON’, then the slave is up and working fine, which means both the SQL thread and the IO thread are

  •   [Read more...]
    What’s happening on your MySQL server right now? Real-time monitoring has the answer!
    +3 Vote Up -0Vote Down


    You have been using MONyog to monitor your MySQL servers. You connected your servers with MONyog and collected data to analyse later. MONyog did a great job analyzing past performance. If you know something is wrong and don’t have MONyog monitoring your MySQL, you cannot do much to fix things right then. You’ll have to first add your MySQL to MONyog and wait till data collects.

    Not any more. Introducing real-time monitoring with MONyog 5.5. It tells you what’s happening on your MySQL server RIGHT NOW. It details key metrics like top 200 queries, slow queries, locked queries, locking queries, tables, databases, users, hosts and thread states, all of this in real-time

      [Read more...]
    HOWTO: Integrating SSH tunneling inside your application
    +4 Vote Up -0Vote Down

    Security is always a major concern in an application. But when an application attempts data communication over a network, it becomes even tougher ordeal to keep the connection secure. In this post we will discuss about Secure Shell (SSH) to add an extra security edge to your application when it communicates over a network.

    What is SSH Tunnel?

    SSH is an encrypted network protocol generally used for remote shell service, secure data communication, command execution etc. In SSH tunneling, a payload protocol is wrapped around the SSH protocol (the delivery protocol) and sent over the network.

    When is SSH tunneling useful?


      [Read more...]
    Top 10 things to monitor on your MySQL
    +2 Vote Up -0Vote Down

    Monitoring MySQL servers is no rocket science provided you know what to monitor. MySQL gives a comprehensive list of variables to check your server’s health and performance. Let me walk you through the crucial variables you should be monitoring. Lets assume that you have one or more MySQL servers, which have been setup and running fine. Here are the top 10 things to monitor on your MySQL.

    1. MySQL availability

    Yes, this is the first thing you should be looking at! It would not make sense to monitor your MySQL if its not even available. MySQL downtime is simply not acceptable in production. At the same time ensuring zero

      [Read more...]
    MONyog MySQL Monitor 5.3 Has Been Released
    +0 Vote Up -0Vote Down

    Please note that users upgrading from a version before 5.2 will need a new registration code. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until MONyog is registered with the new key, it will not be collecting data from your servers.

    Changes (as compared to 5.21) include.

    * Introduced support for ‘native’ MySQL SSL-encryption with direct MySQL connections.
    * MONyog now fully supports IPv6 (Internet Protocol Version 6).
    * History-trends have been optimized to retrieve data faster than it was before. With large data sets this results in a speed improvement in the range of a factor ~25 .
    * Passwords

      [Read more...]
    MySQL Monitoring on the cloud
    +2 Vote Up -0Vote Down


    Amazon Elastic Compute Cloud (Amazon EC2) is a web service that provides resizable compute capacity in the cloud. Amazon EC2 is known for its uptime, thereby making it the right candidate for running monitoring tools like MONyog. You cannot monitor something effectively, unless the monitoring system is available almost all the time.

    We are happy to introduce pre-configured Amazon Machine Image (AMI) which runs MONyog on an Amazon Linux instance of EC2. Launching this AMI would create an EC2 instance and starts the trial version of MONyog. In short, with just a click of a button you get your favorite MySQL monitoring tool on a trusted platform that is available almost all the time. MONyog can monitor MySQL servers running on Amazon RDS, Amazon EC2 or any other remote machine.

      [Read more...]
    Manage your MySQL & MariaDB databases - the simple way
    +1 Vote Up -0Vote Down

    New quick-start guide for MySQL DBAs: SkySQL™ Enterprise Monitor makes managing your MySQL & MariaDB databases that much easier

    We’ve just published a new Quick Start Guide to SkySQL™ Enterprise Monitor for all MySQL & MariaDB DBAs out there, who are looking for ways to manage their databases more easily.

    read more

    New MySQL & MariaDB Instructional Videos from SkySQL
    +3 Vote Up -0Vote Down

    Are you looking to expand your knowledge about MySQL and MariaDB database solutions?

    Well, you’re in luck! SkySQL is introducing an exclusive collection of educational videos featuring some of the industry’s leading experts on the MySQL database and related technologies. View informative, technical talks on a variety of topics, from the experts at SkySQL, MariaDB, Calpont InfiniDB, Continuent, ScaleDB, Severalnines, Sphinx, Webyog, and others.

    read more

    MONyog MySQL Monitor 5.2 Has Been Released
    +1 Vote Up -0Vote Down

    IMPORTANT note:
    * This release requires a new registration code. Neither the 5.1x nor the pre-5.1x key will work with this. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until MONyog is registered with new keys, it will not be collecting data from your servers .

    * Added filter for including or excluding specific hosts and(or) users in slow log analysis.
    * Added and modified a few Monitors related to Replication, InnoDB and Security. Most of this utilizes metrics exposed by MySQL from version 5.5 .
    * Added a preconfigured Custom SQL Object (CSO) for Percona Servers exposing the most written and most read tables.
    * There is now session-wide persistence while sorting columns in Query Analyzer.

      [Read more...]
    Temporary file behavior… (and how lsof save my life)
    +0 Vote Up -0Vote Down

    I would like to share this story based on a true event about the temporary files behavior in MySQL.

    MONyog reports this error to my already full mailbox several times a day :


    1 – Catch the query (if you can) !


    I don’t have access to the client logs but I would like to know which query is involved in this error.

    Let me explain how I can retrieve informations about this query with MONyog and a very simple shell loop :

    •  Enable the query sniffer in MONyog (based on processlist) : Edit server -> Advanced settings -> Sniffer settings

      [Read more...]
    MONyog MySQL Monitor with refreshing new looks!
    +2 Vote Up -0Vote Down


    We are delighted to announce the release of MONyog 5.0. This release is very special. This is not one of those bug fix / feature / functionality releases. This is about complete makeover for MONyog. Since the first release of MONyog, we have been continually adding features and fixing bugs. Less did we concentrate on looks and holistic usability. We kept on adding features with existing layout and put reorganizing logically connected elements to the back-burner. We thought it’s time to address these issues and took it up with MONyog 5.0.

    • The design is modern. Easy to say in a line, but took months to come up with new looks as the
      [Read more...]
    MONyog Custom Counters – overcoming a problem.
    +0 Vote Up -1Vote Down

    In this previous Blog I described an example on how to build a Custom Object in MONyog. But there is one problem you may encounter and that is, that when querying Information_Schema and Performance_Schema, it can sometimes be difficult or impossible to be sure to have a unique column (or a unique set of columns)  in the result set as neither of those generally guarantee uniqueness with a(ny) subset of columns. And a unique column (or a unique set of columns) is required for a MONyog Custom SQL Object.

    A common way to add a unique row-identifer to a result set is like this (note the use of  ”assignment operator” (“:=”) as different from “comparison operator” (“=”) ):

    SET @t = 0;
    SELECT @t:=@t+1

      [Read more...]
    Vote for MySQL[plus] awards 2011 !
    +5 Vote Up -0Vote Down

    First of all, I wish you a happy new year.
    Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
    I hope this enthusiasm will be increased this year, up to you !

    To start the year, I propose the MySQL[plus] Awards 2011
    It will only take 5 minutes to fill out these polls.
    Answer with your heart first and then with your experience with some of these tools or services.

    Polls will be closed January 31, so, vote now !
    For “other” answers, please,  let me a comment with details.

    Don’t hesitate to submit proposal for tools or services in the comments.

      [Read more...]
    How to add a simple Custom Object in MONyog
    +0 Vote Up -0Vote Down

    MySQL is developing rapidly.  And today it does not only happen along a single track but in multiple directions simultaneously.

    This is due to both server ‘forks‘ as well as various plugins and 3rd party storage engines available.   Each of those will often add  information that can be fetched from the server – typically in the form of additional Information_Schema tables. This content can now also be utilized for monitoring MySQL servers with MONyog. MONyog 4.8  implements monitoring based on Custom SQL Objects.  It is basically just a SQL query. Any query returning a result set can be used for monitoring.  MONyog will collect results from the query and you may define counters on it exactly as you want.

      [Read more...]
    Monitor your MySQL servers like never before – use CSOs!
    +10 Vote Up -0Vote Down

    We are delighted to announce the release of MONyog 4.8 GA. This release is all about customization – to be precise Custom SQL Objects (CSO) and Custom SQL Counters (CSC).

    The above diagram shows how Monitors & Advisors (MySQL Counters) are populated. MONyog has a repository of SQL Queries which are executed in regular interval of time & the results are stored in SQLite database of MONyog. These results are exposed as JavaScript objects and are referenced to populate Monitors and Advisors (MySQL Counters).

    With CSO, you can add your own SQL queries to this repository & customise counters based on that. Discussed below are

      [Read more...]
    Monitoring your monitoring tools (MONyog inside) !
    +6 Vote Up -1Vote Down

    Regardless of the monitoring tool you use to monitor your databases, it can be better to monitor this tool.
    No, it’s not a joke ! Do you think you can have a benefit with a monitoring tool not connected to your servers ? ( without being alerted )

    I choose to talk about MONyog here but this can apply to all existing monitoring tools.
    I just want to share the message, the tool does not matter, so, do it !

    So, let me explain how to control if you have fresh data with MONyog.
    With MONyog it’s easy because it’s an agentless monitoring tool.

    There are two ways to check that :

    Per server general info :


      [Read more...]
    Per-database information in performance_schema, please!
    +2 Vote Up -0Vote Down

    This is a follow-up om my first Blog on performance_schema that appeared here:

    One particular request that we had frequently from our users is to have status variables exposed per database and maybe even per table. Currently this is not possible. Not even with MySQL 5.6.3 with the P_S additions found there. I have frequently experienced that users get frustrated why ‘such a simple thing’ is not possible and I have the impression that they sometimes tend not to believe me!

    Examples: the (GLOBAL) status variables ‘slow_queries’, ‘com_update’ etc. has no database/table -level information. For those MySQL users that run a

      [Read more...]
    FLUSH STATUS surprise?
    +2 Vote Up -0Vote Down

    What does FLUSH STATUS do? We all know that it will simply reset all status variables (except for ‘uptime’) to same values as immediately after a server restart. Just google it and you will find that behaviour statet on hundreds of sites on the Internet.

    But NO – it is not true! Not anymore. MySQL documentation:

    “This option adds the current thread’s session status variable values to the global values and resets the session values to zero. It also resets the counters for key caches (default and named) to zero and sets Max_used_connections to the current number of open connections.”

    This bug report

      [Read more...]
    Performance_schema considerations.
    +1 Vote Up -0Vote Down

    I have for the first time been spending some time trying to understand the performance_schema. It is not easy to understand everything unless you are very well-versed in server internals (what I am not) and much information available here is probably more useful for server developers and testers than for ordinary users. But anyway some of the P_S tables are reasonable simple and useful. For instance the ‘accounts’ and ‘hosts’ tables (introduced in MySQL 5.6x) are immensely useful for everybody.

    The reason why I spent time with this now was (I am totally egoistic, of course) that we just released the first beta in a new MONyog release cycle where you may expose P_S contents for monitoring. Please refer

      [Read more...]
    Setting per-server thresholds in MONyog.
    +2 Vote Up -1Vote Down


    If you have been using MONyog you will know that any metrics/counters may be identified with either of the ‘states’ STABLE, WARNING and CRITICAL. For those metric where it is relevant MONyog ships with settings for this that are (to the extend possible) commonly agreed ‘best practices’ by MySQL DBA’s. Metrics in a WARNING or CRITICAL state display with a (yellow or red) ‘marker’ indicating that this metric is not in a STABLE state. For metrics in a CRITICAL state further an alert can be sent (as a mail alert and/or a SNMP trap).

    If the ‘best practices’ we have implemented in MONyog do not fit your environment or use case, it can easily be customized. Open the MONyog ‘Monitors/Advisor’ page, click on the name of the metric you want to adjust (it is a link). A

      [Read more...]
    iPad Ready Dashboard & Wayback Machine
    +0 Vote Up -0Vote Down

    We are pleased to announce the release of MONyog 4.7 GA. Below is a brief on new features:


    The world is moving towards tablets (I agree iPad in the title is a misnomer) and most of them don’t support Adobe Flash. As you know MONyog dashboard charts were on Flash and did not work on tablets. With this release we have switched to HTML5 charts. Not only do they work on all Smartphones and Tablets, they are faster than Flash charts. Hence, desktop users also gain from this release.

    Flash charts used elsewhere in MONyog are also changed to slick HTML5 charts.

    Embedded in this post are screen-shots with relevant section zoomed-in on an iPad.

      [Read more...]
    What are Hardware Requirements for MONyog?
    +1 Vote Up -1Vote Down

    We are often asked by users deploying MONyog what hardware system they should plan for it. Typically they have been evaluating and testing with a few MySQL servers only. Now after evaluation they are planning the deployment and  users that want to monitor a large number of (local/LAN-based, remote/hosted and Cloud-based) MySQL servers from a single dedicated MONyog machine will often ask us questions like

    * How many MySQL severs can be handled by a single MONyog instance?
    * How powerful should the CPU be? Any specific model(s) recommendation?
    * Is MONyog multithreaded and will it take advange of multi-core architectures?
    * How much memory is required?
    * Are there any requirements or recommendations for the storage system?
    * Will MONyog do better with advanced

      [Read more...]
    MONyog MySQL Monitor 4.6 Has Been Released
    +0 Vote Up -0Vote Down

    With this release we further enhance the ease of MONyog customization. This includes:

    * This release ships  with a bunch of useful Dashboard charts which can be enabled/disabled from the ‘manage dashboard charts’ in the Dashboard page. Users will not need to write any Javascript to enable those.
    *  Dashboard charts can now be reordered. User will be able to place those most important for him on top.
    *  Added an option to copy/duplicate advisors. This can be used as a template to make a new Monitor/Advisor.

    See the new interface for Dashboard configuration interface here:

    Further we added an option to

      [Read more...]
    MONyog MySQL Monitor 4.51 Has Been Released
    +0 Vote Up -0Vote Down

    Please note that when upgrading from a version previous to 4.5  to this one, it is required that MONyog detects the replication topology of registered servers before the ‘registered servers’ page can display. This may take a few minutes with a large number of registered servers. Please be patient for as long. Note that this delay will only happen once.

    Changes (as compared to 4.5) include:

    * This release focuses on improving performance of the MONyog built-in HTTP daemon. You will find up to 10 times performance improvements for most MONyog pages. This has been achieved by internal code optimizations, use of compression (if browser supports) and minification/optimization of HTML, Javascript, CSS and graphics.

    Bug fixes:
    * Prepared statements were not

      [Read more...]
    MONyog 4.5 GA – Events, Auto-register of slaves & much more…
    +1 Vote Up -0Vote Down


    We are delighted to announce the release of MONyog 4.5. Listed below are some noteworthy features:

    • You did get to know about what needs attention in Monitors/Advisors, but how about looking at all the alerts that need attention grouped on their severity for a certain period? This is what event is all about. An event occurs when the status of a counter changes. Keep your events tab open & you see MONyog alerting you – may it be “server availability” or “replication failure” or many other umpteen things that need attention.
    • Many a times, MONyog shows an alert to bring your attention, but you are OK with that & don’t want to fix it. Just close the event & it will appear only when it becomes alert-able again. This is a nice way to accept & dismiss events, so that you can
      [Read more...]
    Is your MySQL monitoring tool cloud ready?
    +13 Vote Up -1Vote Down

    Cloud, cloud, cloud. Cloud computing has become the phrase du jour, says one analyst from Gartner. But with many moving to cloud for its obvious benefits, it can no longer be ignored. An offshoot of cloud computing is utility computing. What interests us here is Database-as-a-Service, in particular MySQL on cloud.

    Coming back to our original question – Is your MySQL monitoring tool cloud ready? Well, many monitoring tools need agents on server to be monitored. For obvious reasons database-on-cloud vendors don’t allow one to install anything on the servers. With Amazon launching RDS (which is nothing but MySQL instance on cloud)

      [Read more...]
    Customization of monitors & advisors become more easy with the latest MONyog 4.1
    +0 Vote Up -1Vote Down

    The highlights of this release are:

    * A brand new helper function interface: We have implemented an easy-form based interface for customizing helper functions. Any customization of helper functions or user defined functions being used with earlier versions have to be migrated manually to this version. From this version and onwards a GUI-’conflict resolver’ will guide the users very similar to how it works for customized counters.

    * Apply settings to all servers of a specific tag: MONyog now has an option to apply a group of settings to all the servers with a specific tag. (Please note: New servers registered later with the same tag are not considered)

    * Enhanced readability of MONyog logs: MONyog logs from now on contain the server name

      [Read more...]
    Showing entries 1 to 30 of 66 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.