The modular concept of MySQL that separates the storage engines from the SQL parser and optimizer has recently caused a number of new, independently developed storage engines to surface. Here's an incomplete selection of projects around this concept:

• DDE - Distributed Data Engine, a research project of the Technical University of Dresden
• mdbtools - a storage engine that allows readonly access to Microsoft Access .mdb database files
• PBXT - a new, transactional storage engine by Paul McCullagh
• ritmarkFS - a storage engine that represents the content of a directory as a table
• …

Last Friday, my mentor from the university came to visit Imtech ICT. To explain him what the project is all about, I gave a short presentation. The presentation contains some of the elements that are also present in the presentation that I posted on the 29th of May, but this new presentation focusses on the project instead of the product.

I'm sorry English readers, this presentation is in Dutch.

The presentation can be downloaded here: Kennismaking

Blog: http://sqlbusrt.blogspot.com/

Project website: http://sqlbusrt.sourceforge.net/

I'm a big fan of the Working Daze comic, but I certainly hope that this comic is indicative of the majority of our users

read more

Hello,

Thanks for stopping by.

I have decided to set up this blog in order to collect, catalog, and contribute to, all things related to MySQL Cluster (and some that are not) floating around the web.

Count on this blog to be a clearing house of sorts for any and all information, how-to's, interviews, tips, news, feedback, gossip and happenings as they relate to MySQL Cluster.

I guess I should add the disclaimer that I am the product manager for MySQL Cluster...so I've got a bit of a personal interest in the subject matter.

Check back for additional content in the coming days, weeks and months.

Thanks for your interest,

Jimmy Guerrero
Sr. Product Manager MySQL

I’ve recently written about techniques for archiving, purging, and re-indexing huge database tables. These techniques exploit both data structure and usage patterns. In this article I’ll develop that theme further, and explain how to write more efficient non-backtracking maintenance jobs when the update and insertion patterns permit. Motivation In my current employment, I’ve been optimizing databases for size, speed, and consistency. As part of my regular monitoring, I checked our master MySQL server for deadlock information and found that a nightly cron job’s query had caused other queries to time out or deadlock, then became a deadlock victim itself and died, after loading the server for a long time.

I will be at FrOSCon 2006 on June 24, with a talk about Pivot tables in MySQL 5.
I will arrive in Sankt Augustin on June 23, flying from Alghero Fertilia, Italy to Frankfurt Hahn, Germany and then driving to the conference site (travel plan).
The funny thing is that, when I booked my flight, I had no idea that I was about to get in the middle of the Soccer World Cup. Being no soccer fan, I realized this fact only when the media circus started and I could not avoid being informed. Oh, well, now I understand why it wasn't easy to find a hotel, even booking two months in advance!

The slides and the source …

I’ve had my blog at Free Software Magazine added the Planet MySQL syndication site.

Digg, for those who have been under a rock for the last year, is a technology web site that gives users the opportunity to rank news stories.  Think of it as a combination of social bookmarking and nerdly news.  Digg grew out of founder Kevin Rose's desire for a feature within Slashdot to let users vote on their favorite stories.  Unfortunately, Slashdot couldn't accomodate the feature.  Necessity (or perhaps envy) being the mother invention, Rose created Digg.com.  Digg raised $2.8 million in venture funding from Marc Andreessen, Pierre Omidyar and Greylock partners last year. 

Digg has continued it's rapid growth with nearly a four-fold increase in traffic in just over a year. It's daily page …