My name is Kurt, and I’m a SELECTaholic … wait … wrong place. Strike that.

Thanks very much to Dups and Bryan Alsdorf for getting this all sorted.

A few days before OSCon Henrik Ingo, our newly hired COO, forwarded me a post of Mark Callaghan with the following plaint on the state of certain latest optimizations that had been introduced into the MySQL Server, namely, Multi-Range Read (MRR), Index Condition Pushdown (ICP) and Batched Key Access (BKA).

> I have seen descriptions for each of these features that describes
> them in isolation. Is there one page where they are described
> together? And if there isn't can I convince Sergey and Igor to write a
> new blog post?

Further in the post, Mark points to the slew of …

History
The first example of dual-licensing was probably Ghostscript, which Peter Deutsch licensed first under the GPL and later under the Aladdin Free Public License, but also under a proprietary license.

Inspired by his idea, David Axmark and I released MySQL under similar dual-licensing terms. Dual licensing has since become one of the most common and popular ways to create profit centers around Open Source/Free Software, in addition to support and services around the product.

To be able to bootstrap MySQL Ab, we originally had a license that allowed free usage, but a "pay-for" license if you used MYSQL for commercial usage or on the Windows platform. In 2000 we changed the free license to GPL, mostly to avoid having to explain our own license to everyone.

The basic idea for our dual-licensing was this: if you bought a …

OIN offers cash for patents. CentOS crisis averted. Microsoft denies GPL violation. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Open Invention Network offered individual inventors cash for patents, and acquired patents from V_Graph.

# The H Open reported that the management problems at CentOS are now resolved.

# Sam Ramji told Network World in detail why Microsoft believes its Linux IC code did not violate the GPL (from 15m 30s).

# Canonical delivered an on-premise version of …

One of our next targets for Drizzle is a Performance Schema. We have been graced with a design for it by Robin Schumacher who works for MySQL and in the past worked for Embarcadero.

Here is a link to the master blueprint for the design:
https://blueprints.launchpad.net/drizzle/+spec/performance-interface

This is one of the next big projects for Drizzle. We would love to receive feedback on the design. We are very aware that a database cannot be a black box, and this will be a big step in changing this.

Few words about current status of 5.2 branch, its main feature Query Editor, and plans for nearest future about it. 5.2 is still in alpha stage, but we did good progress lately and plan to release beta version soon.
For v5.2.2 major efforts were concentrated on stabilization of existing functionality and code base. There are few improvements in Query Editor visible to end user, while a good bunch of bugs were revealed and fixed – thanks to community for bug reporting. Even more fixes/improvements were merged from 5.1 branch. While we continue to work on stabilization, we plan to add following features before transition to beta stage:

• Client side sorting
• Advanced editor for text fields of recordset
• Saving/retrieving BLOB values
• Option to propagate changes made to recordset to multiple DBMS instances

Keep an eye on new releases, your feedback is very valuable and helps a …

Microsoft's recent 10-K reveals that the software giant still views open source as more foe than friend.

Today, we are announcing that we're ready to offer training for InnoDB and XtraDB in Santa Clara and San Francisco.  The course was developed by Morgan Tocker with input from all our team - and covers a lot of the performance problems we run through in our consulting practice.

The Details:

14th Sept - Santa Clara
1 day intensive course
Cost: $300*

16th Sept - San Francisco
1 day intensive course
Cost: $300*

(* includes a copy of High Performance MySQL if you register before 31st Aug).

The delivery format:

Being only one day, we elected to deliver the course in a predominately lecture-format - but there will be a few opportunities to try examples.  For more information see the …

I got time to spend on a really old worklog I completed coding
already october 2005. I blogged about it in July 2006 and
interestingly enough it's still the second most read blog
entry on my blog (probably related to search engines in some
way).

I have merged it with the azalea tree (this is an internal code
name for our development tree, name is likely to change). This
tree contains subquery optimisations, Batched join and some more
optimisations.

I have fixed a whole bunch of bugs that always shows up in early
code. The code quality is still alpha but at least you won't find
10 bugs per hour :)


Here you can find the launch pad tree for this code.

There are two important additions made possible by this tree. …

Jonas just wrote a patch to this bug on OPTIMIZE TABLE, and the issue that was also discussed in this blog post. Jonas also fixed this bug when he was at it.

Before, OPTIMIZE TABLE hardly freed up any pages and to defragment you had to do a rolling restart of the data nodes.

Now, there is only a 2% discrepancy between OPTIMIZE TABLE and doing a rolling restart. This is great stuff.
This will fix will make it into 6.3.26 and 7.0.7.

See below for details:

Creating two tables, t5 and t6:

CREATE TABLE `t5` (
`id` varchar(32) CHARACTER SET utf8 NOT NULL,
`name` varchar(32) …