Log in

No account? Create an account
Recent Entries Friends Archive Profile Tags My wildlife photography
First things first: do we have any 8051 gurus in the house? I may well be wanting to pick your brains in the coming weeks, if so.. (alternatively, come along and pick up a full-time paycheck!)

Quite a wonderful Overheard in NYC entry, even if likely apocryphal. =:D

I really need to try tracking down more music from the Tanukis, and Tenfold Loadstar. Indeed, I've only heard one track by the latter, "Birdy" - a relatively mainstream piece, but just works nicely.

Amongst the things I'm most looking forward to bringing along to the new place (I've got one place keenly in my sights, but it remains to be seen what will come of the application - beautifully redone interior, with a pair of custom-sized black leather couches in the lounge, a kitchen I could get seriously busy in, a conservatory with all the afternoon lighting you could want, and even a modest garden with a barbecue alcove. Definitely somewhere I could enjoy coming back to and relaxing) are my media collection, keyboard (yay Logic Studio!), and tablet. Time may be in short supply now, but that kind of increased activity just sets off a cascade of little experiments and projects I'd like to try.. ^_^

And for those with literary leanings, the SL Book Fair 2008 will be held on Book Island and Publishing Island on April 25-27. "It's here again and this time bigger and better than ever! The 2007 fair saw 1400 visitors in three days, over 40 exhibitors and nearly 20 events. In 2008, we will be across two sims (eight times more land) with 50 exhibitors and 100 book related shops with around 50 events. SL Book Fair isn't just about books - exhibitors include writers, publishers, editors, bloggers and anything word related!"

MySQL 5.1 might hold modest gains for SL, too - plenty of bugfixes from 5.0, a selection of helpful new features, and a performance boost in the region of 20%.

Dinner - well, there were plenty of temptations in the supermarket - the jumbalaya looked quite decent, as did the king prawn masala - but I felt in more of a picnic mood, perhaps owing to the pleasant weather. Touring the cooked meats and prepared fish aisle convinced me..

Ham, marinated artichokes, a shellfish assortment, prosciutto, and Cornish brie, accompanied by a Westerham Brewery "Freedom Ale", dedicated to William Wilberforce, instrumental in the abolition of the British slave trade.

What need is there in describing it all? The British ham was excellent, suffused with a gentle honey sweetness and a juniper tang, and the demerera sugar in the beer complemented the moderately heavy maltiness and lingering Kentish hops beautifully. Even the bread was surprisingly good, even if nowhere near as vanishingly light as a genuine French baguette, with a strong crust. The brie, meanwhile, could easily hold its own against its more directly Gallic cousins, with the richness of flavor typical of Cornish dairy.

Is it any surprise I loved Ratatouille so much? ^_^

*full, happy bunny*
It's a shame that Linden made the poor decision to select MySQL in the first place. Their MySQL-based asset server has long been a source of frustration and now every time I log in, I get some debug message telling me of an item in my inventory that 'disappeared' from the asset server. MySQL is nowhere near as rock-solid as PostgreSQL. MySQL might be faster in a stock installation but PgSQL has far more configuration options that can make it run circles around MySQL in nearly any situation.
Oh, no question about it. The early developers could surely write a Stephen King-sized tome on how they'd design SL's internals if they knew then what they know now. 'Course, it's a hairy problem to address, given how crucial the ass-hat server is to SL's proper functioning - imagine the chaos if they tried transitioning and any kind of glitch occurred, whether a plain ole bug, or worse, something that would only make itself known in high load conditions.

The indication was that 5.1 will help scalability somewhat, so there might be a modicum of relief to be found there, assuming LL do make that switch. Of course, we're assuming they're not running something from v2 or so.. =:)

And then there's the two competing engines destined for v6, though I suppose it'll be at least a year or so until they're ready for prime-time, and likely a similar period before LL could feel safe in proceeding with another such fundamental change. Some good test rigs on the beta grid might help (indeed, I'd imagine they operate such already), basically emulating a busy av being given massive inventory, giving it away, and so on.
I just don't think MySQL 5.1 will be much better. I played with an early beta release of it for my little usenet 'aggregator' script which collected about 15gb of data. Both MyISAM and InnoDB engines produce a fixed number of files that infinitely grow and shrink as needed (well, except InnoDB which uses one file that grows but never shrinks, and occupies over twice the space that MyIsam does for the same data).

Partitioning is pretty handy, in special cases. It divides up a single table transparently into multiple tables based on an indexing criteria and it is entirely independent of the db engine (it works with MyISAM or InnoDB or Falcon). The limitation is that once you partitioned a large table into 10 partitions based on the value of 'id', if you were to query that table on some other key, it needs to scan 10 separate indexes. PostgreSQL doesn't need to do this since by default, it splits data across files no bigger than 1gb.

The Falcon engine was unusable in the beta release I played with as it crashed every single time I tried to import any significant amount of data into it. I'm sure that has since been fixed but the wikipedia entry still links to benchmarks from a year ago that show Falcon's performance trailing way behind InnoDB and MyISAM on many instances.

It shouldn't be complicated to transition from MySQL to PgSQL because MySQL only supports a small fixed set of data types, while PgSQL provides all of MySQL's data types and infinitely more. There are scripts that will automatically convert any MySQL dump to PostgreSQL. PgSQL has geographic datatypes and reclustering which could allow Linden to physically re-order all asset data on disk by it's physical in-world location.