Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with real tables so I've got the script and ran tests for MyISAM and Innodb tables on ext3 filesystem. Here is what I found:

The fragmentation we speak in this article is filesystem fragmentation or internal table fragmentation which affects performance of full table scan. Not all queries are going to be affected same way, for example point select reading single page should not be significantly affected - ie you may not be affected as bad as we show here.

Benchmarks were done using this …

It's Summer of Code time again -- a chance for students to do some real-world programming, contribute to an open source project, and earn $4500 over the summer. You have just one week, March 24 - 31, to submit an application.

Over on MySQL's Summer of Code Ideas page, I have listed some projects around MySQL Cluster and mod_ndb. They require some experience with C and C++. I'm hoping they will be great summer of code projects:

• 
  
• You get to work with Apache httpd -- the world's most popular web server since 1996, and a classic example of modular and portable software architecture.
  
  
• You get to work with cutting-edge technologies (like JSON, REST, MySQL Cluster, and Memcached) that will be more important a few years down the …

I have an issue I hope someone can help me with. I am generating RRDtool graphs (for Cacti monitoring templates for MySQL, which I'll release soon) that have up to 11 different metrics on them. With that many lines or areas on a graph, it becomes very hard to pick colors that are easy to see and easy to distinguish from each other. What's a good way to choose such colors?

During the recent days we had few announcements of people leaving Sun/MySQL - few days ago I've seen announcement by Ronald Bradford and now I see Antony Curtis followed. I know bunch of other guys which are considering to leave or stay.

I do not surprising - how much "better" Sun is compared to Microsoft or Oracle it is still huge corporation and some people just do not like to be small wheels spinning in the huge engine. As for me MySQL became too big couple of years ago so I left MySQL early.

However it is not only the size what matters - MySQL may be able to stay relatively independent branch, though large companies like Sun will still enforce complicated legal, …

Ask me a couple of months ago and I would have said that I was going to join Sun Microsystems after their acquisition of MySQL. Ask me two weeks ago and I would have said that I hope that things would work out.At the end of this month, MySQL as a corporate entity would cease to exist and the MySQL employees become Sun Microsystems employees. Except for me and a small handful of people: Today,

There is an interesting theory in psychology called the hierarchy of needs, which said that once people's basic needs such as food and sleep are fulfilled, they would turn to higher needs for love, self-esteem, and ultimately self-actualization.

I am starting to see a similar hierarchy of needs for enterprise software, both from general trends in the industry and from our experiences with the opentaps Open Source ERP + CRM system: As organizations satisfy their most basic software needs, they tend to go up the ladder and turn to "higher" and more sophisticated needs. This "enterprise software hierarchy of needs" seems to follow this …

MySQL MagazineApril 15, 2008Introducing Kickfire (http://www.paragon-cs.com/mag/issue4.pdf)

Welcome to the 89th edition of Log Buffer, the weekly review of database blogs.

Welcome, welcome everyone.

In writing this week’s Log Buffer, I’ve had a chance to sit down and read some excellent posts on all sorts of platforms. The depth and breadth of what’s available to house and retrieve data is astonishing.

Many of you who have read my posts will know that I’m a fan of vegetables. They are something most of us don’t eat enough of. Come on DBAs! I think we need to make a collective effort to get healthy. We need you to keep all these systems alive. I say this because I have a new found appreciation for the work we do day in and day out.

Six months ago my wife and I said hello to our baby girl for …

Ah, the perils of working in a shared, client environment. One client has us using a login that is not exclusive to us. I prefer using bash; the client is set to use zsh. This is not a problem in and of itself.

However, there is a section in the .profile that is causing me issues:

if [ -f /usr/bin/ksh ]; then
        /usr/bin/ksh -o vi
        exit
fi

So, “If ksh exists, run it with some options to edit history with vi-like commands”. Except what we really want is “If you’re using the ksh as a shell, . . . .”

So I added a modification, and now all is fine.

if [ -f /usr/bin/ksh ]; then
        if [ "$SHELL" = "/usr/bin/ksh" ]; then
                /usr/bin/ksh -o vi
                exit
        fi
fi

(not all my problems are MySQL related!)

Myself and Larry had the great pleasure in opening a new market the other week. The Philippines marked our fifth new market that we opened together, we anticipate more markets in the upcoming quarter in 2008. Our new Philippine partner, Touch Solutions, Inc., the authorized Philippine distributor for MySQL and authorized Philippine MySQL education center has joined the MySQL family in the Philippines.

Overall I would say that the full day event was a great success, standing room only. It was a great chance to meet not only the variety of community users but also enterprise customers. Anson Uy (32), the young and savvy business man is the …