June 19, 2013

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

…Corosync plugin that monitors the names …bellow how to perform this action [root@percona1...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… using cman_tool or clustat (if you …

Post: Percona Monitoring Plugins 1.0.3 for MySQL now available

Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring … scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios… DBA installation and setup of these tools are included with our services. You …

Post: How to Monitor MySQL with Percona's Nagios Plugins

… 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

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

… 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: How Can Percona MySQL Server Development Services Help ?

performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQLtools, features, improvements, and bug fixes in tools like Percona Toolkit, Percona Xtrabackup, Percona Monitoring Plugins, and others. Non-Percona Tools

Post: Percona Toolkit 2.1 with New Online Schema Change Tool

… 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: Percona's Commitments to MySQL Users

… 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

…, 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 …

Page: Consulting for MySQL

MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL