We've begun writing the second edition of the now-classic High Performance MySQL. "We" means co-authors Arjen Lentz, Baron Schwartz, Vadim Tkachenko, and Peter Zaitzev. O'Reilly is still the publisher, and Andy Oram is still the editor. With a team like this, I think the second edition will be a book you don't want to miss. Though in theory we're revising the first edition, the truth is we're starting from scratch and re-writing the book, and significantly expanding it at the same time. A lot has changed since Jeremy and Derek wrote the first edition. Today's MySQL deployments push the limits further than many people thought possible a few years ago. We'll teach you how they do it.

RPM packages for innotop, a flexible and powerful MySQL and InnoDB monitor I wrote, are now available through the openSUSE buildservice, which builds RPMS on several platforms: http://download.opensuse.org/repositories/server:/database/Fedora_Extras_5/ http://download.opensuse.org/repositories/server:/database/Fedora_Extras_6/ http://download.opensuse.org/repositories/server:/database/openSUSE_10.2/ http://download.opensuse.org/repositories/server:/database/openSUSE_Factory/ http://download.opensuse.org/repositories/server:/database/SLES_9/ http://download.opensuse.org/repositories/server:/database/SLE_10/ http://download.opensuse.org/repositories/server:/database/SUSE_Linux_10.0/ http://download.opensuse.org/repositories/server:/database/SUSE_Linux_10.1/ Thanks to Lenz Grimmer, SUSE Linux, and Dr. Peter Poeml for making this happen.

Imagine you and your friends have a project and a website each. You are likely to look for ways to increase the number of visitors on your site that are actually interested in your project. And you don't want to spend a lot of money on it. Additionally, you probably don't mind helping your friend's projects along the way (since you have been blogging about it anyway).

Suits you? Thought so. Read on, this is for you. Ad Mates revives the old idea of web-rings (remember 1997?) and gives it a modern polish as well as fundamental change in thought. It works like this:

• You all join a group (signup is free),
• create advertisements for you projects,
• add a bit of code to your websites and
• Boom, you show each other's ads on your sites.

So far so easy, but why is this noteworthy? Because Ad Mates is based on the idea of …

Yesterday I attempted to get a working MySQL environment to support the number of utilities we all use including mytop, innotop, mybench, mysqltoolkit. These products require a number of Perl Dependencies, and while that may be a rather trivial task under Linux and with the power of cpan, working on Solaris is a whole different story.

For the record, I’m working with Solaris 9 SPARC 64bit.

I won’t detail you with how hard it was to get to this point, except to say thanks to Jeremy, Baron and Frank so far. Here is where I’m at.

You need a number of pre-requisites, most from …

One of the frequent requests we've heard from MySQL customers in the last year is the need for more certified DBAs. That's one of the reasons we kicked off some seminars earlier this month to help train Oracle DBAs in MySQL. According to the IOUG more than one third of the Oracle users are also running MySQL. But as with any new technology, they don't always have the in-house skills they need. So we did a test run of a couple of "DBA Bootcamp" seminars in New York and San Francisco to train Oracle DBAs in how to use MySQL.... READ MORE

The titles of the videos look very much like “must watch”. Found via ThinkPHP, thanks.

Vadim asked me yesterday to update Microslow patch for 5.1.21, because the previous one I wrote for 5.1.20 failed to apply correctly on the new MySQL release. Imagine the expression on my face after I unpacked the sources and found out that MySQL incorporated the patch to their release. So it’s a built-in feature now in the 5.1 line. So far I noticed one addition to my code which is logging the microtime statistics into TABLE type log storage.

Maciek

Novell reports earnings. Linux Foundation issues statement on OOXML. Free Software Foundation unites with environmental and social causes. (and more)

Novell Reports Financial Results for Third Fiscal Quarter 2007, Novell (Press Release)

Linux Foundation Statement on OOXML, Linux Foundation (Press Release)

Environmental and social justice groups unite in support of free software, Free Software Foundation (FSF) (Press Release)

ActiveGrid Teams with MySQL on Microsoft Access Application …

For a start, you shouldn’t be using a web forum. Are you too stupid to use email or what?

Ask yourself, does your question boil down to “pls do my job 4 me. kthxbye” (because it’s in stupid speak because it’s an obviously stupid question to be asking). If it does, don’t post it. Instead, RTFFM (where F is for Fine…. at least one of them is anyway), look at the archives. You will then find approximately eleventy-billion messages pointing you to exactly the right tool and docs to let you answer your question - easily.

We’ve begun writing the second edition of the now-classic High Performance MySQL. “We” means co-authors Arjen Lentz (formerly of MySQL), Baron Schwartz (that’s me), and Vadim Tkachenko and Peter Zaitzev, both formerly of MySQL’s high-performance team and now partners at Percona, a high-performance MySQL consultancy firm and host of the popular MySQL Performance Blog. Neither of the first edition’s authors (Jeremy Zawodny and Derek Balling) is working on this project, but they’re with us in spirit, I think.