If you would like to republish articles from this web site you’re free to do so, taking articles part or full articles under the following conditions:
- If you republish article on the web you need to provide direct link to original article on this site. You want to do that anyway as this way your visitors get more information via comments.
- Information about author and original source should be retained.
- You need to provide access to article content free of charge.
We also would apreciate if you let us know where did you republish articles.
If you need to republish articles on other conditions please contact us.
Note: Articles on this web site are published as blog entries without much of language editing etc. If you would like to get more detailed article on some topic please let us know.
P.S Perhaps we should take a look at some standard license which matches our needs.
12 Comments
Hi.
Little question, can I translate your posts to Russian and publish it in my own blog? It must be very useful for russian mysql community I think.
Comment :: June 9, 2006 @ 5:50 am
Sure,
Just make sure you give us a credit by placing link back in your article.
You even could send us Russian version for proofreading
Comment :: June 9, 2006 @ 5:57 am
heh. Little bugreport. Did you see date of your comment?
Comment :: June 9, 2006 @ 25:57 am
Are you sure what it’s right?
Comment :: June 9, 2006 @ 4:20 pm
It should now be fixed, is not it. Seems to be broken Wordpress theme.
Comment :: June 19, 2006 @ 6:22 am
Hi Peter
Can I translate your posts to Chinese and publish it in my own blog(http://imysql.cn)? It must be very useful for Chinese mysql community I think.I had added your site to my links.
Comment :: August 15, 2006 @ 8:31 pm
Thank you yejr,
Make sure provide links from each article to appropriate original version in English. This will be helpful to check comments etc.
Comment :: August 16, 2006 @ 1:06 am
I do
Comment :: August 16, 2006 @ 3:00 am
Peter,
The Innodb memory blog posting you have done over the last week or so have been great. I would love to re-work them a bit and publish them in the Winter issue of the MySQL Magazine (www.mysqlezine.net). I love everything you guys do, but this has been exceptional and I think any MySQL admin would benefit from reading it.
Please shoot me an email if this will work for you.
thanks,
Keith
Comment :: November 3, 2007 @ 7:58 pm
>P.S Perhaps we should take a look at some standard license which matches our needs.
You can check here:
http://creativecommons.org/licenses/
Comment :: December 5, 2007 @ 10:42 am
Thanks Gints. Will check.
Comment :: December 9, 2007 @ 10:56 am
Hi, I’ve translated this article into Dutch.
We will use it for our online Dutch Code community named CodeQuest.nl
It’s situated in the Netherlands. We’re a community thats intrested in MySQL and other ’skills’.
I personally expected that COUNT(col) should be faster that COUNT(*) in the first place. Nice to read that I whas wrong about that actually. Learning every day
The article can be found at: http://codequest.nl/article/count_ster_vs_count_kolomnaam
Thanks again!
Comment :: February 26, 2008 @ 8:04 am
The MySQL database is rapidly becoming the de-facto choice for traditional enterprises as well as pioneering Web 2.0 companies. Webyog has been consistently delivering powerful tools exclusively on the MySQL platform for the last 5 years. While the adoption rate of MySQL continues to grow in momentum, it poses some unique challenges for traditional DBAs and the companies they work for. Some of these challenges are:
* Analyzing MySQL performance data collected over a period of time
* Ensuring availability of critical MySQL systems
* Keeping the systems well tuned
* Getting proactive alerts before problems start surfacing
* Indentifying problems quickly
* Monitoring server health continuously
* Profiling queries
* Protecting critical Systems
To help DBAs meet these challenges, Webyog has created MONyog - MySQL Monitor and Advisor. Whether they are working for large companies who have deployed hundreds of MySQL servers; or for small businesses with only a handful of MySQL servers, MONyog is designed to scale DBA resources by providing a unified, informed view into the health, security, performance and availability of the entire MySQL server environment. This paper explores MONyog MySQL Monitor and Advisor in detail and explains how it can be leveraged as a “MySQL DBA in a Box”.
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 proactively monitors enterprise database environments and provides expert advice on how even those new to MySQL can tighten security, optimize performance and reduce downtime of their MySQL powered systems.
Agent-less monitoring
Answer this: How does your DBA feel before installing a new component on your production servers?
a) Scared
b) Disgusted
c) Oh no. Not again!
d) Are you joking?
e) All of the above!
Unlike other Monitoring and Advisory Tools, MONyog does not force you to install “monitoring agents” on each of your MySQL hosts. Installing and maintaining monitoring agents can be a complex administration task by itself. MONyog uses a normal MySQL connection for monitoring MySQL. To collect OS data from remote servers, MONyog use SSH for Linux and WMI for Windows. This means MONyog can collect all monitoring data by using remote connections. This is a huge advantage that sets MONyog apart from all other MySQL monitoring and advisory tools. Of course, MONyog supports SSH tunneling!
MONyog is customizable
Each of the MONyog Advisor rules allows the MySQL DBA to customize the thresholds that are acceptable for specific MySQL servers. As an example, a DBA using the supplied Advisor Rule “MySQL Key Cache has Sub-Optimal Hit Ratio” may use lower threshold values for their MySQL servers running OLTP applications, while higher thresholds may be acceptable for OLAP applications. The entire application logic of MONyog is coded as JavaScript Objects that are parsed and executed by the MONyog’s embedded Javascript Runtime. These JavaScript Objects are available with MONyog in source form. This means that you can add new advisors, modify existing advisors or simply remove some of the predefined advisors supplied by Webyog. In fact, you can delete all predefined advisors supplied by Webyog and roll out your MySQL Monitoring and Advisory Tool!
View and understand trends by analyzing historical data
You decide yourself for how long data collected by MONyog will be stored. They are stored in a high-performance database. By analyzing historical data, you can quickly get answers to questions like:
* How many times and when MySQL went down in the last 6 months?
* Which day of the week has maximum MySQL activity?
* How many login attempts with wrong passwords were made yesterday? What was the time when those attempts were being made?
Sudden changes in performance parameters and problems (due to change of application etc.) will also be very visible immediately. MONyog Trend analyzer displays that, in this particular case the MySQL server load is high between 14 hours and 15 hours everyday.
The unique architecture and low-footprint of MONyog enables DBAs to install and configure all components required for monitoring MySQL servers in less than 1 minute. This is in sharp contrast with other Monitoring and Advisory Tools that force you to install agents, web-servers, multiple language runtimes, etc before DBAs can even start monitoring MySQL servers.
One of the biggest challenges the MySQL DBA faces is managing an ever-growing number of MySQL servers and databases. Regardless of the size of the MySQL environment, each server requires specific attention when it comes to basic administration, security, performance monitoring and availability. To give the MySQL DBA a proactive advantage in all of these areas, MONyog provides the dashboard. Using the dashboard, DBAs can monitor MySQL and OS specific metrics for single or groups of servers. The dashboard is designed so DBAs can easily understand the complete security, availability, and performance picture of all their MySQL servers in one place, all from a slick AJAX interface. Unlike other monitoring tools that use annoying page-refreshes for real time charting, MONyog uses Flash/Silverlight charts to make sure that you get “true” real time charts.
The MONyog Enterprise Dashboard shows real time charts of all important metrics that provides a consolidated view into the availability and performance of all of the MySQL servers across the enterprise. From these real-time charts the MySQL DBA can instantly tell:
* The availability status of all MySQL servers
* Important OS metrics that may be affecting MySQL
* Which MySQL servers need attention and
* Where and how they need to spend their limited time
MONyog Advisor Rules
The MONyog Advisor Rules are a set of best practices that allow DBAs to implement new MySQL servers with confidence and to proactively manage the dynamic nature of all of their MySQL servers over time. The MONyog Advisor Rules do this by monitoring all MySQL servers and notifying the DBA with specific instructions on how to proactively address found exceptions to align with the best practices.
MONyog makes MySQL DBAs more productive by allowing them to automate each of the MySQL Advisor Rules for unattended, around the clock operations. This helps minimize human errors, improves overall productivity and lowers the total cost of associated with managing MySQL.
For all of the Advisors, Advisor Rule violations trigger notification events can be sent via SMTP notifications. MONyog also provides expert advice on the specific problem that has been reported.
Serving as a “MySQL DBA in a box”, MONyog proactively monitors all of the MySQL servers across the enterprise, and empowers the DBA to address specific problems and tuning opportunities before problems start surfacing. The combination of enterprise visibility, proactive monitoring and expert advice and guidance in problem identification and resolution makes MONyog the perfect addition for managing and tuning MySQL servers.*
Comment :: April 30, 2008 @ 11:35 am