Final versions of High Performance MySQL, Second Edition sample content are posted at the official website. You can download unrestricted PDFs of the foreword, table of contents, chapter 4 (Query Performance Optimization), and the index.

PDF, Sample Chapter

KEY ACCOMPLISHMENTS LAST WEEK

I set up and started using Acunote. Have to admit it is a really great project planning tool. Also I created two accounts for Mark and Colin so that they can track how the things are going any time they want and probably leave comments. I encourage everybody to try it out. Moreover the service is absolutely free and has no limitations for GSoCers. All you have to do is sign up here - "http://www.acunote.com/open-source/summer-of-code-howto".

I set up Bazaar version control system and hosted project on Launchpad. As soon as there would be the first stable version available everybody could get the source code. To do that you will have to issue one simple command - "bzr branch …

Mike Olson sold his open-source database startup, Sleepycat, to Oracle and earlier this year left Oracle to spend time with family. The family, however, had other plans and has booted him out of the house. "Get a real job, Honey!" were the words his wife used to chase him from the house, eyewitness reports reveal.

Well, Mike hasn't managed to get a real job just yet, but he will be spending some time with Hyperic, a leading open-source IT management company. According to Javier Soltero, Hyperic's CEO, Mike will be "helping us develop the next generation of killer products."

I pressed Javier for more detail over IM, and he offered up this lame response:

...

This is a loose translation from Japanese version.
Further optimized version of the pull model can be found here.

It is quite a while since Twitter has become one of the hottest web services. However, a time-based listing of your friends updates is not a unique function of Twitter. Instead, it is a common pattern found in many social web services. For example, social network services provide time-based listing of your friends' diaries. Or social bookmarks have your friends' list of bookmarks.

What Twitter brought into attention is that implementing a friends timeline in an optimal way is not an easy task. …

Bug fixes:

* The new version 3 release of Mozilla Firefox (now in RC) had a flickering issue with MONyog and the login page did not load correctly in that browser version.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

I've accomplished quite a bit in the last week.
On top of my day job, I cleaned out my basement, fixed my car, and got Xen working on my server.

As for the project, I feel I have a solid understanding of how the current cache works and exactly what needs to go into the interface. I'm a bit worried about the invalidate_by_MyISAM_filename stuff because I'm not familiar with the storage engine code, but everything else appears to be smooth sailing.

I've solved the interface problem I was researching: by avoiding it completely.
An interface in comments alone is sufficient at the moment with only two cache backends, a simple #define can switch them at compile time without any performance hit. This can fairly easily be improved upon by future developers so long as I document appropriately.

I've got a skeleton Query_memcache class going with all the necessary methods defined and commented with …

MySQL’s TRUNCATE statement will evolve over the next few years, as we fix bugs or strange behaviours, and as we try to make storage engines more consistent with each other. Equally interesting are the aspects that will remain the same, as we confirm that our behaviour conforms to standard requirements.

Define TRUNCATE

TRUNCATE T has two definitions:
(1) it means “delete all rows in T”, as the MySQL Reference Manual says in section “TRUNCATE Syntax”. (2) it means “drop T, then create it again”, as the Reference Manual says later on. The better definition is (2). I have proofs.

Proof #1: The required privilege for TRUNCATE is DROP.

Proof #2: TRUNCATE does not cause activation of DELETE triggers. For example:
CREATE TABLE t (s1 INT);
CREATE TRIGGER t_ad AFTER DELETE ON t
FOR …

Hi !

The 2nd Weekly Seminar was held on June 6 in MySQL Seminar Room.  The seminar was divided into two parts and focused on MySQL products in terms of both technical and business.

Introduction of MySQL Enterprise products

In the first half of the seminar, Kajiyama, MySQL Technical Evangelist, introduced “MySQL Enterprise” of one-year subscription which includes “MySQL Enterprise Server” that has been improved by many additional tests, “MySQL Enterprise Monitor” that enables to monitor multiple MySQL servers from a single console, and technical support and knowledge base of more than 2000 technical articles.

Also, demonstrating the Enterprise Monitor, Kajiyama explained how to use and customize advisor functions which help you handle in the event of a trouble.

…

Final versions of High Performance MySQL, Second Edition sample content are posted at the official website. You can download unrestricted PDFs of the foreword, table of contents, chapter 4 (Query Performance Optimization), and the index.

Its facinating to see what a couple of years development and bugfixing work upon MySQL has unwittingly done to the free space on my main G5 PowerMac at home. I have captured a screenshot from GrandPerspective and as you can see, the largest file on my hard disk is the MirrorAgent.crash.log file, and all those pretty blocks on the left hand side of the window: They are all coredumps. A few swift