• Speaking in London: common_schema, DBA's framework for MySQL

    November 22, 2012

    I'm happy to be speaking about common_schema at Percona Live London, Dec 4th, 2012. This will be the first chance for me to speak about common_schema, what I believe to be an extremely useful companion to your MySQL server. I will show you how common_schema can leverage your SQL skills and give you new powers. […]

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

  • Percona Live 2013: Tutorials schedule released!

    November 19, 2012

    I'm pleased to announce the availability of the Tutorials Schedule for Percona Live MySQL Conference and Expo, 2013. This schedule comes as the outcome of hard work put by the reviewing committee members. Thanks! This work is much appreciated! We got a good number of submissions. We've also reached out to prominent speakers and companies […]

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

  • Purging old rows with QueryScript: three use cases

    November 14, 2012

    Problem: you need to purge old rows from a table. This may be your weekly/monthly cleanup task. The table is large, the amount of rows to be deleted is large, and doing so in one big DELETE is too heavy. You can use oak-chunk-update or pt-archiver to accomplish the task. You can also use server […]

  • common_schema 1.2: security, partition management, processes, QueryScript goodies

    November 13, 2012

    common_schema 1.2 is released! This version comes shortly after 1.1, yet contains quite a few interesting goodies: Account blocking Security audit RANGE partition management Slave status Better blocking and idle transaction management QueryScript goodies: echo, report while-otherwise statement; foreach-otherwise statement Better variable scope handling Complete support for variable expansion Transaction support within QueryScript More summary […]

  • My take on privatized MySQL security bugs

    November 8, 2012

    A couple weeks ago I submitted BugĀ #67315: Crashing server by stored function referencing user defined variable in query. If you press that link, you can't see the bug (though I can as I submitted it). This is due to Oracle's policy for security-related bugs. Tomas Ulin, Vice President MySQL Development at Oracle , was kind […]

  • Pop quiz: funny syntax

    November 5, 2012

    The following questions are of little importance, yet I find them entertaining. I stumbled upon these while developing QueryScript. Can you guess the results of the following statements? Pop quiz 1 SET @x := 7; SELECT ++@x; What is the computation result? What will be the value of @x? Pop quiz 2 SET @ := […]

 
Powered by Wordpress and MySQL. Theme by openark.org