… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… for the next release of MHA. Q: How do you monitor MySQL to determine when it’s not responsive? A: The easiest… you ever want to use MySQL on top of something like that? I can’t imagine the performance being all that fantastic…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…is a Corosync plugin that monitors the names and number …, see bellow how to perform this action [root@percona1 percona]# …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 …, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack…that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls… is causing flow control. I would strongly recommend monitoring and graphing wsrep_flow_control_sent so you…
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….) transactions: 161630 (538.76 per sec.) # using skip-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 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: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… no more than low tens with normal load. Many have monitoring set up to kick in if number of threads running… if people do not really run MySQL with high concurrency does it really matter how MySQL performs with high concurrency or is it just marketing gimmicks to promote new software versions ? Performance at High Concurrency…
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: 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…
