Sql mon yog

Solo disponible en BuenasTareas
  • Páginas : 8 (1784 palabras )
  • Descarga(s) : 0
  • Publicado : 8 de noviembre de 2011
Leer documento completo
Vista previa del texto
What is MONyog - MySQL Monitor and Advisor?
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 or costly outages. MONyog pro-actively monitors enterprise database environments and providesexpert advice on how even those new to MySQL can tighten security, optimize performance and reduce downtime of their MySQL powered systems.

Get information before the server runs out of resources.
As a MONyog user you will know in advance if server resources will soon be running short. You can plan a hardware replacement or upgrade in comfortable time and not when it is almost too late (or justplain too late!). And the metrics about the server that MONyog gives you will help to decide what to upgrade: Faster CPU, More RAM, Faster disc systems - or maybe only remove another program from the computer where the MySQL server is running.

Identify the SQL statements that run slow.
MONyog provides a log analysis module, a 'query sniffer' and a 'processlist watcher' that makes it easy toidentify the statements and applications that run slow on the server. This includes various filtering and EXPLAIN options for an efficient workflow when you want to optimize your applications.

Monitor the MySQL Error log.
Monitoring the MySQL error log is absolutely critical for any MySQL DBA. Ignore the error log at your own peril! MONyog is the first MySQL Monitoring Tool to monitor the MySQLError logs and can optionally notify you of changes to it.

Monitor queries in real-time and snipe long running queries.
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 1

SQL in an application and tune those queries. However, using these tools to find problem isalmost always a post-mortem exercise. In certain situations you may want real-time notifications for long running queries; MONyog gives you exactly that. MONyog can continuosly monitor queries in real-time and send notifications for queries that take more than a specified amount of time to execute. You can also specify an option to kill such queries.

Get alerts for what you want and when you want.MONyog can send you alerts over mail or SNMP. Stay on top of significant events and avoid many sleepless nights!-

Monitoring servers
Monitoring servers allows network administrators to keep a check on their networks so that they can stop or eliminate problems before they occur. Easily configure the monitoring software to instantly notify you when critical servers go down, a user alters theirconfiguration, disk space reaches a certain level, or a possible security threat is detected. It helps organizations to monitor critical network resources, and to detect system failures or performance problems immediately, thus minimizing downtimes and their economic impact. Key features of MONyog's monitoring and advisory tool are:

 Processlist
The Processlist page shows you the number ofthreads currently being executed by MySQL. Each query sent to MySQL is executed in a thread. The Processlist feature should be used to check which queries are being executed presently. It just gives you a general sense of what is keeping your server busy at that very moment. However, this feature is not the right tool to review statistical information about the queries executed on the MySQL serverover a period of time. For finding problem SQL, for example, you should use the Query Analyzer which takes a snapshot of queries, their execution times, etc. over a period of time and presents you with a consolidated report. You can then use the report for further analysis; you can even export it as CSV and run it through other tools! The view can be filtered and sorted as described subsequently....