Week 9 (21st – 28th July)

Key Accomplishments Last Week

1. Read about the mysql Benchmarking suite and the importance of this suite for mysql.
2. Covered the chapter on Debugging in “Expert Mysql” by Charles A.Bell.
3. The chapter on debugging helped me to get to speed to debug mysql source code on Windows using Visual Studio
4. I also practiced debugging mysql on Linux using ddd and gdb.
5. P.S. I would like to thank Brian, Collin and Leslie for their patience and support. If God wills, I should start some serious hacking very soon.

Key Tasks that stalled last Week

• 1. Installation of perl interface for executing the Benchmarking suite
     1. Have some issues with the DBD::mysql module on cygwin …

Week 9 (21st – 28th July)

Key Accomplishments Last Week

1. Read about the mysql Benchmarking suite and the importance of this suite for mysql.
2. Covered the chapter on Debugging in “Expert Mysql” by Charles A.Bell.
3. The chapter on debugging helped me to get to speed to debug mysql source code on Windows using Visual Studio
4. I also practiced debugging mysql on Linux using ddd and gdb.
5. P.S. I would like to thank Brian, Collin and Leslie for their patience and support. If God wills, I should start some serious hacking very soon.

Key Tasks that stalled last Week

• 1. Installation of perl interface for executing the Benchmarking suite
     1. Have some issues with the DBD::mysql module on cygwin …

One of the cardinal rules of writing web applications is to escape user-generated input with functions like PHP’s real_escape_string. This is a great rule, but one that can have a negative impact on your application’s performance if used unnecessarily. For instance, when querying data with an integer parameter that is passed internally (not [...]

Whitehurst is focused on growing Red Hat's top line; will open source purists cheer him on? READ MORE

I keep seeing this posts by some of the manager types on planet MySQL about how they or some other guy is worrying about open source vendors not raking in billions or are not stealing billions of money out of peoples pockets that should not be playing on the stock market and things along those lines. While I do agree that its great to see open source software flourish .. actually let me clear that up, why do I even care if open source software flourishes? I care because I think open source software enables a different kind of growth for society, one that is shared, one that lowers barriers, one that I feel is more in tune with a world at peace.

Of course I want people that take part in this to be able to provide themselves and their families a decent life. But the fact of the matter is, these people do not need …

The blog is now powered by a custom Django application instead of Wordpress.

Most of the URI's stay the same, only the feed address has changed. Be sure to update your feed reader if you want to read more about, well... stuff I do.

Comments now use django-threadedcomments, which enables the possibility of replying to specific comments and displaying them in a tree-like manner.

While migrating the entries and comments from Wordpress (Jannis wrote a little script for that, which works great with a few adjustments), I also took the chance to switch the database system from MySQL to PostgreSQL. There's no particular reason why I switched to Postgres, MySQL is still a good …

There are quite a few "tuning primers" and "my.cnf generators" and "sample my.cnf files" online. The ultimate tool for generating an optimal my.cnf is not a tool. It's a human with many years of experience, deep knowledge of MySQL and the full application stack, and familiarity with your application and your data.

I don't know exactly the percentage, but quite a few of the servers I take a look at have been "optimized" with some tuning primer or question-and-answer script that spits out "optimal" parameters for my.cnf.

Most of the time these servers are far from optimal. Sometimes the my.cnf parameters are extremely wrong, to the point of causing a severe performance penalty.

If it were as easy as writing a tool to do this, don't you think Maatkit would have mk-optimal-mycnf already? In my opinion -- as someone who knows very well the complexity of creating a good my.cnf -- it's practically impossible. Much harder than …

Here are the results for this poll, as described in my post some weeks back.

So in a nutshell (see the original post for more info), the question was what MySQL version people currently use in development. Turns out that 64% uses 5.0, 19% uses 5.1, and the rest is small fry. It's a fairly small sample anyway (like most polls), but still I find the 3:1 ratio fairly significant.

Traditionally, it's been the going thing to just use the latest MySQL development version for development, even in its very first alpha versions. MySQL 4.0.x was a fab example of that, as Jeremy Zawodny (then Yahoo), Peter Zaitsev, and quite a few others will remember. Where has that "we'll try it and report the bugs" gone? Is it just a matter of the market growing up and taking fewer risks, or is there something else going on, driving those choices?

…

Artistic license terms enforced by US Court of Appeal READ MORE

Over in Maatkit-land, Daniel Nichter and I practice test-first programming, AKA test-driven development. That is, we write tests for each new feature or to catch regressions on each bug we fix. And — this is crucial — we write the tests before we write the code.* The tests should initially fail, which is a validation that the new code actually works and the tests actually verify this. If we don’t first write a failing testcase, then our code lacks a very important guarantee: “if you break this code, then the test case will tell you so.” (A test that doesn’t fail when the code fails isn’t worth writing.)

Most of the time when I do this, I write a test, it fails because I haven’t written any code yet, and I then go do some kind of …