/*
Function to free dboptions hash element
*/

extern “C” void free_dbopt(void *dbopt);

void free_dbopt(void *dbopt)
{
free((unsigned char*) dbopt);
}

Seems like more secrets are being let out of the bag. MySQL Enterprise provides support for Memcached - a distributed memory-based caching system, and I've been asked to present a webinar discussing how we've used memcached in the MySQL.com architecture.

Once again it may come as a surprise that the MySQL.com websites have been using memcached well before MySQL started providing support. We were starting to have growing pains, with now 20 million page impressions and 3 million visitors per month, and needed to figure out how to effectively scale without throwing heaps of hardware at the problem. Memcached was a perfect solution and gives us a toolkit that is easily integrated into our …

Over the past few weeks (years really) there has been some discussion on sharding. Instead of discussing when sharding is required, as there are good discussions on this already, I want to discuss how I would like to have sharding implemented in the database.

I want the database to handle sharding automatically, and where it can't be automatic, I want the database to help as much as it can.  Just like I want my business logic in a language ideally suited to it, and not stored procs (generally, there are always exceptions); I want all my physical persistence to be handled by the place that already does most of it, the database.  Having the database handle some of the physical persistence and the object relational layer handle the sharding logic isn’t ideal to me, and not just because the current object relational layers don’t have all the sharding functionality I want.  So here is what I want my database to do.   …

Ok, here is something I wish I could travel back in time and shoot who ever decided it would be smart to make RDBMS locale dependent. As in crap like different decimal separators or worse yet date formats. If at all leave this work to the client, but better yet leave it to the frontend. Today I went through a bit of work until I finally figured out that in order to have SQL Server understand an ISO date (running against a DB configured as German), I needed to set the dateformat in the connection session with a query like "SET DATEFORMAT ymd". You might be wondering about the fact that "ymd" doesn't look very ISO date, but all it actually tells SQL Server is that the numbers between the separators are to denote year first, month second and day third. What really ticks me off though is that I once again forgot to look at the number one source for making RDBMS …

So it's been a year since we were all sitting thunderstruck in the ballroom of the Swan and Dolphin Hotel in Florida as Marten announced that we were being acquired by Sun Microsystems. To be honest, normally with these things people say it feels like "ages ago", in fact for me it feels like it just happened yesterday and it feels like we're only getting started.

One of the coolest things about Sun and the combination of Sun and MySQL is that Sun is a technology oriented company with some incredibly bright people who are there to come up with neat technology stuff during their waking hours. In some ways, that's very much like MySQL. After all, we build technologies that drive other technologies and business.

For the last year people have talked about how MySQL has been affected by Sun. But you know, influence is a two-way street. Former MySQL-ers (now called Sun Dolphins) are spread throughout the organization outside of …

A cloudless night sky is truly amazing, but have you expected to see a dolphin in the sky?



What you see here is the Summer Triangle (all Southern hemisphere residents, please apologize), but did you notice the group of stars left to Altair?



This group of stars is the constellation named "Delphinus" (as can be guessed easily, it's the Latin word for Dolphin), which can be observed best at almost all latitudes around late spring and early summer (in fact it can be seen almost around the year, but that's the time of the year that you find this constellation highest in the sky).

So what is this all about? You may have heard that 2009 is the International Year of …

A user recently asked: What kind of approaches and techniques can you employ to become familiar with an existing database if you are tasked with supporting and/or modifying it? How can you easily and effectively ramp up your knowledge of a database you have never seen before?Here was my reply:The first thing I do is create an Entity-Relationship Diagram (ERD). Sometimes you can

If you are trying to transfer your connection details for Query browser or Administrator from one computer to another then follow the instructions described in this tutorial.

You may need to know about your kernel version number to install some software on your machine. You can use the instructions described in this tutorial to find the kernel version number.

PHP provides several functions that depend upon the version number of PHP you are running. In situations, where you want to find the version number of PHP installed, you can use the following techniques.