…: How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to it and attempt to run…’ Running mysql_install_db under strace, I saw that it was getting a lot of “bad file descriptor” errors. I was able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… 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 21 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: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…here is how to get Percona Server for MySQL up and running: …mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql…InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | [...] mysql…
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: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… not recover You run into a InnoDB corruption bug that propagates…MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring…to run, can run about anywhere with disk space and writes out binlog files sequentially. Tips/Tricks (how we run this): Ensure it stays running…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…How to make the tools connect to MySQL The slides are now available here, and slide 7 provides a basic introduction to…to slaves with the –recursion-method option. Q: In the case of slave behind master, can you explain how to run…
