The latest from the MySQL community

Percona's patches are now available to a wider audience via OurDelta, a community effort to provide  builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren't in the main MySQL server. Arjen Lentz is really the brainchild behind this. Kudos Arjen!

What does this mean for the Percona patches? Well, now you can get them in more places.  But it doesn't change our own commitment to keep innovating in ways our customers (and we ourselves) find useful.  We're still building our own builds and …

Want to use Dtrace or ZFS but are unfamiliar with building MySQL on Solaris? Dont panic, its never been easier. Here are the steps that worked for me.

1. Install OpenSolaris using the latest development ISO file
2. Install developer tools

   pfexec pkg install ss-dev

3. Download 5.1.28rc source
4. Build it

   export CC=/opt/SunStudioExpress/bin/cc
   export CXX=/opt/SunStudioExpress/bin/CC
   export CFLAGS="-xO3" #Your fav compiler flags go here 
   export CXXFLAGS="-xO3"
   
   ./configure --with-plugins=innobase,myisam --with-mysqld-libs=-lmtmalloc
   gmake 
   

Yes, it is that simple. Of course you could just download the binaries and use them too; they work just fine.

Kickfire™, Inc. today announced that it has entered into a global multi-year MySQL Enterprise™ data warehouse agreement with Sun Microsystems. Under the terms, Kickfire's Series 2000 and 3000 analytic appliances will include a MySQL Enterprise subscription, providing customers with a fully integrated, plug-and-play solution. Kickfire will provide customers a single point of contact for both hardware and MySQL™ technical support, ensuring a seamless end-user experience.

With the build system, repos, patches and launchpad sorted, we can release! First up from OurDelta is a build of 5.0.67, using patchrev d6, for i386/x86_64. This is basically Percona patchset 5 with a few fixes plus the Sphinx storage engine. It even passes the testsuite ;-)

• RHEL/CentOS 4.6/5.2 RPMs and YUM repo info
• Ubuntu Hardy DEBs and apt-get repo info

Other useful links:

• Launchpad project and patch repo
• Developer team and mailing list (do join!)
• Bug handling

Now, …

With the build system, repos, patches and launchpad sorted, we can release! First up is a build of 5.0.67, using patchrev d6, for i386/x86_64. This is basically Percona patchset 5 with a few fixes plus the Sphinx storage engine. It even passes the testsuite

• RHEL/CentOS 4.6/5.2 RPMs and YUM repo info
• Ubuntu Hardy DEBs and apt-get repo info

Other useful links:

• Launchpad project and patch repo
• Developer team and mailing list (do join!)
• Bug handling

Now, this being a first release into the wild, there are bound to …

A whole bunch of people have successfully written plugins for MySQL using the plug-in framework which first appears in MySQL 5.1. On the whole, the simple examples work great, as long as all your code is in one directory. Here is a helpful tip...Inside the plug.in file, you can use MYSQL_PLUGIN_DIRECTORY_<FOO> as an alias to the directory in which your plug.in is located within, where FOO is the

Network.com setup in Vegas, Thumper disk bay, green by Shawn Ferry

As I expected it would, the fact that I used ZFS compression on our MySQL volume in my little OpenSolaris experiment struck a chord in the comments. I chose gzip-9 for our first pass for a few reasons:

1. I wanted to see what the “best case” compression ratio was for our dataset (InnoDB tables)
2. I wanted to see what the “worst case” CPU usage was for our workload
3. I don’t have a lot of time. I need to try something quick & dirty.

I got both those data points with enough granularity to be useful: a 2.12X compression ratio over a …

A while back, Giuseppe pointed out Andrey Zhakov’s implementation of Virtual Columns for MySQL.

Since then, Andrey has ported that code to Drizzle and sent us a message about the Launchpad Tree.

First, the bad news. I waited long enough to actually look at it that the merge was no longer clean. The Drizzle codebase moves pretty quickly, you know. Andrey was wonderful about helping fix those issues, I got it all merged in and tested, and pushed.

Drizzle now has Virtual Columns. w00t.

As a quick aside, I’d like to mention a few things Andrey …

So many engines, and so little to choose from. This is one of our two major decision points in Drizzle right now.

Let me explain.

Today we have Innodb, Maria, Falcon, and PBXT.

Simple?

Not really. Innodb is not a single engine, it is three engines. We have the default one which is shipped. It has been the wunderkinder for years now but has been showing its age. Go buy a piece of hardware that has four cores and it quickly becomes apparent that it is not aging well. There is the Innodb plugin, and while it delivers on features, performance still …

Want to use Dtrace or ZFS but are unfamiliar with building MySQL on Solaris? Dont panic, its never been easier. Here are the steps that worked for me.

1. Install OpenSolaris using the latest development ISO file
2. Install developer tools

   pfexec pkg install ss-dev

3. Download 5.1.28rc source
4. Build it

   export CC=/opt/SunStudioExpress/bin/cc
   export CXX=/opt/SunStudioExpress/bin/CC
   export CFLAGS="-xO3" #Your fav compiler flags go here 
   export CXXFLAGS="-xO3"
   
   ./configure --with-plugins=innobase,myisam --with-mysqld-libs=-lmtmalloc
   gmake 
   

Yes, it is that simple. Of course you could just download the binaries and use them too; they work just fine.