Finally!

We have a release of MySQL Community Server that contains community-provided contributions and it is ready for your download in binary form.

Thanks to Jeremy Cole for providing us with the SHOW PROFILE patch. Quoting our Reference Manual at http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html:

SHOW PROFILES

SHOW PROFILE [type [, type] … ]
[FOR QUERY n]
[LIMIT n [OFFSET n]]

type:
ALL | BLOCK IO | CONTEXT SWITCHES | CPU | IPC | MEMORY | PAGE FAULTS | SOURCE | SWAPS

The SHOW PROFILES and SHOW PROFILE statements display profiling …

The MySQL GUI Tools team has recently shipped release 10 of their full set of tools.  This is a bundle that includes the GA versions of

• MySQL Administrator 1.2.10
• MySQL Query Browser 1.2.10
• MySQL Migration Toolkit 1.1.10

The GUI team has spent the last few months fixing all of the bugs that they could find in these products (and not adding new features!)  So if you've tried out some of the tools previously and had compatability issues, this is a good time to take them out for another test run.  These tools are available in a single download version and provide easy ability to graphically configure, manage and …

I got an email today from O'Reilly today about the MySQL Conference (coming up at the end in April), it looks like a pretty good conference, but one of the sessions caught my eye. It was called A Storage Engine for Amazon S3.

Amazon's S3 is a web apt-oriented storage service, making storage available to both ordinary HTTP browsers and to sophisticated applications via SOAP and REST interfaces. Learn how useful it is to make this storage accessable to MySQL users via a plug-in storage engine.

I did some quick googling but I couldn't find the plugin, so I am guessing that it will be released at the conference. Anyone have a link?

This gets interesting when combine this with Amazon EC2, because you are not charged for bandwidth from within amazon's network, and you are connected to S3 on a fast network.

The MySQL Community Team has been strengthened, getting an Engineering arm able to process code patches.

In an effort to align MySQL company resources to support an Architecture of Participation, we have reallocated Chad Miller and Giuseppe Maxia from the Engineering team to form the Community Engineering team. Chad is allocated towards enabling us to …

Solid's storage engine for MySQL (MySQL/solidDB) brings in an unexpected species to your computer. A small tree will grow in your computer's memory to ease the burden of the transaction processing. It is called "Bonsai Tree" and is a part of innovative Solid technology. Bonsai tree serves as a "smart cache", collecting the data that are being processed, have been recently processed, or are likely to be processed. In other words, Bonsai Tree is a highly efficient implementation of a hot spot -- the part of the database that is subject to high activity. All real-life databases have hot spots that are typically a few per cent of the total database size.

You might say: isn't the traditional page buffer pool (database cache) supposed to take care of that, by maintaining the most commonly used pages in main memory?

The answer is yes, it does--but not in the most …

Today’s been interesting. Its labour day here in Melbourne, so I believe a lot of people are enjoying the long weekend. I on the other hand, have been labouring over the long weekend, and we have stuff to show for it. Via the Forge Wiki:

• Google Summer of Code 2007 - we’ve applied, we’ve identified mentors, and we’ve also identified some project ideas. Last week was rather busy sorting all this out. My boss, Kaj explains it a lot better in his post, Global Warming & Google Summer of Code. Students, do apply to come code with us!
  Keep the March 14 - 24, 2007 dates (Cupertino, California time) in your mind students… Thats when the Google SoC opens up. Of course, come March 14 we …

<p>Transaction performance relates among other things from I/O performance. This means hard disk performance.</p>

<p><b>Hard disk performance</b></p>

<p>When you select a hard disk, an important feature to consider is the performance (speed) of the drive. Hard disks come in a wide range of performance capabilities. As is true of many things, one of the best indicators of a drive?s relative performance is its price. An old saying from the automobile-racing industry is appropriate here: "Speed costs money. How fast do you want to go?"</p>

<p>The performance of a hard disk depends on several delays associated with reading or writing data on a computer's disk drive.</p>

<p>A measurement, called average access time (AAT), involves the elements, average seek time (AST), average rotational latency (ARL) and transfer time (TT).</p>

Don't miss this date! March 14th is the last date to get a $200 discount for a MySQL Users Conference registration.

Watch out for the Tutorials, Sessions, Speakers and Events and take the opportunity to Get MySQL Certified during the Conference!

I'm looking forward to meeting you!

What happened with the MySQL Winter of Code? It was hit by Global Warming. Specifically, the Community Team got heated up working on the MySQL Conference & Expo 23-26 April 2007, left with little bandwidth to pursue the ideas and action items for Winter of Code.

When winter warms up, it slowly turns into summer. But the coding work remains. Colin Charles was smart enough to combine these two facts with Sheeri Kritzer’s blog entry and hints about the Australian Winter, and took action related to the Google Summer of Code. Colin spoke to Chris DiBona and Leslie Hawthorn of Google and has now signed us up for Google Summer of Code.

In short: …

Its that time of the year again when time changes and we have to make sure our servers are using the right zone with right time. Out of many servers I admin, I found 3 servers which had wrong time displaying. All of them had one thing in common, Fedora Core 4. So I fixed it by doing the folowing.

mv /etc/localtime /etc/localtime.old

ln -s /usr/share/zoneinfo/PST8PDT /etc/localtime