MySQL Sandbox - More of a demo.

Applied Partitioning Scaling Your Database System - Sucks! I can find the commands in the manual.

MySQL Performance Under a Microscope - Nice and entertaining. Comparison of different techniques.

Query Cache Session - Interesting. Nice and clear presentation to a topic I usually misunderstood.

Benchmarking / Monitoring Session - So-so. Nice to see the different tools out there and speaker tries to give pro and cons.

Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played directly in your browser or you can download the 147MB .wmv file. (Please do not download the movie on the conference wireless system!)

I finally realized who Jonathan Schwartz reminds me of:

That’s right, comedian and magician Penn Jillette.

Schwartz started by saying, “enough of this free software stuff!” It got lots of laughs. He started to talk about Sun’s agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well — particularly that each engineer has his/her own opinion.

But Schwartz goes on in earnest to say “The …

There’s quite a bit of buzz on the blogosphere from people I respect a great deal, like Jeremy Cole at Proven Scaling and Vadim at Percona, about MySQL’s new Enterprise backup plans.  

The big deal?  They’re releasing a Community version that doesn’t have all the same features as the Enterprise version of Online Backup, including compression and encryption.  The Community version is open-sourced under GPL, the Enterprise version is not.

Personally, I think this is awesome. Don’t get me wrong – I love open source.  We couldn’t have built our business without it, and we love it when we get a chance to contribute back to the community.

But …

Firstly, I finally realized who Jonathan Schwartz reminds me of:

That's right, comedian and magician Penn Jillette.

Schwartz started by saying, "enough of this free software stuff!" It got lots of laughs. He started to talk about Sun's agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well -- particularly that each engineer has his/her own opinion.

read more

It is annoying when bloggers would write 'notes' about a presentation in the conference when all they are doing is just copying the presentation slides.

That is not note-taking since copying the slides doesn't make sense. Note-taking is giving insights to the presentation or adding / deleting information to certain parts of the slides.

My ears are tingling when I hear people typing on their keyboard and then later on would upload their 'notes' regarding the presentation. Instead they should stop what they are doing and just listen to the speaker and try to digest what he is saying.

Ok, this blog is currently hosted by 1and1.com, and I think that needs to change, which is sad, because up until recently, I’ve been pretty happy with the performance. However, I recently had an issue, and some things came to light about my package that I wasn’t aware of.

First of all, the maximum time a process can run is about 6 seconds. Second of all, the maximum number of processes you can have running at once is 12. When I asked if this was a limitation of my *package*, the answer I got was that it was a limitation of all shared hosting accounts.

This blog started throwing 500 errors some time yesterday. I called support late last night and some lady said that she was running a tool that should fix my issue, and to call back in 30 minutes if the problem persists. Well, I’m sick as a dog, and it was late, so I went to bed. This morning, the problem was still there. I called support 3 times today, got cut off twice, and …

Here are some more photos from the MySQL conference during the keynote sessions.  I've also posted some video on YouTube.com with clips from presentations by Marten Mickos, Jonathan Schwartz and Werner Vogels, CTO of Amazon.

Update: I've added some more photos and videos from Wednesday also.

Keynotes

The keynote was kick started by Marten Mickos.  If you've never met Marten, he is, on a personal note, one of the greatest CEOs I've ever met.  The keynotes were especially interesting for me because it was the first time I've had the opportunity to listen to Jonathan Schwartz, the CEO of Sun Microsystems.  Jonathan seems like a great guy who gives the impression he "gets it".

The last keynote was by Werner Vogels of Amazon.  His talk covered Amazon's growth and the new services they offer including EC2.  He announced that EC2 now supports persistent storage, which is a huge improvement, but doesn't quite solve all of the problems.

Testing PHP/MySQL Applications with PHPUnit/DbUnit

I've never been big into testing, but I'm trying to change that.  …

Yesterday, Oracle‘s Ken Jacobs and Heikki Tuuri, creator of InnoDB, have announced the immediate release of InnoDB Plugin 1.0 for MySQL 5.1. I’ve already downloaded it and played around with it a bit. I haven’t had time to do any performance benchmarks or similar just yet. Those will come in due time.

This release is the beginning of two exciting things: InnoDB is now officially decoupled from MySQL release-wise, and lots of new features have been added to this new release. I will come to what the decoupling means in a moment, but first, the major new features in this release of InnoDB (from my …

mysqlreport v3.5 has been released which has the following fixes, changes, updates:

• Fixed bug: incorrect checking of MySQL version caused mysqlreport to ignore InnoDB status values in some cases. Simplified version from 3 integers (major, minor, patch) to 1 (50024 = 5.0.24, 60001 = 6.0.1, etc.) for easier, more accurate version checking all around.
• Fixed potential bug: read_relative_infiles might have incorrectly divided infiles with multiple status value sets.
• Fixed bug: if wait_timeout was greater than –relative, mysqlreport would lose its connection while sleeping. Now the connection is closed and reopened for each live relative report collection.
• Infiles can now be given SHOW VARIABLES output (in addition to the old method of inserting values manually like: key_buffer_size=128M)
• Slow query …