Over a year ago I wrote about pretty nasty Innodb Recovery Bug. I ran in the same situation again (different system, different customer) and went to see the status of the bug... and it is still open.

You may thing it is minor issue but in fact with large buffer pool this bug makes database virtually unrecoverable (if 10% of progress in 2hours qualifies as that). It is especially nasty as it is quite hard to predict. Both customers had MySQL crash recovery happening in reasonable time... most of the times until they run into this problem.

So what is the point ? Have modest expectations about when your favorite MySQL bugs are fixed (This is actually Innodb one, so Innobase/Oracle is responsible for fixing it not MySQL/Sun but there are …

Here is my talk from LinuxWorld this year:
http://download.tangent.org/talks/Getting%20More%20Out%20of%20Memcached%20with%20Libmemecached.mp3

The Study guide I mention can be found here:
http://download.tangent.org/talks/Memcached%20Study.pdf

The talk is general in nature, but it does have some points on how to work with MySQL and Memcached in the same applications stack.

Yes, it has been too long since I last posted on this blog (3 months) - that's my apology; let's move forward.There's too many interesting MySQL bits and pieces that I still come across my desk that I cannot help but post these fantastic learning opportunities to my blog. Obviously, you can read about all things interesting from PlanetMySql.org, but I hope that my blog will help sift people

An MDM system allows a single, consolidated, presentation from multiple data sources. Mural brings the experience from JavaCAPS, and adds OpenSource and …

One of the sessions at DrupalCon I attended was Larry Garfield's talk about "Drupal Databases: The Next Generation", which gave me a good insight into the current state of the Drupal database layer and how they plan to overhaul it for Drupal 7. The key points that I took away:

• A new API based on PDO
• Object-oriented, requiring PHP5
• Support for using prepared statements
• A unified access API
• A query builder
• More support for other database systems (currently Drupal supports MySQL and PostgreSQL only). In particular, they are …

There are many times when I needed to find out my outgoing (or external) IP for the servers which are behind load balancers or firewalls.  I used to just login to another external server from the server in question and find out by looking at “who” what my external ip is.  Even though it works and I am so used to it, today I decided to figure out a more graceful way of finding my outgoing ip.  As most of us already know, whatismyip.com is the quickest way to find out your outgoing ip from the browser.  So I decided to use the same way on the servers.  So I issued a wget:

wget http://www.whatismyip.org

Well that does the trick.  But being lazy as I am, I did not want to have to cat the output file to find out the ip (plus there is no point of creating extra files and doing extra work to remove them).  …

The MySQL 5.1 Use Case Competition is in full swing - we've already received a number of cool and interesting submissions, which we will turn into articles that will be published on the MySQL Developer Zone over the course of the coming weeks. Today we received a note from Jakub Vrána from the Prague, Czech republic. He's the author of phpMinAdmin, a MySQL management tool written in PHP. Here's what he wrote:

In the beginning of September 2008, I have implemented MySQL 5.1 Events to the database management tool phpMinAdmin. I've used the Windows version of MySQL 5.1.26 for the development.

As phpMinAdmin …

I am tired of writing about Virtual Box, but they have given me an early birthday present.

Virtual Box 2.0 dropped today.  Now I have my 64 bit guests AND apparently the lockup under OS X was a VBox defect of some sort or other, because it does not occur under 2.0.

Now if only the Windows “AMD64″ installer (ie: for the 64 bit host) would execute I might actually be able to use this thing for something serious.  Either it dislikes Intel CPUs or dislikes 32 bit Vista; VMWare doesn’t care, and neither do I, so VBox loses again.

Why I'm switching to Google Chrome; hint: it's for the same reason that I originally went to Firefox READ MORE

O'Reilly Media has opened the Call for Participation for the 2009 MySQL Conference & Expo, scheduled for April 20-23, in Santa Clara, California.

Conference program chair Colin Charles and the program committee invite proposals for conference sessions, panel discussions, and tutorials. More than 2,000 attendees are expected to participate in over 120 sessions at next year's event.

Proposals can be submitted here. The deadline runs through October 22, 2008.

Co-presented by O'Reilly Media and Sun Microsystems, the MySQL Conference & Expo is the largest gathering of MySQL developers, users, and DBAs worldwide. The event reflects MySQL's wide-ranging appeal and capabilities. The open atmosphere of the MySQL Conference & Expo helps IT professionals and community members create the best database applications, tools, and software through expert …