Most of the Nagios plugins included with the Percona Monitoring Plugins are purpose-built for specific scenarios that I found … to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to… counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking…’ll show how to use it to forecast scalability and performance The new Percona Toolkit release is available for download today… also a version 1.0 GA release of the Percona Monitoring Plugins project. It features a variety of bug fixes.
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with most other monitoring systems) is the alert… of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of them… in that list, there are several others that can be performed with existing plugins, so there was no need to write…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, …after the reset. A speculative processor might perform the read first, which could leave a…between srv_monitor_thread and srv_error_monitor_thread InnoDB threads storing to srv_last_monitor_time….
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… clients Give away the resources On hamysql Run MySQL Monitor MySQL Get out of way if MySQL is not running From the above requirements… online, just performs these steps: Place holders for the resources scripts On each host: root@monitor:~# touch /usr/local/bin/mysql root@monitor:~# chmod…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…. We also frequently bring the discussion to topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL… the defined performance threshold. In many cases, people don’t define a performance threshold, it is basically the service monitoring frequency and…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… but forgot to delete old ones) MySQL Server simply would not start. In recent MySQL 5.0 series however it will continue…. Also monitoring often monitors MySQL is up and running and will not query all tables are accessible not catching such errors. If MySQL is… I’ve seen it beating up people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the… involved. In could be even system which queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query…
