MySQL Performance Blog

Update 3 June 2008: We have removed the builds below, since they are quite obsolete and no one has posted comments about them since more than a year ago.

Great news are MySQL finally released new Community release - MySQL 5.0.33, which however as promised comes without Binaries.
This version also does not have any community patches yet, coming of the same tree as MySQL Enterprise.

To help those who would like to use MySQL Community version but does not like to build binaries we decided to publish our build for MySQL 5.0.33 Community release.

This build was done using “Generic Linux RPM” spec file on CentOS 4.4 (RHEL compatible) x86_64

(Links removed)

We added one more RPM to stantard MySQL RPMs - MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm
This package contains mysqld-microslow binary, the server built with our microslow patch, which enables microsecound in slow-log.

More info about the patch
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/
http://bugs.mysql.com/bug.php?id=25412

Also we propose Linux (AMD64 / Intel EM64T) binaries in tar.gz archive

(Link removed)

The archive contains both mysqld and mysqld-microslow binaries.

Source tar.gz with microslow patch

(Link removed)

The patch by itself

18K patch.slow-micro.5.0.33.diff

We are waiting for your response if our binaries are helpful and if we should make binaries for other platforms / Linux distributions or if you would like to help us doing builds.

Now as new MySQL Storage engine - Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL.

These thought base on my understanding, reading docs, speaking to Jim, Monty, Arjen and other people so I might miss something, something might be planned to be changed or not 100% correct but anyway you might find it interesting.

In many cases what I find good or bad would base of my MySQL use with existing applications - if you design new applications which are done specially for Falcon you might find those aspects positive.

[read more...]