• Further experiments with MySQL 5.6.7-RC: submit your bugs

    October 22, 2012

    Here's the background: I'm testing many features of MySQL 5.6.7-RC due to two reasons: I'm verifying my common_schema installs and works properly on 5.6 I promised I would present a 45 minute "what's new in MySQL 5.6" seminar in the upcoming OracleWeek (Israel) In the case of common_schema, I have managed to find one weird […]

  • InnoDB DDL: kudos to quick responders on bugs.mysql.com

    October 18, 2012

    Continuing my experiments with 5.6 InnoDB online DDL, a bug which I've opened, and another which I commented on were quickly answered and explained by the Oracle/MySQL team. On both accounts I'm happy to acknowledge the issue is resolved; in both cases I failed to produce a real bug scenario. Good lesson. Kudos for quick […]

  • Experimenting with 5.6 InnoDB Online DDL (bugs included)

    October 18, 2012

    MySQL 5.6 offers the groundbreaking online DDL operations for InnoDB. Most common use cases will enjoy this feature, and the need for online alter table scripts will decrease. This is a killer feature! I've put this new feature to the usability test. How did it go? Not too well, I'm afraid. [Updates to this text […]

  • Percona Live MySQL Conference and Expo 2013, Call for Papers

    October 16, 2012

    I'm honored to accept the role of conference chairman in the upcoming Percona Live MySQL Conference and Expo,¬†April 22th-25th, 2013, Santa Clara, CA. Here are a few administrative announcements: Call for Papers Call for papers is extended until Oct 31st. We've already received a good number of submissions, but wish to provide with another chance […]

  • Thoughts on MySQL 5.6 new replication features

    October 15, 2012

    After playing a little bit with MySQL 5.6 (RC), and following closely on Giuseppe's MySQL 5.6 replication gotchas (and bugs), I was having some thoughts. These are shared for a few reasons: Maybe I didn't understand it well, and someone could correct me Or I understood it well, and my input could be of service […]

  • Your magical RANGE partitioning maintenance query

    October 9, 2012

    If you use RANGE (or RANGE COLUMNS) partitioning, and in particular when partitioning by date/time, then your are subject to the following questions: how and when do you create the "next" partition? How and when do you drop your older partitions? Many people use in-house scripting to do that, and Giuseppe Maxia wrote Partition Helper. […]

  • MySQL 5.6 new features: the user's perspective

    October 5, 2012

    This is a yet-another compilation of the new MySQL 5.6 feature set. It is not a complete drill down. This list reflects what I believe to be the interesting new features user and usability -wise. For example, I won't be listing InnoDB's split of kernel mutex. I'm assuming it can have a great impact on […]

Powered by Wordpress and MySQL. Theme by openark.org