Search downloads:

MONyog MySQL Monitor and Advisor is a “MySQL DBA in a box” that helps MySQL DBAs manage more MySQL servers, tune their current MySQL servers and find and fix problems with their MySQL database applications before they can become serious problems.

MONyog MySQL Monitor and Advisor is a “MySQL DBA in a box” that helps MySQL DBAs manage more MySQL servers, tune their current MySQL servers and find and fix problems with their MySQL database applications before they can become serious problems.

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 (MONyog) side. The sniffer is useful when ‘real logs’ are not available, but also the sniffer has various filtering options what will sometimes make it more useful than the ‘real server logs’ also when they are available.

The log analysis component will (whether operating on a ‘real log’ or a ’sniffer pseudo log’) only display identical queries once but print a ‘count’ for every query. Important information (like execution time, number of instances for this query etc.) will be displayed in a sortable table view.

In the log analyzer ‘Filter settings’ (not to be confused the filter settings of the ‘query sniffer’) there further is an option to ‘replace literals’. The purpose of this option is to eliminate small differences between ‘almost identical’ queries. Currently ‘quoted strings’ and numbers are replaced with the dummy string ‘XXX’ only. We may extend this feature to support more (like special keywords and functions (like NULL, now()), operators etc.) in the next releases. It will depend on the demand for this as compared to the demand for other features. Also note that the current implementation has the ‘imperfection’ that also numbers that are not values (like the ‘1′ in identifiers like `column1`) will be replaced.

More Linux system counters added: Counters related to Linux memory (including swap) usage added.

RPM build now supports SuSE and Mandrake/Mandriva Linux distributions.

Bug fixes:

* Under specific circumstances the MONyog 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.
* Fixed an issue with trending where graphs would not always display properly for uptime-based counters.
* MONyog.ini file and MONyog database files on Linux are now only readable for user who starts/installs (.gz and RPM build respectively) Monyog (and of course for any user too that was given access by a root user). Before the files were world-readable. This applies to fresh installations only - there is no change with existing installations.
* Solved an issue where slow startup could occur if lots of servers were registered (Technical: If MONyog had not been running for a while, large amounts of data could require deletion from the MONyog database. The queries used to identify those data would generate significant I/O at startup. The retention process is now ’smoothed over time’ and indexes have been added for more efficient deletions).

Important fixes are:
* Optimized SFTP code. Log Analyzer is now several times faster than what previous Betas were.
* A log file parsing issue with MySQL 5.1.x was resolved.
* Fixed an issue that could occur if some queries in log had binary data. A gibberish error message was displayed.

Company: Webyog Softworks Private Limited

Related downloads

	MySQL Copy Tables to Another MySQL Database Software 7.0 Copy tables from one MySQL server to another.		209
	MySQL Backup to Another MySQL Database Software 7.0 Backup data from one MySQL database.		624
	MySQL Move to Another MySQL Database Software 7.0 Transfer tables between MySQL servers.		510
	MONyog MySQL Monitor 3.16 MONyog is "MySQL DBA in a box"		137
	MySQL GUI + Access MySQL conversion version 7.2.7 7.2.7 Navicat (MySQL GUI - supports Access to MySQL)		1631
	PHP MySQL Wizard ( php Code Generator for Mysql) 1.3 PHP scripts generator for mysql		2625
	MySQL GUI Navicat MySQL Manager 8.0.27 Navicat - the leading MySQL GUI Admin Tool		501
	Convert MS SQL Database to MySQL 2.0.1.5 Download MSSQL to MySQL db converter software		35
	MySQL Database Converter 2.0.1.5 Download MySQL database converter software		27
	Migrate MYSQL Database to MS SQL 2.0.1.5 Migration tool for MYSQL to MS SQL database		102

Related press releases

Webyog releases MONyog Monitoring and Advisory Tool for MySQL Community Server [2007-08-17 13:48:47]
Bangalore, India ( Download3k ) - August 3, 2007: Webyog (www.webyog.com), a leading provider of database management and monitoring tools for popular open source databases, today announces the release...

