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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 66 Next 6 Older Entries

Displaying posts with tag: MONyog (reset)

MONyog 4.0 introduces MySQL configuration tracking, improved customization and better stability
+0 Vote Up -1Vote Down

Hi,

We are delighted to unveil MONyog 4.0 — a major new release. Listed below are overviews of some of the major features.

Tracking changes to your MySQL configuration

Maintaining server configuration and tracking changes to it plays a vital role in the maintenance of MySQL servers. DBAs may be responsible for hundreds of servers and keeping an eye on the configuration settings for all of them could be difficult to say the least. With MONyog 4.0 now you can compare global MySQL configuration of multiple servers side-by-side, with all changes highlighted so that differences are visually discernible at a glance. Wondering why server A isn’t performing as well as server B when they share the exact same load? The answer could lie in the configuration files!

What’s more is that

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

Important note: Please note that if you have installed a MONyog 4.0 (beta) release you cannot install this one unless first completely removing the 4.0 installation including the complete MONyog data folder.

Changes (as compared to 3.77) include:

Bug Fixes:
* Monitors/Advisors on InnoDB Deadlocks were truncating the output message and hence in some cases, users were unable to view both queries involved in the deadlock. This has been changed such that the first 2048 characters of both queries are displayed.
* On Windows 7 systems changes to MONyog’s .INI file from external programs had no effect upon restart (as Windows reverted the changes). Now throughout MONyog’s lifetime the .INI file will be locked so that a user may only edit the file manually when MONyog is not running (but

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

Changes (as compared to 3.73) include the bug fixes:

* Log analysis could use high CPU if the option to replace literals with a placeholder was not selected and the literal string ‘ “‘ (space + doublequote) occured in the log file.
* CSV-export from Query Analyzer only exported 200 rows (the same number as displayed in the browser view). Now CSV-export will export all rows. Also the UI makes it now clear that the browser displays the 200 uppermost rows according to current sort criteria.
* An error message regarding an integer overflow could occur in Monitor/Advisors page for some values. The SQLite datatype used could be too short for some specific data.
* Login to MONyog could fail if MONyog was running behind a proxy.

Downloads:




  [Read more...]
My Impressions About MONyog
+2 Vote Up -1Vote Down
At work we have been looking for tools to monitor MySQL and at the same time provide as much diagnosis information as possible upfront when an alarm is triggered. After looking around at different options, I decided to test MONyog from Webyog, the makers of the better known SQLyog. Before we go on, the customary disclaimer: This review reflects my own opinion and in no way represents any decision that my current employer may or may not make in regards of this product.

First Impression

You know what they say about the first impression, and in this where MONyog started with the right foot. Since it is an agent-less system, it only requires to install the RPM or untar the tarball in the server where you're going to run the monitor and launch the daemon to get started. How much faster or simpler can it be? But
  [Read more...]
MONyog MySQL Monitor 3.73 Has Been Released
+0 Vote Up -0Vote Down

Changes (as compared to 3.72) include:

* If SHOW ENGINE INNODB STATUS returned an error that was not privilege-related, MONyog reported MySQL as non-available.  That could happen for instance if MySQL was started with –skip-innodb option. This bug was introduced in 3.71 with the support for InnoDB deadlock detection.
* A bug in the MONyog startup script could on Linux have the result that MONyog was still reported as running if it had been killed or had crashed.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

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

Changes (as compared to 3.71) include:

Features:
* The number of builds for Linux has been increased to the double number of what it was before.  In addition to the builds based on glibc version 2.3 we now distribute builds based on glibc 2.5.  Also we add builds for use with even older glibc 2.3 based Linux that what we had before. There are now builds based on both glibc-2.3.2  and 2.3.4 (the one based on 2.3.4 is the one we had before). We had a few  reports of random crashes (typically occurring up to a few times per week) occurring on recent 64 bit CentOS servers and in one case also a RHEL5.  The glibc 2.5-based build fixes this. Although we only had such reports on 64 bit Linux of  ‘Red Hat Family’ we also included 64 bit tar.gz for all Linux platforms and 32 bit RPM builds.  The general

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

Changes (as compared to 3.7) include:

Features:
* Added a monitor for InnoDB deadlocks (as exposed by SHOW ENGINE INNODB STATUS -statement).
* In case of a program crash on Linux, MONyog will save a core dump like the Windows version already does.  The dump is saved in ../MONyog/bin folder.

Bug Fixes:
* EXPLAIN from Processlist page could fail with syntax error due to a missing SPACE character in the statement.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

MariaDB 5.1.42 released!
+8 Vote Up -9Vote Down

Dear MariaDB users,

MariaDB 5.1.42, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. We are very proud to have made our first final release, and we encourage you to test it out and use it on your systems.

For an overview of what’s new in MariaDB 5.1.42, please check out the release notes.

For information on installing MariaDB 5.1.42 on new servers or upgrading to MariaDB 5.1.42 from previous releases, please check out the installation guide.

MariaDB is available in source and binary form for a variety of platforms and is available from the

  [Read more...]
MONyog MySQL Monitor 3.7 introduces multi-user authentication and licensing changes.
+2 Vote Up -0Vote Down

MONyog MySQL Monitor 3.7  Has Been Released.

From MONyog 3.7 we have introduced 3 editions of the commercial version of MONyog. When we had first released MONyog 2 years back, it was already an almost complete tool for monitoring MySQL servers based on what the MySQL server exposes on SHOW statements.  Since then we have added features that are not basic server monitoring features in the strict sense but additional or supplementing features.  Most important the Query Analyzer was added around one year ago.

Multi-user authentication is a long standing request from customers belonging to large organizations – or just having the need for monitoring lots of MySQL servers. There may be multiple server administrators. There may be development/test servers that the developers of that

  [Read more...]
MONyog MySQL Monitor download count crosses 100,000
+0 Vote Up -2Vote Down

Happy new year!

Just before Christmas the number of downloads of MONyog (from distinct email addresses) crossed 100,000. Here is the situation as of now:

This is of course a nice Christmas present for us to have. But more important: it reflects that today – as opposite to the situation just a few years ago – that even average MySQL users have understood that tuning the server configuration as well as the schemas and the queries used by applications is essential.

The default settings for the MySQL server are not appropriate for a heavy-loaded server and even the standard configuration files (or configuration ‘templates’) shipped with the server will not have the specific settings required for optimal configuration in

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

Changes (as compared to 3.62) include:

Features:
* You can now specify a comma-separated list of users to be ignored/excluded by notify and/or kill actions for long-running queries in ’query sniffer’ interface.
* Added a ‘diagnostic info’ icon to servers in ‘list of servers’ page. Clicking this will generate a report in plain text with the most basic information about the server.
* Added an option to stop/start data collection for a server in ‘list of servers’ page (without opening the detailed pages for this server).
* Enabling/disabling data collection from and/or alerting about all servers can be done from tools .. preferences .. maintenance.
* Enabling/disabling data collection from and/or alerting about specific servers can be done by calling the MONyog URL with parameters.




  [Read more...]
MONyog 3.6 introduces real-time query monitoring and sniping, better server management, improved alerting and major new features
+1 Vote Up -0Vote Down

Hi,

We are pleased to announce MONyog 3.6 – a major new release. Listed below are the major features included in this release.

Real-time query monitoring and sniping

MONyog provides a whole bunch of tools for finding problem SQL (Slow Query Log, SHOW PROCESSLIST snapshots, MySQL Proxy, etc). These tools are great if you want to find problem SQL in an application and tune those queries. However, using these tools to find problem is almost always a post-mortem exercise. In certain situations you may want real-time notifications for long running queries. MONyog 3.6 gives you exactly that. MONyog can continuosly monitor queries in real-time and send notifications (on Mail or SNMP) for queries that take more than a specified amount of time to execute.

  [Read more...]
Monitoring MySQL with MONyog
+1 Vote Up -0Vote Down

It just works. In absence of any MySQL monitoring for your site, I have found no solution that gets you operational as quickly and easily. MONyog can be deployed in 60 seconds, and configured in another 60 seconds. Within 5 minutes you can have visual monitoring of your MySQL environment.

MONyog is an agentless process, which is an advantage for easy install, but does not provide for monitoring redundancy in the capture of information due to agentless nature. It’s a static standalone executable which is great if you need something to work out of the box. You can easily configure multiple servers in a replication topology, or different servers in your environment. You get the ability to monitor all the usual information, with a dashboard and detailed graphs. While MONyog does provide customizations of rules for the graphs and

  [Read more...]
Monitoring MySQL Product Options
+0 Vote Up -0Vote Down

I’ve had plenty of comments on specific products to Monitoring MySQL Options before providing the completed list. Here are the results from my survey to give everybody a more complete list.

Nagios 25 xxxxxxxxxxxxxxxxxxxxxxxxx MONyog 8 xxxxxxxx Cacti 4 xxxx Munin 3 xxx MySQL Enterprise Monitor/Merlin 3 xxx   [Read more...]
Monitoring MySQL options
+3 Vote Up -0Vote Down

My recent poll What alert monitoring do you use? showed 25% of the 58 respondents to bravely state they had no MySQL monitoring. I see 1 in 3, ~33% in my consulting so this is consistent.


There is no excuse to not have some MySQL Monitoring on your production system. At the worse case, you should be logging important MySQL information for later analysis. I use my own Logging and Analyzing scripts on every client for an immediate assessment regardless of what’s available. I combine that with my modified statpack to give me immediate text based analysis,

  [Read more...]
MONyog 3.5 introduces Error Log Monitoring, SNMP traps, new advisors and UI enhancements
+3 Vote Up -0Vote Down

Hi,

We are pleased to announce MONyog 3.5 – a major new release. Listed below are the major features included in this release.

Error Log Monitoring

Monitoring the MySQL error log is absolutely critical for any MySQL DBA. Ignore the error log at your own peril! Many of our customers wanted an out-of-the-box solution for monitoring the error log. With the latest release, MONyog becomes the first MySQL Monitoring Tool to monitor the MySQL Error logs. MONyog can optionally send notifications over SMTP or SNMP for MySQL error log events that require attention.

As usual, none of the features of MONyog require you to install agents or additional software on hosts running MySQL.

  [Read more...]
MONyog 3.12 Has Been Released
+0 Vote Up -0Vote Down

Important note when upgrading from versions before 3.1:
* MONyog now requires a registration code.
* Do not forget to replace the MONyog.lua script if you use the Query Analyzer with proxy-based sniffing.
* RPM users must uninstall pre-3.1 versions before installing this one.
Please read 3.1 release notes for details.

Changes as compared to 3.11 include:

Features:
* All charts displayed by MONyog can now be exported as PDF/JPG/PNG (from chart context menu).
* Query Analyzer will now sort in descending order as default first time (before it was ascending).

Bug fixes:
* Validation of connection details was not proper when saving.
* In Query Analyzer options that do not







  [Read more...]
Interview with Rohit Nadhani, founder of Webyog
+2 Vote Up -3Vote Down

At the MySQL Conference, I had the chance to interview Rohit Nadhani, founder of Webyog, the folk that make SQLyog and MONyog. Watch the video, for more.



Generally based out of Bangalore (I visited them when I was last there), Webyog just started an office in Santa Clara, and are expanding. They boast 15,000 paid customers so far, with some big name customers: Google, Yahoo!, executive office to the US president, and more.

SQLyog is termed as an upgrade from phpMyAdmin. There is a GPL community edition, with some “power tools” that is part of the Enterprise Edition. It is very Win32 based, but easy enough to run on other OSes via WINE or some sort of



  [Read more...]
MySQL Conf. 2009 special – Get 20% discount on all products, MONyog 3.06 released!
+0 Vote Up -0Vote Down

Hi,

We will be present at MySQL Conference & Expo, 2009. If you are around Silicon Valley, don’t forget to meet the team behind your favorite MySQL tools at Booth #317. We are happy to offer a flat 20% discount on all purchases made during this month. Use the coupon code: uc2009 during the purchase.

Also, we are pleased to announce the release of MONyog 3.06.

Changes (as compared to 3.05) include:

Bug fixes:
* Installation on Windows could fail with a js32.dll-related error. Waiting a few seconds and ‘retry’ would solve this but now the error does not come.
* Fixed a ‘false alert’ related to settings for temporary tables (the error occurred because of comparing an integer with a non-integer).



  [Read more...]
MONyog 3.0 Query Analyzer introduces MySQL Proxy Support and completely new Advisors by Percona
+0 Vote Up -0Vote Down

Hi,

We are pleased to announce MONyog 3.0 - a major new release. MONyog is rapidly becoming a cost-effective alternative to expensive proprietary tools for MySQL monitoring.

Unlike databases like SQL Server & Oracle, MySQL does not provide powerful APIs to gather extensive profiling information about each and every query. MySQL developers and DBAs have largely used on a combination of the following techniques to find problem SQL:

  • SHOW PROCESSLIST
  • Slow Query Log and General Query Log
  • SHOW PROFILES (available from MySQL Community version 5.0.37)
  • Capturing and filtering tcpdump output
  • To overcome the shortcomings of profiling features in the MySQL server, MySQL Proxy was introduced which allows developers to route queries via MySQL Proxy and then extract

      [Read more...]
    MONyog 3.0 beta 1 Has Been Released
    +0 Vote Up -0Vote Down

    Features:
    * The ‘query sniffer’ can now connect to and retrieve data from a running instance of the MySQL-proxy program used by one or more clients to connect to MySQL.  A LUA script for controlling the proxy for use with MONyog is provided with this build.  With this sniffer option the SHOW FULL PROCESSLIST statement will not be sent and thus use of ‘query sniffer’ will not put any load on MySQL.
    * SSH connections will now attempt more authentication methods in case the first method attempted failed.  This will solve problems reported with tunneling to MySQL on FreeBSD that as per default does not support the full range of SSH authentication methods (and possible similar problems).

    Downloads: http://webyog.com/en/downloads.php



      [Read more...]
    MONyog 2.9 Has Been released
    +0 Vote Up -0Vote Down

    Changes (as compared to 2.83) includes:

    Features:

    * This release adds a ‘base time’ setting in MONyog. This setting (if defined by user) will be used for calculation of uptime-based counters. The reason for this implementation is that if FLUSH STATUS is executed with a MySQL server, specific server status variables will be reset to the same value as would be after a server restart. However the ‘uptime’ status variable itself is not affected by FLUSH STATUS. And as uptime-based counters will relate the value of cumultive status variables with some intial time, using the ‘uptime’ variable as the initial time will result in calculation of misleading values if FLUSH STATUS was executed. So to get true uptime-based counters in MONyog with servers that do not support the

      [Read more...]
    MONyog 2.8 Has Been Released
    +0 Vote Up -0Vote Down
    Dashboard view of the Top 5 tables being used by this blog. Current release of MONyog shows the disk usage even at table level.

    Changes (as compared to 2.72) include:

    Features:
    * Added new monitoring module displaying disk usage information for databases and tables.
    * Display of slow log data in Log Analyser had added more information (about when query occured, information about number of rows examined and sent)

    Bug fixes:
    * When a multibyte character was used in a connection name the display would garble and also the connection could not be deleted from GUI.
    * When connection was not available the caption for counters should display “n/a”. Since 2.71 it would instead display a string exposing an



      [Read more...]
    MONyog 2.7 Has Been Released
    +0 Vote Up -0Vote Down

    Features:
    * CPU optimisations in both MONyog (server) process (in particular when ‘Monitors/Advisors’ page was being viewed) and browser processes (viewing Dashboard could cause high CPU usage in Firefox browser in particular).

    Bug fix:
    * Fixed a dependency with the SSH library that could cause failure to install in Win2K. This was an issue with the updated SSH library introduced with version 2.5.

    Miscellaneous:
    * The RPM installer scripts for Linux were updated in various ways. This solves issues on specific distributions including: 1) uninstall with the SuSE/YaST ’software management’ GUI was not possisble. 2) It was not always possible to install on top of a running MONyog service - sometimes it was necessary to stop service manually before



      [Read more...]
    MONyog 2.6 Has Been Released
    +0 Vote Up -0Vote Down

    Changes (as compared to 2.51) include:

    Features:
    * Log Analyzer code has been completely refactored resulting in better performance and stability and more maintainable code.
    * The progress indicator for downloads in Log Analyzer page is now a true quantitative progress bar.
    * Error messages in Log Analyzer were rewritten. Every single possible error is now differentiated by a specific message providing help for the situation.

    Bug fixes:
    * “Group by” option in history/trends page could deliver incorrect results if MySQL and MONyog were using different timezones.
    * With SFTP connection to the log file selecting “ALL” for log size to be downloaded in Log Analyzer page could have the result that the log file download would last forever.
    * Analyzing log chunks containing BULK





      [Read more...]
    MONyog 2.5 has been released
    +0 Vote Up -0Vote Down

    We are pleased to announce that we are now able to release MONyog 2.5 FINAL.

    First: for the overall concepts and considerations with this release please refer to this BLOG post (from the release of first beta).

    Details for this release (as compared to version 2.06) are:

    Features:

    MySQL Server Log Analysis: MONyog is now able to retrieve (completely or partially) the General Query Log and the Slow Query Log (whether stored as files or tables on the server) from the MySQL servers it connects to and analyze them.

    Query Sniffer: A ‘query sniffer’ is implemented that will record a ‘pseudo log’ on the client

      [Read more...]
    Independent MONyog review by Sheeri Cabral of The Pythian Group
    +0 Vote Up -0Vote Down

    Sheeri Cabral, an active MySQL blogger and two-time winner of MySQL Community Contributor awards has written a great review on MONyog.

    Read the full review here

    Our favorite highlights:

    As an overall review — MONyog is the best out-of-the-box GUI monitoring tool for MySQL that I have seen. It “just works.” As promised, getting up and running quickly is easy, and having a centralized location for monitoring is very useful. The graphs are beautiful and the statistics that are graphed are useful time-savers.

    The biggest difference between MySQL’s Enterprise Monitor and MONyog is that MONyog is agentless. At Pythian, we have many clients with differing security requirements. Requiring a daemon process to be running is not something

      [Read more...]
    MONyog 2.5 RC has been released
    +0 Vote Up -0Vote Down

    Bug fixes and Enhancements:

    • Optimized SFTP code. This means that the Log Analyzer is now several times faster than previous Betas
    • Fixed an issue with trending
    • Log file parsing issue with MySQL 5.1.x resolved

    Downloads: http://webyog.com/en/downloads.php
    Purchase: http://webyog.com/en/buy.php

    Reviewing MONyog
    +0 Vote Up -0Vote Down

    I was contacted by the folks at MONyog and asked if I would review MONyog. Since using MONyog is something I have been wanting to do for a while, I jumped at the chance. Of course, “jumped” is relative; Rohit asked me at the MySQL User Conference back in April, and here it is two months later, in June. My apologies to folks for being slow.

    This review is an overall review of MONyog as well as specifically reviewing the newest features released in the recent beta (Version 2.5 Beta 2). Feature requests are easily delineated with (feature request). This review is quite long, feel free to bookmark it and read it at your leisure. If you have comments please add them, even if it takes a while for you to read this entire article.

    While the webyog website gives some information about what MONyog can do, it is a

      [Read more...]
    MONyog 2.5 beta 2 has been released
    +0 Vote Up -0Vote Down

    MONyog 2.5 beta 2 has been released.

    Bug fixes:

    * Under specific circumstances the service would stop very slow.
    * If network connection was temporarily unavailable the first CPU value after network came back told 100% CPU load.
    * The temporary files for storing public/private keys are now being created with very restrictive file permission in Linux. So only the owner will be able to read/write these temporary files. Although these files would exist only for a fraction of second, in earlier versions of MONyog other users in the same Linux system could get access to them within that small timeslice.

    Downloads: http://webyog.com/en/downloads.php
    Purchase: http://webyog.com/en/buy.php

    Previous 30 Newer Entries Showing entries 31 to 60 of 66 Next 6 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.