I was reading this morning, and came across a passage that really struck me: we are free to act, not to be acted upon. This jibes perfectly with what I've been reading in William James. Freedom is in action, not in waiting for others to act upon us.

In the open source world, many companies treat open source as a ball-and-chain to be endured (for the marketing benefits of saying they're "open source"), rather than as a tool that gives them essential liberties and advantages. Open source is a tool, even a weapon, for MySQL, Red Hat, and others. It's a cross to be borne by others. This is reflected in their licensing: open source, but not too much.

(Incidentally, this same phenomenon shows up in all aspects of software. …

Is 15815 fixed for 4.1.23 community edition?


Paul DuBois may have indicated that in the bug report. Getting details soon.

Update: Got the official word that the patch will be provided to the community, but you will need to build and test mysql yourself.

Congratulations to Warren Young and the other developers that maintain the MySQL++ C++ wrapper around the MySQL Client libraries: version 2.2.0 has just been announced and boasts a wide range of changes. Here's a description of MySQL++ from the project web site:
MySQL++ is a C++ wrapper for MySQL's C API. It is built around STL principles, to make dealing with the database as easy as dealing with an STL container. MySQL++ relieves the programmer of dealing with cumbersome C data structures, generation of repetitive SQL statements, and manual creation of C++ data structures to mirror the database schema

I will be at the big anual MySQL conference end of April. This means I will meet with a lot of coworkers, students and customers, friends and many new faces. Lots of new stuff to learn. But I will also work over there.

First of all, we will deliver lots of certification exams, MySQL 5.0 for administrators and MySQL Cluster. Sarah and will give each a 3 hour session to prepare candidates for the DBA exam. We will also be around to answer any questions on certification in general.

Then, I will also give two 45 minutes talks. One will summarize my students' wishlist for MySQL features, the other will be about the Blackhole Storage Engine.

As many of you know 4.1 does not have the thread bug fix as mentioned in this post. So, throwing a new mySQL server into production can cause a spike of threads that exposes this bug. Why? Well, for the most part INNODB has not filled its buffer pool for the most part.


For example, assume you have a box with 16 GB of ram, running 64-bit Linux. Let's look at MySQL when it first starts.

Here is some sample output from top

top - 18:46:22 up 400 days, 22:30,  3 users,  load average: 0.65, 1.08, 0.73
Tasks: 132 total,   2 running, 130 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.7% us,  0.5% sy,  0.0% ni, 92.2% id,  6.5% wa,  0.0% hi,  0.2% si
Mem:  16253552k total,  3406008k used, 12847544k free,    79364k buffers
Swap:  8388600k total,      160k used,  8388440k free, …

TIP: If your UPDATEs on a read intensive environment are taking as much as 1800 seconds, and if you can afford it, try using UPDATE LOW_PRIORITY ..., it can help!

You can also restart MySQL server with --low-priority-updates to make all UPDATEs low priority.

Or, you can make your SELECTs HIGH_PRIORITY.

BTW, does any one know why my last post about MySQL performance tuning went missing on Planet MySQL?

A couple of bug fixes pushed into the team trees. It appears that Valgrind can have a race when signalling condition variables while not holding the mutex. I should get some rest - having to stay up for European hours can be quite exausting. The company-wide conf call was mostly uneventful except for a small number of people who seemed unable to mute their connection. Hopefully, next time MGM will use the "lecture" mode and ensure that all other participants are quiet: It was quite hard to concentrate with the errant echos and other noises.

Liberty Alliance Announces openLiberty Project, Liberty Alliance (Press Release)

GroundWork Exits 2006 with Phenomenal Growth in Revenue and New Customers, GroundWork Open Source (Press Release)

OpenClovis Ends Calendar Year 2006 on High Note, OpenClovis (Press Release)

Pentaho Announces Significant Customer Adoption in Q4, Pentaho (Press Release)

…

MySQL backups are essential to running a site with MySQL backend. Generally you can get away with doing nightly backups but on our site, due to couple issues we had in past, we are forced to do hourly backups of our db. Intially I was doing backup by using: mysqldump dbname > weekdayHour.dbname.sql hourly. [...]