As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch error a… TABLE innodb_table_monitor (a INT) ENGINE=INNODB; This, primitively, tells Innodb that it should start the Table monitor. The monitor itself dumps the… time and asked me to take a look and see what happened. I looked through the data and found not only was…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… slightly different data, or greatly different data in some cases I observed, are frustrating at best and wrong or misleading at… innotop or what have you, once a second! Second, if your monitoring is to be at all useful, you should not monitor too many… three-minute-old file — what good is that? You should be monitoring the server, as of NOW, rather than monitoring the contents of some…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem… list of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of…-fits-all value. This plugin, perhaps more than any other, should only be used judiciously. The server has been restarted recently…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…race between srv_monitor_thread and srv_error_monitor_thread InnoDB threads storing to srv_last_monitor_time. It…buffer pool stats, the I/O stats might be slightly smaller than they should be. ==9090== Possible data…the last kind). What would I do about all this? If I had my way, I‘d use atomic access…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
… can help do that. 2. Monitor Your Servers Everybody should have an automated monitoring system that is watching key…to understand changes in your application, or understand what happened just prior to a crash. Here’s…ve gone through the process a few times. I‘d say that a practiced consultant can do…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it… so the messages disappear into nothingness. So what then? I discovered that InnoDB will still create the …is 11886, so I will be using it in the examples, but you should of course use …
Comment: How to Monitor MySQL with Percona's Nagios Plugins
February 23, 2012 By 8 Comments
… budget. So I think more emphasis should be on “if you do choose to monitor ratios/thresholds, think about what purpose the monitoring serves” – and that goes for whether the monitoring…
Post: What’s a good buffer pool read/write ratio?
May 31, 2011 By 6 Comments
… at your graph wondering what it should look like, the answer is probably “it should look exactly as it looks!” I’ve gotten a… about, not for trying to discover problems. Your monitoring and alerting system (Nagios?) should be trying to discover whether there is a problem. The graphs are there for quickly showing you what has changed…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
September 26, 2008 By 34 Comments
What about MySQL Monitor, the Monitoring tool that is part of MySQL Enterprise? I have installed MySQL Monitor and it gives specific information about parameters… MyISAM to InnoDB and vice versa, parameters in my.cnf should be modified. Unfortunately modification of certain parameters is not easy…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… Checkpoint age, which is the subtraction I described above. I think of the Max checkpoint age … that are not flushed. This, in essence, is what fuzzy checkpointing is. The checkpoint process is …any kind of production MySQL server, you should be monitoring your Checkpoint age and your Innodb dirty …
