Everything MySQL

A great place to be!

November 2009 Blog Posts (2)

MySQL UC 2010?

Soooooooo, is the MySQL conference going to fizzle out in 2010? If you have been busy waiting to see what will happen with Oracle/Sun/MySQL then you probably didn’t notice that the call for papers did not go out to the community for 2010 UC. I don’t know about you but the MySQL Conference is something I look forward to every year and enjoy attending. Just being there is great for networking and keeping up on innovation not to mention getting out of the office for the better part of a… Continue

Added by Chris on November 24, 2009 at 3:36pm — 2 Comments

Broken Index from InnoDB Hot Backup

A very interesting problem came up a while back when testing a rebuild and failover procedure. I had just run a rebuild of a slave server with InnoDB Hot Backup from the master. After the failover, one query on three tables in three different databases was not performing as it should. This was very odd to me given that the same table in all three databases was acting up. Below is the table structure and example query:



mysql> show create table… Continue

Added by Chris on November 9, 2009 at 1:44pm — No Comments

RSS

© 2024   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service