As you may already have seen announcement by Baron we're working on major rewrite of High Performance MySQL book - the most famous book about MySQL Performance on the market... which is getting old though. We've been slowly working on the book for over half a year now and were later joined by Arjen Lentz and Baron

I think we make a great team and will be able to provide great in depth book on MySQL Performance topic to the market. Me and Vadim have great internals insight and a lot of practical experience in MySQL Scaling and Performance Tuning but our Russian-Ukranian English needs a lot of editing and we're far from experts writers plus we're quite busy doing …

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. Thanks to Lenz Grimmer, SUSE Linux, and Dr. Peter Poeml for making this happen.

Even after working with MySQL for quite a long time, I sometimes stumble over great things that I didn't know. It happened to me again when I met Beat Vontobel (together with other MySQL folks like Giuseppe, Roland, Lenz, Susanne) at the FrosCon Conference.

What I learned about was the init_connect system variable. It allows to trigger a SQL statement (or Stored Procedure) whenever a new user that doesn't have SUPER privileges connects to the server. There's no need for me to explain this in large detail, since Beat already did this in one of his blog articles.

Why is it so …

One good news, one bad news - that’s the frank way we blog about mysqlnd. The last posting on significant memory savings (40%) and new tuning options was good news. The bad news: mysqlnd might have bugs. How to report and debug these bugs - using mysqli_debug() - is subject of this posting.

Where to send mysqlnd problem reports, how to contact

Due to a low feedback rate - which is disappointing in a certain way - we are in the comfortable situation that you may report issues or ask questions on pretty much every channel: on the mailing list php@lists.mysql.com, on http://bugs.mysql.com/, on http://bugs.php.net/, by private mail (georg/andrey/uwendel at mysql dot com) or even using a blog comment. Of course, …

One good news, one bad news - that’s the frank way we blog about mysqlnd. The last posting on significant memory savings (40%) and new tuning options was good news. The bad news: mysqlnd might have bugs. How to report and debug these bugs - using mysqli_debug() - is subject of this posting.

Where to send mysqlnd problem reports, how to contact

Due to a low feedback rate - which is disappointing in a certain way - we are in the comfortable situation that you may report issues or ask questions on pretty much every channel: on the mailing list php@lists.mysql.com, on http://bugs.mysql.com/, on http://bugs.php.net/, by private mail (georg/andrey/uwendel at mysql dot com) or even using a blog comment. Of course, …

I picked this story up from Kevin Burton's feedblog. It turns out that last week, Greg Stein, director of the Apache Foundation was mugged outside his home in Mountain View. Greg was already on crutches at the time so this is a double whammy. Kevin organized a paypal account to for donations raising more than $2500. That money will go towards getting Greg a little R&R in Tahoe or Big Sur. Nice work, Kevin. Greg, get well soon! We'll send over a MySQL care package or some meals or some tech support. Whatever helps you get back on your feet.... READ MORE

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 …