… you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without…redesigned and rebuilt the pt-summary and pt-mysql-summary tools. The changes are not so obvious …version 1.0 GA release of the Percona Monitoring Plugins project. It features a variety of …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with most other monitoring systems)…on a replica. The pt-table-checksum tool from Percona Toolkit can generate table checksums… there are several others that can be performed with existing plugins, so there was no…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL… reset. A speculative processor might perform the read first, which could …srv_monitor_thread and srv_error_monitor_thread InnoDB threads storing to srv_last_monitor…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the lowest common denominator. We often use tools to gather a lot of the data …’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first… frequently bring the discussion to topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
… create open-source tools for monitoring, query analysis, replication management, and other capabilities. If you’re worried about Oracle making MySQL closed-source…’re dedicated to advancing the state of the art in MySQL performance and functionality, because our customers pay us to do it…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
…, capacity planning, troubleshooting, and monitoring to name just a few. The tcprstat tool itself is a means of …. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query’…many eyes have been on the code. We’ve performed tests on servers with high loads and observed …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… MySQL web MySQL installations using Sharding or replication IO needs are typically rather predictable. There are also often nice monitoring tools available … can’t always analyze the local system performance independently from anything else. Performance This is perhaps the most interesting one. …
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 extensions for hosting
April 24, 2008 By 11 Comments
…MySQL SHOW command it gives you the basic statistics on the database activity broken down by users, tables or indexes. Monitoring…fall under Other_commands a few MySQL performance counters broken down by users (full …logging, would give the administrator powerful tool to almost effortlessly catch the …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance… 060717 3:07:56 INNODB MONITOR OUTPUT ===================================== Per second averages…be used as debugging tool. Next section you will…
