Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26
June 18, 2013 By Leave a Comment
… the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar is not meant to necessarily…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based… for the next release of MHA. Q: How do you monitor MySQL to determine when it’s not responsive? A: The easiest…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… the next release). CMAN v3 is a Corosync plugin that monitors the names and number of active cluster nodes in order…_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…
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…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… up, managing and monitoring PXC. MariaDB Galera Cluster users should fit right in: http://www.percona.com/live/mysql-conference-2013/sessions…-cluster-galera-practice-part-1 http://www.percona.com/live/mysql-conference-2013/sessions/percona-xtradb-cluster-galera-practice-part-2… idea. If you’ve considered an architecture that uses standard MySQL async replication with any kind of circular replication and multi…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… which node is causing flow control. I would strongly recommend monitoring and graphing wsrep_flow_control_sent so you can tell…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… that could prove useful in certain situations. Winner: FlashCache. Operational Monitoring: Both solutions offer plenty of statistics; the main difference is… stats have to be retrieved by running the vgc-vcache-monitor command. Personally, I prefer “cat /proc/something” but I’m…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
March 27, 2013 By 23 Comments
…,it seams to be something whrong … with your build of mysql-5.6! On 64bit Win7 host running 512 MB VirtulBox… syscall nx lm constant_tsc up rep_good nopl pni monitor ssse3 lahf_lm bogomips : 5756.60 clflush size : 64 cache… (538.76 per sec.) # using skip-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package ! You…
Comment: Introducing the pmp-check-mysql-status Nagios Plugin
March 22, 2013 By 2 Comments
Hi All, I am new to Percona plugins for monitoring MySQL in nagios. Can anyone please elobrate the process and help me to succeesfullly apply the plugins in my environemtn. Thanks, subash
