I'll be giving a condensed version of my Next Generation Data Storage with CouchDb-talk next sunday (26.08.2007) at FrOSCon. The fine folks of the PHP Usergroup Dortmund got assigned a room to present all things PHP over the weekend, including a set of presentations. This is where I talk, this is not the main presentation track of the conference.

Condensed, eh? — Yeah, In Dortmund and Zurich before, I had plenty of time to talk and …

A

Tonight i thought it’s time. It’s time for an upgrade for my lovely Dynamic Web Pages ;) Facing the latest stats from nexen.net, that only (already) 20% of all php-sites are running PHP5 and facing the end of life announcement of PHP4 on php.net and all those activities going on (i.e. the go-php5 initiative), i thought it’s really, REALLY time for it. So, get up and start fetching the sources … php.net … and …. oh, getting hands on, i thought migrating MySQL is a good idea, too - so let’s switch from 4 to 5 (yes, ofcourse the Community Edition ;)).

Two hours later (and remembering that …

A

A

This is a small trick and it is, conceptually not new. It is common practice to add version numbers to resource files of a website. These are image-, CSS- and Javascript files. The reason to do so is to make sure users do get new versions of the files when you change them instead of when their browser decides to flush its cache. And you certainly don't want to tell your visitors to do a shift-reload for each small update you do. So you could do something like

    <script type="text/javascript" charset="utf-8" src="prototype1.50.js"></script>

and update the version number whenever you change things. This is a maintenance nightmare, though, because you'll have multiple versions of the same file lingering around next to each other and all the beauty of version control (You do use it, right?) is lost.

What you can do instead, is adding a GET-parameter to the filename, like this

A

They did it

The order had been delayed. Shipping should now happen somewhere in September. Two more months?! Amazon had to be kidding. I want that book and I want it now. Or tomorrow. Or before the weekend — BUT NOT IN SEPTEMBER.

This was last Wednesday and my shouting must have been heard. I got a mail later that day telling me my order had been shipped. Nice. It arrived on Thursday afternoon, good job Amazon.

The book is a full 209 pages including index and glossary and I love the index: It has soaking and NIH and freakouts and Spiderman. Rands has quite a vocabulary, a vocabulary that is perfectly suited for a …

So, I had written a while back: “We currently have a DataMemory of 4GB and IndexMemory of 2GB. Based on the crude methods we have to monitor it, I think we are at about 40% capacity.” Boy, I was wrong.

After that post, I started looking at this more in detail because we were considering buying more RAM “just in case”. I figured out how to use the super secret command “all dump 1000″. The command is not documented in the MySQL documentation that I could find. I did find it in the NDB API documentation before writing this post however. Not sure why I could not find it before.

For those that still don’t know how to use it, simply type “all dump 1000″ from your management console. Then check your cluster log files …

I hereby declare what from now on shall be known as “Jan's Law”:

Whenever a discussion about storage systems arises, the proximity of discussing the amounts of adult content that fits onto such systems reaches one.