Back in October I wrote about a student group I was sponsoring to create a new command line tool for Drizzle. The group wrapped up their part of the project (the term ended), and we now have a new tool called Boots! A few of the developers are still active in the project, and I’m planning to get involved more as well. We also have a couple students interested in hacking on it for Drizzle’s Google Summer of Code.

Boots is written in Python and aims to replace the the previous ‘drizzle’ tool (which was modified from the ‘mysql’ command line tool). It doesn’t support everything that the old tool has yet (like tab completion), but it adds some new features. For example, there are multiple ‘lingos’, or modular languages, that can be used to communicate with the …

At the upcoming MySQL UC, I have a BoF on Tuesday at 7 PM on the history of databases. One things that would be interesting to discuss there is NoSQL. Is this the next great wave? If you have read my Blog before, you know that I think this is not the case, although I do see the need and use for NoSQL technologies. But my main argument against it is that sacrificing functionality and general purposeness (if that is a word), is not how progress works. Performance increases in general, without the need to compromise functionality. But I may be wrong, it has happened before (at least I think I have been wrong before, but I'm not really sure).
But in addition to this, I'd like a general debate on database history. SQL has been around for a long time, but there are other technologies out there, most of them still around in some shape or form, at least on …

If you are coming to the MySQL User Conference, you might want to pop by the Computer History Muesum. The CHM is in Mountain View, jus off the 101. If you have a car, just take the 101 and get off at Shoreline, it's just on the east side of the 101. If you don't have a car, you can get there anyway, from the UC take the light railway to Mountain View and then you can walk (some 20 minutes or so, not the nicest of walks, across the 101, but it's possible, I've done it) or take a bus from Mountain View.

At the CMH, among other cool things, is Babbage's Difference Engine in working order, a mechanical computer. That Babbagewas a smart dude is obvious from the fact that he never finished building the machine, although he designed it, and when now built using his original designs, it actually worked! I mean, …

Percona will have 14 members of our team at next week's O'Reilly MySQL Conference in California. Drop by and meet us at booth 308 (for Percona) or 216 (for Maatkit). Bring your technical questions and problems to our experts. To make it easier for you to meet specific Perconians, check this Google calendar for when each consultant should be present at the booth. (Hint: use Agenda view.) We'll be talking at 23 sessions, tutorials, or BOFs. Check here if you want to see when Percona's speakers are scheduled to be on stage. We look forward to seeing our friends face to face each year in Santa Clara. Please introduce yourself and say hello!

Entry posted by TomBasil | …

Every so often I am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ?
MySQL distribution has a great script called mysqlbug which was supposed to be used for bug submission. I never have seen anyone using it for this purpose but it is great in providing information about current built. Especially you may be looking at "Configure-Command":

PLAIN TEXT CODE:

1. Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-low-memory' '--with-comment=FreeBSD port: mysql-client-5.0.67_1' '--enable-thread-safe-client' '--with-charset=cp1251' …

Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index for a traditional MySQL storage engine would take too long to be of any practical value. With TokuDB, however, an index can be created on the fly to accelerate any ad hoc query that would otherwise be causing a vastly slower full table scan.

Here are the details.

We've just launched training for London, Seattle, San Francisco, Atlanta, Orlando, Columbus, Dallas, San Diego, Denver, Minneapolis, New York City, …

I think most developers are able to cache database queries by now. But what about DML queries? Every query, connection - or in the general case - ressource needs time. So I thought a lot about how to write data as efficiently as possible into the database - in my case MySQL. Hmm...We have to take a closer look at the details and we can't choose the same asynchronously writing method for every kind of query. With kind of query I mean that it depends on what storage engine we use, the complexity of the query, should more than one record be written at once, are triggers involved and so on. Sure, the one or the other query MUST be written instantly, but most of the writing querys are stackable with no need to check if the request has succeed.

Read the rest »

I’m looking forward to traveling to San Jose for this year’s MySQL Conference. If there’s anything that can trump the drama of conf two years ago, where we observed how Sun would handle its new property, and then the drama of last year, where we observed how Oracle would handle the pending acquisition, it’s going to be the drama around this one — the first MySQLConf since the Oracle/Sun merger has been finalized and approved.

I think there is some finality to the changing of the guard this time, since there aren’t really that many companies that could conceivably swallow up Oracle itself! (Maybe I shouldn’t say that — next thing you know they’ll spin it off heh.) But regardless, I am looking forward to getting to know Edward Screven and getting a sense from the keynote and other communications exactly what he’s planning to … DO … with …

Brian Aker parted ways with the mainstream MySQL release, and with Sun Microsystems, when Sun was acquired by Oracle. These days, Aker is working on Drizzle, one of several MySQL offshoot projects. In time for next week's MySQL Conference & Expo, Aker discussed a number of topics with us, including Oracle's motivations for buying Sun and the rise of NoSQL.

The key to the Sun acquisition? Hardware:

Brian Aker: I have my opinions, and they're based on what I see happening in the market. IBM has been moving their P Series systems …