Since our goal is to find a tool for profiling while we don't want to change/modify the existing code. So we chooses the Aspect-oriented C tool as the profiling language.

The basic idea is to maintain the profiling code separately, and then use Aspect C to weave the code into the original code automatically. For instance, if we are going to profile the I/O function pread, we can write the below code according Aspect specification. Then every time when pread is called, it will be executed.

#include
long pbxt_profile_pread_access_time;
long pbxt_profile_pread_freq;

int around(): execution(int pread(...)) {
struct timeval start_time;
struct timeval end_time;
gettimeofday(&start_time,NULL);

int val = proceed();

gettimeofday(&end_time,NULL);
…

It has gotten a bit quiet around the MySQL Proxy over the last weeks, but I can assure you it was worth it.

Here in my hands I hold MySQL Proxy 0.5.0. Not just some binaries, no everything with sources. As always it is dual licensed under the GPL and commercial MySQL license. We worked hard to get everything ready for the release: the wiki, the forums, the public SVN trees ...

The proxy can do magic. Put in your ideas and say the magic words and there ... it works. :)

The proxy is fully scripted now which opens up the proxy to your ideas. The possibilities are endless. I can think of at least of the following features:

• load balancing
• fail over handling
• query analysis
• SQL macros
• query rewriting
• .... much more

The proxy started as side project of me and is now evolved into a full MySQL project maintained by the …

After years of "No Call for Papers", and "How can I speak at Fosdem ?"

Now you can suggest speakers and subjects for the 2008 Fosdem edition so let's all fill in what we want at next years edition !

But what do we want, I guess we want a Scale the Web2.0 track with talks on MySQL , Apache, Loadbalancing, System Automation etc., don't we ?

This will be my last entry for a few days (probably more like a week).  I'm the scoutmaster of troop 440 and we're attending summer camp next week so I will not have much time available to email and blogging.  However, KISS #5 happened last night while I was activating my kids Vista computer.

The whole idea is that any message, error or otherwise, needs to be understandable by the average user.  This is the main reason why Linux will not get any serious traction on the desktop.  The gear heads that use it can't stand to dumb down the interface of their baby and the current Linux desktop experience is just to complex.  If the user has to know what a swap partition is or that a file named ifconfig even exists, then it's too complex.  But I digress.

So last night Katie (my daughter) tells me that her computer is broken.  Thinking that's odd since I just built it, I asked her what it's doing.  She …

jay pipes started with his five mysql wishes, and others have chimed in. i guess i may as well take a whack at it.

1. connect by. yeah, yeah. it?s not standard. i don?t care.
2. expose character-set conversions in the client library. all the code to convert between all of the character sets understood by the server is there, there?s just no public interface to it.
3. online backup. it?s in progress, but this will make things so much better in so many ways. we could actually have reliable backups of bugs.mysql.com. and it?s going to make starting up new slaves so much easier in replication.
4. re-learn how to ship software. the long …

I am subscribed to the memcached list. Memcached use (and interest in caching in general) has exploded it seems in the last couple of years. There are a lot of people that join the list that not only don’t have a lot of experience with memcached, but they don’t have experience with caching. We have been caching at dealnews since the beginning. We started using memcached at dealnews in early 2005.

One common concern that new users have is data not being updated the second it goes in the database. This is how it worked before they were caching. They are used to it working that way. So, when they start caching, they miss that instant gratification. We went through this at dealnews. Our content team could write a deal, go to the front page and see it right then. They could then move on with their lives. As we grew and it became apparent …

I've been highly gratified to see the response to this Open Source CEO Series. I've been impressed by the sincerity and wisdom most of the answers have revealed. Running an open source company at the beginning of the commercial wave is challenging.

Nowhere is this more true than with John Roberts, CEO of SugarCRM. I've known John for several years now, and can still remember first meeting him at an SDForum event (back in 2004, as I've described before). John, Clint, and Jacob approached me after I spoke on an open source panel and told me about their idea for an open source CRM company. I thought they were fools, because clearly open source wouldn't work in the application space.

Four years later, it's clear that I, not they, deserve the "fool" title.

In this eleventh …

MySQL AB today concluded its "Twelve Days of Scale-Out" educational initiative by presenting a case study on mixi.jp, the third most-popular Web site in Japan.

Each day from June 11-22, the MySQL Web site has been highlighting how many of the world's fastest-growing companies are using the MySQL database to cost-effectively scale-out their successful online businesses.

This is really too easy.  Finding stupid and idiotic things about Vista is really just too easy.  This installment is not about any type of GUI but rather with the lack of secure inter-machine remoting capability.

Here at MySQL we have several Windows virtual machines setup to perform builds and tests of both our server code and our connectors.  Our builds are automated to be sure but our build engineers still need to "shell" into a remote box to perform some functions.  As any reasonable group would, we use ssh authentication for both our Linux and Windows boxes.  The problem, of course, is that no edition of Windows has shipped with a secure shell server or client.  Our build team is left with only a few alternatives and they have chosen to install cygwin on the Windows boxes.  Considering that cygwin has only recently become stable on 64 bit systems, this was shaky at best.

Now I realize that …

There has been a lot of fuss kicked up lately over the definition of open source (kicked off by Michael Tiemann), and the OSI's role in defining that term. Word on the street is that CentricCRM will be launching a significant piece of code (Team Elements) under Larry Rosen's Open Software License early next week. This is fantastic news for CentricCRM, as well as for open source (OSI-approved open source).

Why for open source? Because Team Elements is cool and very useful technology. It's a 100% open source, Java-based "Enterprise 2.0" product. It ties together discussions, wikis, blogs, RSS, issue tracking and trouble-ticketing, project management, document management, and federated search into a single, unified …