Here’s a quick productivity tip: when optimizing queries by rewriting them to different forms that should return the same results, you can verify that you get the same results by taking a checksum of them. Just set your pager to md5sum: mysql> pager md5sum - PAGER set to 'md5sum -' mysql> select * from test; a09bc56ac9aa0cbcc659c3d566c2c7e4 - 4096 rows in set (0.00 sec)

The schedule for the 2009 Percona Performance Conference has been released. Take a look, see what interests you, and (optionally) register to come. We look forward to seeing you all there!

Entry posted by Ryan Lowe | One comment

Add to: | …

A couple of weeks ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx in Production. This is also a great way to support the project and get something in return - even if you're not actively using support it looks better than donation for accounting people.

The Support approach was closely modeled from MySQL Support of the early days - simple service lever differentiation with no per server pricing or different editions. This is exactly how I think Support for Open Source project should be structured. Of course such service offering may be lacking the "leverage" but how much leverage do you really need if you do not have sales and marketing teams or venture capitalists to feed? If money you pay go …

In preparation for the MySQL UC and my session about binlogs I started to implement a first few ideas. In a short coding rush I moved some of the C-code from mysql-binlog-dump.c to the right places in the libraries and wrapped it nicely for Lua.

My overall goal is to make a clean cut between

• a library to work with binlogs
• wrapping with for Lua's use
• a front-end that's making use of all of it

With code in hands I can now toss in a liitle lua script to dump a simple statement-based binlog:

local binlog = assert(require("mysql.binlog"))
local basedir = "/usr/local/mysql/data/"
local file    = "jan-kneschkes-macbook-pro-bin.001005"

while file do
    local f = assert(binlog.open(basedir .. file))

    file = nil

    for event in f:next() do
            if event.type == "QUERY_EVENT" then
                    print(("/* threadid: %d */ %s"):format( …

We are trying to compile Connector/C++ in the OpenOffice.Org environment, however dmake, the OO.Org build too (Ubuntu/Debian has it) can't work currently with CMake. CMake is the meta-make system we use for Connector/C++ to easy the portability. I had a blog entry which platforms are supported, a vast number. Without CMake this wouldn't have been that easy.

MySQL 5.1 was released as GA not long ago (current version 5.1.32). I work at SUN/MySQL as a connector developer. Currently working on Connector/C++, previously I used to develop mysqlnd of the PHP fame, currently I maintain it. Every single day I work with the MySQL Server and like everything in this world, it's imperfect. You know perpetuum mobile doesn't exist.

Tomorrow, The Big Trek starts. Duleepa “Dups” Wijayawardhana will spend the time from then on until the MySQL Conference and Expo starts travelling by rail and bus all the way from home in Montreal to California. Hence the name “Dups on Rails”. The purpose of the Big Trek is to talk about MySQL in Canadian and US universities. He’ll also arrange MySQL Meetups and go on customer visits, as people ping him.

Towards the end of the trip, as we get closer to the User Conference, Dups won’t be alone. His alter ego Colin Charles (yes, people do mix up Dups and Colin) will join him from 13 April onwards in Northern California. And at the same time, a parallel trek is started by Giuseppe Maxia an Sheeri K. Cabral, in Southern California.

The list of universities include Queens University, University of Western Ontario, Illinois Institute of Technology, Purdue University, University of …

The Mahalo PHP Meetup was a lot of fun. Firstly, Sharon Levy had a great presentation with cool sound effects. That definitely gets your attention… It’s always good to watch the best techniques presenters use to engage the audience, and … Continue reading →

The time is just running and it's already time, again, for students to apply for this year's Google Summer of Code program. PHP and MySQL are among the list of 150 participating organizations. So if you're a student and are interested to learn how OpenSource works, do some networking with some famous people or just want a Google T-Shirt it's your time to take a look at the different idea pages (PHP, MySQL, others) or come up with an own idea and apply. Oh if accepted you even can earn some money as part of the program ...

Changes (as compared to 8.03) include:

Features:
* Crash dumps with no information (zero-size) will now be deleted automatically.
* When saving/copying from the editor the LETTERCASE modfications for keywords and functions will now be preserved.
* Selecting a ‘child’ object for a table (columns and indexes) will now refresh the DATA tab if DATA tab is open. Before only selecting the table object itself did. Also the table information is now available in OBJECTS tab when a column or index is selected.
* Now also a ‘key’ icon is used for identifying the Primary Key in an Object Browser ‘Indexes’ folder,
* When a GRID cell is only partly visible, doubleclicking it will move the grid position so that cell/row will become visible (before it worked like that with singleclick - we changed to doubleclick as this is a de facto standard in such grids - in Excel for …