We are pleased to announce the availability of the 0.9.5.3 beta release of InfiniDB Community Edition.  This is our initial beta release and is not recommended for production work.

This release delivers the final content for our GA release, thus we have moved from an Alpha designation to a Beta designation.  Contents of this release include HAVING clause support and bug fixes that you can see at http://bugs.launchpad.net/Read More...

When we're looking at mk-query-digest report we typically look at the Queries causing the most impact (sum of the query execution times) as well as queries having some longest samples. Why are we looking at these ?

Queries with highest Impact are important because looking at these queries and optimizing them typically helps to improve system capacity, which in the end often improves response time of the system for variety of queries. Also queries causing highest impact often correspond to either frequent or slowest transactions in the system which makes these queries important to look at.

Slowest Queries correspond to bad response times. If there is 30 sec query this means somebody had to wait for 30 seconds which is typically not acceptable for interactive queries. It is best to look at 95 percentile "time" rather than slowest time for the queries as there are often exceptionally …

I’d like to clear up some misconceptions that have appeared in comments on various blogs, social bookmarking, and other fora in response to Monty’s recent call for action. Many of these have been repeated ad infinitum and it’s time to set the record straight.

1). Monty sold MySQL to Sun.

Monty founded MySQL Ab along with David Axmark. True. He and David then decided they’d like to pay their bills, and so to generate revenue, they decided to seek outside investors. As neither of them is highly experienced with such matters, they hired Mårten Mickos, who became CEO of …

Following our new Milestone-based release model, we've now published MySQL 5.5.0-M2. Please see the "What's New in MySQL 5.5" section of the reference manual for a summary of the most notable changes. The MySQL 5.5.0 Changelog provides a much more detailed list of changes, bug fixes and improvements.

Highlights in this release include:

The InnoDB plugin (currently at version 1.0.5) replaces the built-in InnoDB storage engine. This version includes a number of important performance …

Just a quick note to congratulate MySQL engineering on their next milestone release, MySQL 5.5. There seem to be some excellent new features, some of which have been hotly requested for quite some time:

• Support for SIGNAL/RESIGNAL — the ANSI/ISO method of throwing errors inside SQL procedures
• Support for partitioning by RANGE COLUMNS and LIST COLUMNS
• Support for semi-synchronous replication, which ensures that the master waits until at least one slave has committed a transaction

On the subject of SIGNAL/RESIGNAL, Roland Bouman has, as usual, an excellent and informative article on the subject. My personal opinion on SIGNAL/RESIGNAL is that it is one of the most …

There is no question about the MySQL Query Cache greatness.  The MySQL Query Cache feature started his way with some limitations.  However, in time, there were a lot of improvements (fixing) for those limitations. One should test his MySQL version with the Query Cache limitations before using it. Here are some improved limitations I found […]

Many providers embedd MySQL with their commercial products including Adobe, Macfee, Nokia, Symantec and ScienceLogic just to name a few. In addition most commercial third party storage engines have for years been forced to provided very customized versions of MySQL due to limitations in the storage engine API. These situations require a license agreement necessary with the trademark holder of MySQL. The Oracle Corporation EU Statement released on December 14, 2009 has carefully worded in the statement about these OEM licenses and storage engine providers there will be no changes for 5 years.

One specific detail is missing, what happens then?

As an individual that uses, recommends, promotes and advises clients especially on various storage engine …

Customize an existing AMI image

It's much easier to customize an existing AMI image to your own taste than to start from scratch so let's do that. First we need to find an image that is close to what we want. Read EC2 quickstart on how to setup the EC2 API tools.

$ ec2-describe-images -a 
…
IMAGE   ami-f0f61599    alestic-64/debian-5.0-lenny-base-64-20091011.manifest.xml       063491364108    available       public          x86_64  machine aki-a3d737ca    ari-7cb95a15            instance-store
…

This debian lenny image provided by alestic.com will serve as our base for running application servers and MySQL Cluster SQL and data nodes on. 

We are going to launch the image and install some software:

• Glassfish 3 (min req java 1.6.0.17) …

EC2 Preparation

First you need to sign up for Amazon's EC2 service and download your X.509 certificate and private key. The certificate and private key files are named as cert-<GUID>.pem and pk-<GUID>.pem. 

Create a directory to hold your EC2 access credentials.

$ mkdir ~/.ec2
$ mv ~/Downloads/*.pem ~/.ec2

Next download the EC2 API command line tools, add it to your PATH and create a few environment variables.

$ cd ~/bin
$ unzip ~/Downloads/ec2-api-tools.zip
$ ln -s /ec2-api-tools-1.3-46266 ec2
$ export $EC2_HOME=~/bin/ec2
$ export …