Wii Browser

Well, looks like the only browser for the Wii I got yesterday is the Opera based “Internet channel”, sold via the Wii Shop. Only around £3.50 (US$6 – 500 Wii Shop points).
Looks like the user agent string for it is “Opera/9.30 (Nintendo Wii; U; ; 2047-7; en)“. Doesn’t seem to render my main site with the margins nicely. Also a little jumpy on the scrolling around the page kind of thing. Shame Wii is only SD video output – you don’t fit a lot on the screen while remaining clear to read.
The Photo channel seems to be missing what I would call a killer app for the Wii – the ability to take a Flickr stream or other photo sharing site and do a nice Photo frame transition on it. Heck, how about:

  • Knows about night time, and can either “show black” at night, or just show the time at night in a user-choose-able colour (like, grey so the screen isn’t too light for a darkened room)
  • Can chose a stream from a location URL, perhaps with a query string one can define (eg, the WII console number, so from the server side you could serve up specific images to specific machines)
  • Pan and scan, cross-fade, dissolve, fade-through-black, fade-through-white
  • Chose a music track (MP3) by URL to fetch and play in parallel
  • User customisable text overlay on pictures
  • Optional time, date, weather forecast overlay on pictures

Acer Aspire Revo or Asus Eeebox B208?

Acer’s Aprice Revo takes no the Asus EEEbox range

The Settop market is heating up; Asus and Acer are both coming to market with Atom A330 dual-core (2 x 1.6 GHz) low voltage systems, with discrete graphics and HDMI output, amongst other interfaces.

I’ve been delaying buying one of these for some time, waiting for one to come along at the right price point. I want to run Linux on it; I don’t want to run Windows + Antivirus – that just kills performance. Asus seem to be doing all they can to now drop Linux from their range; Acer is still there, with their Aspire Revo single-core Atom 230 unit sitting around UK£149 — UK£159 (inc VAT, see Play.com).

The features are there; but if only it can break the psychological UK£100 barrier, it can then be an impulse purchase!

When the A330 dual-core units hits, it looks like that model of Aspire Revo will be up against the Asus B208 unit – but with the advantage that Acer is still selling a Linux based unit, so no Microsoft tax.

MySQL Query Cache: still waiting for duplicate query checking

Way, way back in 2005 (4 years and counting) I finally reported a bug into the then MySQL 5.0 about an issue I was seeing (often) on high volume sites where a single query, if not in the query cache, but spawned from two (or more) simultaneous threads would both be executed in full; this is instead of one execution, and then the query cache being populated.

Reference: Bug 15044, and WorkLog 1293.

I had been seeing this for… well, years before hand, but considered it to be “just me”. Since I filed that bug, others have come forward and said they have seen the same issue.

Now, with the Oracle/Sun merge, and Sun having shelled out to “purchase” MySQL, we see a miraculous MySQL 5.4 being drafted together. Its good; but it appears to be a simple crowd pleaser that should have happened years ago – integrate in some very popular performance improvements (notably from Google’s code repository). If code is being contributed, and it works, why wasn’t this done earlier? And if not earlier, why now? Smokescreen? Last ditch effort before the project is canned by its new owner? Of course, this has been circulating for a while; I’m not posting this later after that’s been in the news for a few weeks now.

What is interesting is the “Refactoring MySQL” project being discussed. Where does this leave MySQL 6 – a little abandoned from here. And then with MariaDB and Drizzle now forked and picking up attention (external to MySQL/Sun/Oracle), it seems the entire thing is just becoming a mess. Drizzel is supposed to be the performance version – but with the google patches being integrated, perhaps the core MySQL branded project is catching up?

What’s looking clearer is: Postgres. From my perspective, its worse for MySQL in Debian. Lenny (stable now) has MySQL 5.0. The Experimental repo has 5.1 (5.1.34), but this hasn’t even transitioned to Unstable yet!

Here’s what I’d like to see:

  1. Someone picks up Bug 15044/WorkLog 1293.
  2. 5.4 goes STABLE from MySQL/Sun/Oracle real soon now, with or without my pet qcache bug/feature – it’s a big enough win for multi-core systems as it stands
  3. Debian moves MySQl 5.1 from experimental straight to Unstable – can the mysql-server-5.1 package can coexist with mysql-server-5.0?
  4. Debian also adds, along side the MySQl 5.0 and 5.1 servers, the 5.4 into Unstable, and 6.0 into Experimental.