… is a Corosync plugin that monitors the names and number …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql… your cluster using cman_tool or clustat (if you have installed …
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions… of Percona’s Remote DBA installation and setup of these tools are included with our services. You can find links to…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and …? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with most other monitoring systems) is the alert… diverge or drift on a replica. The pt-table-checksum tool from Percona Toolkit can generate table checksums, and the pmp…
Post: Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities
February 15, 2013 By Leave a Comment
… announce the release of Percona Monitoring Plugins 1.0.2 — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed… of Percona’s Remote DBA installation and setup of these tools are included with our services. You can find links to…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 Comments
… suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables… have completely redesigned and rebuilt the pt-summary and pt-mysql-summary tools. The changes are not so obvious to the user… also a version 1.0 GA release of the Percona Monitoring Plugins project. It features a variety of bug fixes.
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… the Helgrind tool of the Valgrind dynamic analyzer suite. Now, Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL server… is a race between srv_monitor_thread and srv_error_monitor_thread InnoDB threads storing to srv_last_monitor_time. It’s hard…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the above… your backup, it’s likely not to affect the other tool. Store your backups on more than one server. In addition… example outages listed above. Each tool has it’s strong points given the conditions. Percona XtraBackup for MySQL for binary backups. Strong…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server …new tools, features, improvements, and bug fixes in tools like Percona Toolkit, Percona Xtrabackup, Percona Monitoring Plugins, and others. Non-Percona Tools -…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… historical metrics, capacity planning, troubleshooting, and monitoring to name just a few. The tcprstat tool itself is a means of gathering raw… outbound packet. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query’s response… means there are no dependencies. You can just run the tool. In the future, packages in the Percona repositories will provide…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… workings of one of the nicest features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we… I would like to see better algorithms, statistics computation and monitoring variables about index usage in the future, now that we… to be prepared for the MySQL 5.6 release, and get advantage of the latest integrated tools that MySQL provides with its last…
