'New Features' Tag

  • gh-ost 1.0.17: Hooks, Sub-second lag control, Amazon RDS and more

    September 6, 2016

    gh-ost version 1.0.17 is now released, with various additions and fixes. Here are some notes of interest: Hooks gh-ost now supports hooks. These are your own executables that gh-ost will invoke at particular points of interest (validation pass, about to cut-over, success, failure, status, etc.) gh-ost will set various environment variables for your executables to […]

  • Baffling 5.7 global/status variables issues, unclean migration path

    August 7, 2015

    MySQL 5.7 introduces a change in the way we query for global variables and status variables: the INFORMATION_SCHEMA.(GLOBAL|SESSION)_(VARIABLES|STATUS) tables are now deprecated and empty. Instead, we are to use the respective performance_schema.(global|session)_(variables|status) tables. But the change goes farther than that; there is also a security change. Oracle¬†created a¬†pitfall of 2 changes at the same time: […]

  • common_schema: 1.3: security goodies, parameterized split(), json-to-xml, query checksum

    January 14, 2013

    common_schema 1.3 is released and is available for download. New and noteworthy in this version: Parameterized split(): take further control over huge transactions by breaking them down into smaller chunks, now manually tunable if needed duplicate_grantee(): copy+paste existing accounts along with their full set of privileges similar_grants: find which accounts share the exact same set […]

  • State of InnDB Online DDL in MySQL 5.6.9-RC (good news included)

    December 18, 2012

    5.6.9-RC is out, and I was curious to see how the online DDL has improved since my 5.6.8 review. I also owe James Day this review, since he came up with results inconsistent with my own. We both agreed the dataset I was using was too small, but I got similar results even on larger […]

  • State of InnDB Online DDL in MySQL 5.6.8-RC

    November 20, 2012

    5.6.8-rc is out, and so I'm following up on InnoDB's online DDL new feature: the ability to SELECT, INSERT, DELETE, UPDATE a table even while an ALTER TABLE is executing on same table. The brief summary Not as advertised; many things can't be done. The longer review I'm using 5.6.8-rc 64bit binary distribution for Linux, […]

  • MySQL 5.6 RC: further thoughts and questions

    November 19, 2012

    Here are a few questions I came up with while experimenting with MySQL 5.6.7 & 5.6.8. They are the impressions of a first-time encounter with 5.6, which is a single opportunity for a person to point out the things that strike as odd. Bugs-wise, just submitted another crashing bug for 5.6.8. I'm just one man, […]

  • 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 […]

  • 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 […]

Powered by Wordpress and MySQL. Theme by openark.org