A lot of people seem to spend a lot of effort comparing storage engine in MySQL - chiefly focusing on the difference between MyISAM and InnoDB.

People normally compare:

Feature sets:InnoDB: better durability, transactions, MVCC, foreign key constraints, row-level locking. MyISAM: fulltext, spatial indexes, table-level locking
Run-time performance: (see your favourite benchmark)

But few compare actual storage space usage. As this is very important to our application, I decided to run some tests.

I'm testing here with a realistic-sized table for our application (we partition data into daily partitions and spread them across many servers anyway, so this is just a small piece). We currently use MyISAM, and this is a typical table with approximately 4 million rows.

I can't dump the schema or content of this table here for confidentiality reasons, but it has:

On Thursday, the day before the long weekend (Friday being Good Friday, following week Monday being Easter Monday), the Melbourne MySQL Meetup group met, for an event that was not our usual meetup, but that of a Meetup Mashup.

Held at RMIT, I spoke about the recent purchase, what changes, what doesn’t, and how we’re 100% committed to making the same great product even better. After that, Gary Pendergast, spoke about how the support is run, and how nothing changes there, except its becoming beefier! We also had a Sun Campus Ambassador, Zhiqi Tao speak about the campus ambassador program, and how he evangelises Sun technologies at universities (his particular one, being Melbourne University). There is also apparently an RMIT ambassador, who missed the meeting.

After the talk, a pocket of us headed to dinner at the Oxford Scholar. There was much beer to …

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 …