MONyog MySQL Monitor and Advisor is a “MySQL DBA in a box” that helps MySQL ... [2008-09-12 07:27:27]
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...

Navicat for MySQL (Mac OS X) version 7.1.7 is released [2009-01-07 02:45:45]
Navicat for MySQL (Mac OS X) version 7.1.7 is released PremiumSoft CyberTech Limited today released Navicat for MySQL (Mac OS X) version 7.1.7. Navicat for MySQL is a graphical tool for managing,...

Navicat MySQL GUI for Linux version 8.0.28 is released. [2008-09-19 01:38:57]
By Premiumsoft. Navicat MySQL GUI Manager is a powerful yet easy to use MySQL client provides extensive functionality for managing and developing MySQL. It features an intuitive interface and provides...

Navicat MySQL GUI for Mac OS X version 7.1.6 is released. [2008-10-13 01:51:51]
The latest version is compatible with Mac OS X Leopard! Navicat MySQL GUI is a graphical tool for managing, monitoring, and developing your MySQL database. This new version supports Excel Import, V...

Access-to-MySQL v3.5 by Intelligent Converters [2005-12-25 00:00:00]
Access-to-MySQL is one of the oldest tools to migrate Microsoft Access databases to MySQL server. First version of the product has been released by Intelligent Converters in 2001. Since then we have i...

Navicat for MySQL (Windows) Version 8.1.15 is released [2009-05-12 01:27:07]
PremiumSoft today announces the release of Navicat for MySQL (Windows) Version 8.1.15. Navicat for MySQL is a graphical tool for managing, monitoring, and developing your MySQL database. The new re...

DreamCoder for MySQL Freeware ver 5.0 available for download [2009-10-05 08:25:49]
Mentat Technologies is happy to announce the new version of DreamCoder for MySQL version 5.0, a powerful database tool for MySQL administration and database development. This new version includes ...

Devart Team is glad to present updated versions of dbForge Fusion for MySQL and ... [2009-11-03 07:01:10]
Devart Team is glad to present updated versions of dbForge Fusion for MySQL and OraDeveloper Tools with support of RAD Studio 2010. Having its finger on the pulse, Devart Team offers the users free...

Navicat for MySQL v.8.0.28 is now available! [2008-09-19 01:38:09]
PremiumSoft CyberTech Limited today announced the immediate availability of Navicat for MySQL v.8.0.28. This new version supports MySQL 5.1 new feature Scheduled Event, enabling users to set a schedul...

CyberSieve

Protect your kids from harmful information on the Internet and monitor them irrespective of where you are.

AI Robot

AI Robot helps you automate mouse movement, mouse click and keyboard key presses. So you just need to tell AI Robot what to do step by step, then AI Robot will run all these steps automatically, and repetitively.

VNC Scan Enterprise Console

VNCScan allows you to remotely manage your workstations and servers. With VNCScan, you can: * Scan for and deploy VNC Remote Control on your network * Manage unlimited computers * Terminal Servers AND VNC

WinQuota Professional

WinQuota is a disk quota management solution for Windows designed for regular usage on any types of servers, especially on servers with large amount of files, such as file servers, news and mail servers.

CRM-Express Professional

CRM Software - CRM-Express Professional is the latest in CRM (Customer Relationship Management) software. CRM-Express can manage your marketing, customers, sales and orders. Features include SMS abilities, Email Client, Calendar, Address Book

Cute Reminder Standard Edition

Create non-annoying reminders and manage desktop notes with just one or two mouse clicks. The program supports schedule, history, skins, audio files (mp3, wma), printing and more. Elaborate nice interface provides comfort at your workplace.

Weather Clock

Get things done and don't forget your umbrella using this customizable clock with exact time, alarms, current weather conditions, forecasts and different skins.