… to monitor only some of them, as appropriate, and might need to include others as well. Here’s how you can use our new monitoring… within its data directory. InnoDB is getting stuck, has long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB…Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…only partially correct in how to properly build the server to use it (bug …to have the ability to run a selected MTR testcase under Helgrind. (For the time being, running the whole MySQL…monitor_thread and srv_error_monitor_thread InnoDB threads storing to srv_last_monitor_time. It’s hard for me to…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query…swapping – not what you would like to see. Monitor how the value changes so you know …to run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…how to use MySQL not just if it should be used or not. There are many applications when MySQL…Monitoring and scaling features some users need other features than MySQL adding in newer MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL…running because they’re in Locked status, which might be an indication that it’s time to convert MyISAM tables to InnoDB…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…InnoDB status. Baron once wrote an article on how to…to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full status to be periodically printed into MySQL…to run SHOW ENGINE InnoDB STATUS at least once. Then see what MySQL …
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
…to access the MySQL server. What we will cover in this post is the monitoring script that run on the MySQL… SOCKET=/var/run/mysqld/mysqld.sock # initial sleep to give time to MySQL to recover InnoDB /bin/sleep 60 while … series will add some details as how the IP of the MySQL server is broadcast to …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…be running (monitoring, backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql…possible to InnoDB‘s buffer pool. For this, you need to find a way to tell Linux to …how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to run…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… a circular fashion. Based on these numbers, we can determine how many bytes back in the transaction log our oldest uncheckpointed… using innodb_adaptive_flushing_method in Percona server. In any case, if you run any kind of production MySQL server, you should be monitoring your Checkpoint age and your Innodb dirty pages and try to see the…
