Yes, old news, but woohoo, big news. The Happy New Year is kicking off nicely. All the best for 2008!

Yes, old news, but woohoo, big news. The Happy New Year is kicking off nicely. All the best for 2008!

After I posted my idea about a pure PHP mysqlnd driver, I received an email from Ulf Wendel from the MySQL AB team who works on the mysqlnd driver. He told me I could post his comments since he doesn't have a Blogger account. I'll include his comments below in blockquotes and then I'll comment below that.Ulf Wendel writes:What is "native"?PHP and the Borg[1] seem to be relatives. Whenever a

So I was reading Nate's PHP tip, and it got me thinking; he's basically describing bayesian session validity checks - what an awesome idea![1]. Here are my list of possible 'items' to form the test:

• Login IP address
• Login location (gathered courtesy of GeoIP)
• Operating System
• Web Browser
• Time of Day
• Origin of requests (both HTTP_REFERER and REQUEST_URI)

I was thinking of how damn accurately you could identify some specific cases of fraud though:

• "I only login from work" (time of day is always 9-5, location is always the same)

Each bit of information becomes more relevant the more frequently it occurs exclusively (or exclusively as part of a set). The only catch is that I would also need to identify the patterns …

When I first heard about the mysqlnd project at the MySQL Camp in 2006, somehow I thought it was going to be 100% PHP code. I can't remember now if I was making an incorrect assumption or if they planned to write it in PHP but changed their mind.What we have today is a DLL that is a drop-in replacement for libmysql. This has a few nice advantages. It means the replacement library will be

This is a follow-up piece to an earlier rant:

We are hitting a few walls with a CouchDB deployment and both Damien and I are a bit puzzled. This posting tries to attract someone with a clue to help us out. Our problems might result from not understanding the documentation correctly, but with evidently inaccurate material, we stand little chance

Long story short: We’ve got it all sorted out.

Memory Hogging Spidermonkey

Sam Ruby relayed a hint by “a Mozilla Developer”. Invoking Spidermonkey with the -b parameter and a value of 1000000, we are able to keep the memory footprint constant. We haven’t measured how this impacts performance, though.

Crashing …

This is a follow-up piece to an earlier rant:

We are hitting a few walls with a CouchDB deployment and both Damien and I are a bit puzzled. This posting tries to attract someone with a clue to help us out. Our problems might result from not understanding the documentation correctly, but with evidently inaccurate material, we stand little chance

Long story short: We’ve got it all sorted out.

Memory Hogging Spidermonkey

Sam Ruby relayed a hint by “a Mozilla Developer”. Invoking Spidermonkey with the -b parameter and a value of 1000000, we are able to keep the memory footprint constant. We haven’t measured how this impacts performance, though.

Crashing …

This is a follow-up piece to an earlier rant:

We are hitting a few walls with a CouchDB deployment and both Damien and I are a bit puzzled. This posting tries to attract someone with a clue to help us out. Our problems might result from not understanding the documentation correctly, but with evidently inaccurate material, we stand little chance

Long story short: We’ve got it all sorted out.

Memory Hogging Spidermonkey

Sam Ruby relayed a hint by “a Mozilla Developer”. Invoking Spidermonkey with the -b parameter and a value of 1000000, we are able to keep the memory footprint constant. We haven’t measured how this impacts performance, though.

Crashing …

I'm getting in early, I had just started building my benchmarks for my talk on Amazon EC2 at the MySQL Conference and Expo next year when I discovered exactly why they say you need to run a test more than once; results can be completely unpredictable. Take for example the Sequential I/O performance on EC2, versus my home machine:



The first 3 tests were a 36G Seagate Raptor 10k RPM, a 160G Seagate SATA2 7200RPM, and a 320G Seagate IDE 7200RPM disk, running in the same machine I had at home. The last three were Amazon EC2 images. A few observations from these results:

• The char write test seems to max out my CPU (not on graph - see raw data), so that probably explains why it's consistent across all disks.
• My home machine is almost dead on consistent, whereas Amazon EC2 looks more like a roller-coaster
• The …

My first Podcast, yeah!

Early the a week I recorded a short introduction to CouchDB for PHP Abstract.

If you like to quote, or copy or anything (after all this is under a Creative Commons license), here’s the transcript:

CouchDB

CouchDB is a new database system that breaks with a lot of traditions. Prepare to be confused or even offended. While a lot is different from traditional data management systems, the core concepts should be familiar to you.

Try to forget, just for a moment, all you know about SQL, relations, replication and all simple and advanced techniques you use to solve your problems when it comes to data storage. Instead, remember the days when you were a beginning PHP developer (if you are a beginner, perfect). …