Download Maatkit

The December release is here! There are some goodies in this release, but the major one is an initial version of mk-log-parser, a slow log analysis tool that is carefully designed (with lots of input from Percona consultants) to make slow log analysis as productive and easy as possible. It’s based on a [...]

My father and I got our 5D MkIIs on Friday and we could hardly wait for the batteries to charge. He took his to SF to test its vaunted low-light performance and posted this 60-second 1080p clip (along with other resolutions) on his SmugMug site: Click to watch it auto-sized for your monitor or check out the full 1080p resolution (caution – *high* bandwidth! UPDATE: Apologies if you tried to watch 1080p on Windows earlier. My bug made it look terrible. Try again, please?).

Here’s his story:

“I had seen Vincent Laforet’s amazing short film, but only in 720p. I knew what an amazing photographer he is and wondered how close an everyman like me could come to footage like that. Could the clips …

Hi all,

Today I'd like to continue a blog series in which I highlight Web application tutorials for NetBeans 6.5. A few changes have been made to tutorials, among which is the featuring of MySQL as the database of choice.

This sixth entry in the series will cover the tutorial, "Performing Inserts, Updates, and Deletes (CRUD)".

This tutorial shows you how to use NetBeans IDE 6.5 and JSF 1.2 (Woodstock) components to build a web application that can create, retrieve, update, and delete database rows. The application provides a drop-down list of master data along with a synchronized detail table. Users of the application can add to, update, and delete the records in the detail table and from its associated database.

MySQL is the database used in this version of the tutorial.

This is the …

Ok, Yves pushed up two patches onto launchpad the other Day. I wanted to get a chance to fully test out the patches before blogging about them, and as I mentioned in my previous blog post, I have been dealing with some hardware issues. I spent the day testing out these patches, running them through the paces looking for potential slowdowns or issues, and everything looks good. I am going to limit this post to just the new features, as I am still finalizing a few benchmarks as I write this.

Whats new?

First the patches work against 5.1.30. I have been running all my recent tests against these without any issues so far ( knock on wood ).

Second you will notice 2 patches. There is a patch to memcached which will only work in 1.2.5 right now ( 1.2.6 changes how the memcached LRU queue gets …

With all due respect to Monty (and I mean that — much respect is due), I have some serious issues with his portrayal of the 5.1 release.  I hate to make my first entry on Planet MySQL about a controversy, but he encouraged people to blog about their experience with 5.1, so that’s what I’ll do here.

Overall Quality

As a long time user, I am very confident that the quality of 5.1 GA far exceeds that of the initial 5.0 GA release (5.0.15).  In fact, I would go further and suggest that the MySQL organization has if anything been too conservative about declaring 5.1 GA.

It’s obviously true that there are still many bugs open.  However no software is bug free, especially not those with codebase as large as MySQL.  So the question is not if they are bug free, but are the …

I moved all the QOT code to Launchpad. This includes code for the tool, tests and a small experimental utility qot-predictor, which based on query analysis tries to predict which queries are likely to be executed next. Project URL for branching is lp:qot. If you want to push your own changes just create a new project branch.

The GA announcement of MySQL 5.1 is coming, and for downloading, it’s already available, as I hope you have noticed from Giuseppe’s blog. We continue our preparations, this time by announcing Position 2 in the MySQL 5.1 Use Case Competition.

2. Guy Adams (Parallel Ltd., Milton Keynes, United Kingdom): Using Partitioning to Manage Satellite Networks. See Guy’s DevZone article.

Thanks and congratulations, Guy! I hope you too are in a position to take advantage of your free MySQL Conference & Expo 2009 Pass, including a dinner …

Hi all,

Today I'd like to continue a blog series in which I highlight Web application tutorials for NetBeans 6.5. A few changes have been made to tutorials, among which is the featuring of MySQL as the database of choice.

This fifth entry in the series will cover the tutorial, "Building a Tree From Database Data".

This tutorial shows you how to dynamically build a tree structure from data in a database. Using NetBeans IDE 6.5, you build a two-page application, the first page of which includes a JSF 1.2 (Woodstock) Tree component. You populate the first-level nodes in the Tree with names from a database, and the second-level nodes with the trips for that person. The trip nodes are links to a second page, which displays the details for that trip.

MySQL is the database used in this version of the tutorial.

When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The "average" is the evil of performance optimization and often as helpful as "average patient temperature in the hospital".

Lets set you have 10000 page views or queries and have average response time of 1 second. What does it mean ? Really nothing - may be one page view was 10000 seconds and the rest was in low milliseconds or may be you had every single page view taking 1 second, which are completely different.

You also do not really care about average performance - the goal of good user experience is majority of users to have good experience and average is not a good fit here. Defining your response time goal in 95 or 99 percentile is much better. Say you say 99 percentile response time should be one second, this means only 1 percent of queries/page views are allowed to take more than that. For larger systems defining …

MySQL 5.1 is now released as "GA".

In this blog I will try to describe my opinions about this release and also try to set the expectations right for anyone trying out MySQL 5.1 GA.

What should you then expect from MySQL 5.1?

• If you are using MySQL 5.1 just as a 'better' version of MySQL 5.0 and you don't plan to use any of the new features in MySQL 5.1 then you are probably fine to try out MySQL 5.1. You should however not put it into production without testing it fully, preferably by running it on a couple of slaves for some weeks. It may even be the best to wait for a couple of minor/patch releases before putting the MySQL 5.1 server into production.
• Don't expect …