by Michael Coburn | Jul 2, 2014 | Cloud, Insight for DBAs, MySQL
I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views. I came across two significant issues that... by Michael Coburn | Dec 13, 2013 | Insight for DBAs, MySQL, Percona Services
Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds behind to a fairly high six figure value. The servers were configured in a master-master relationship and used 5 figure server_id... by Michael Coburn | Jun 4, 2013 | Insight for DBAs, Insight for Developers, MySQL
Lately I have been working with a set of customers on a longer term basis which has given me time to explore new tools using their environments. One tool that I am finding very helpful is called SchemaSpy. SchemaSpy is a Java-based tool (requires Java 5 or... by Michael Coburn | Oct 19, 2012 | Insight for DBAs, Insight for Developers, MySQL
Did you just run an UPDATE against your 10 million row users table without a WHERE clause? Did you know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement? This is possible if you are running in binlog_format=ROW !Imagine this... by Michael Coburn | May 30, 2012 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working on a customer case this week, I saw an interesting problem where a table had many heavily utilized TEXT fields with some read queries exceeding...