Ramblings

• zlib stream format and O_DIRECT… fun #
• hungry #
• the O_DIRECT API sucks donkey #
• Ringu is possibly one of the spookiest movies ever. #
• Evolution is no better than before: 401MB RES and eds is 57MB #
• HELP
  HELP #
• /me tries to learn twitter bot… #
• does this even work… seriously… #
• djwptw #
• what the fuck is going on with this bloody twitter bot #
• seriously, what the fuck #
• does this bot even works #
• err… work #
• maybe it does now? #
• who knows…. #
• so Twitter obviously doesn’t think you may have Jabber *AND* Gtalk… #
• so…. accept meeting invite in Evolution… have it not appear when synced via SyncEvolution and Funambol to my phone.. *BRILLIANT* #
• i heart strace(1) #
• WHY #
• Amarok so slow in disconnecting iPod and quitting… #

Powered by Twitter Tools.

• mmmm…. House #

Powered by Twitter Tools.

So… stealing the idea from Peter, does anybody have any suggestions for MySQL Cluster related things to have at the UC next year (April)? Either leave a comment or email me (first name at mysql dot com).

Julie at Apress let me know that over at Bookpool: Practical MythTV: Building a PVR and Media Center PC they’re having a big sale of Apress titles, including Practical MythTV.

So over there now for (a bit) less than $15US you can get Practical MythTV. Pretty neat. So everybody should go buy two copies (buy one get one free… right? :)

At some point soon, I’ll even post how I go with upgrading my MythTV box to Ubuntu 7.10 (Gutsy)… once I gather up the courage to do so :)

1. If you have more than 8192 directories, it can’t monitor them (max inotify limit)
2. No search results
3. access(), stat() and then lstat() called on *every* file that it’s going to index… this takes a long time.
4. Did I mention that search doesn’t actually give you any results?
5. Even when you run strings on the database and then search for something there, you don’t get any results
6. Even when you search for the name of an application, you get no results.

So, I’ve upgraded two boxes: my laptop and my mail server.

Wrong:

• courier-imap-ssl broke. My cell phone could no longer pull mail.
  I got something like in the log:
  imapd-ssl: couriertls: connect: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number
  The fix for this is to change the TLS_PROTOCOL option in /etc/courier/imapd-ssl to SSL23 (an option not listed in the “possible verions” list in the config file). So mail now works.
• Evolution now seems to put a blank line at the top of emails when replying (before quoting the message). GRRRRRRR…
• The Window Manager (metacity) has changed how it arranges new windows. Instead of cascading them down, so if you’re opening a bunch you can easily switch between them, it now puts them right on top of each other GGRRRRRR.
• It set up my Xorg to *not* to X monitor hotpluggy goodness. I’ve managed
• Login seems to take a fair bit longer than before
• Tracker
  • trackerd will index while on battery power… GRRR
  • trackerd will hog disk and CPU
  • I haven’t been able to get any results out of tracker.
  • There is no tracker-status or something to check that it hasn’t just stopped working
  • Tracker will use up all your remaining disk space… (I initially only had a few GB free.. and trackerd filled it up)
  • I haven’t actually had a query work at all. i.e. it seems to be useless. I just get a “trackerd exited with status 0″.
• There is no “remember passphrase” button in Evolution for GPG signing anymore. I think this is now set in the global preferences… but the behaviour change is annoying.
• The pidgin icon is different than the gaim icon in the Notification Area… this is annoying as I can never find it anymore
• The Window List applet changed behaviour to now *not* group windows together at all… making having lots of windows open (as I often do) completely unmanagable as opposed to (previously) just annoying.

The Awesome:

• X monitor hotpluggy goodness (known to others as xrandr 1.2). VGA out works with the free radeon driver now! *YAY*. (I can rearrange screens using xrandr… awesome)
• Pidgin is quite nice… the likelyhood of reply plugin is neat. More compact IM windows (also cool).
• Syncing between Pidgin and Evolution with contacts seems to work okay now.
• Suspend and resume still works
• New version of f-spot - goodness!
• New OpenOffice.org (2.3)  sucks less.
• emacs22 (shiny)
• New WINE does real neat stuff (such as have menu items for browse C drive, remove software)
• Evolution doesn’t seem to leak memory as much anymore. Only 316MB RSS at the moment!
• Lots of neat Liferea bug fixes - much nicer! (read items in the planet.linux.org.au feed stay marked read now!)

I’ve decided to publish my patch series. The goal of the -stew patches is to collect things I find interesting and that at some point could (should) make it into the main MySQL tree (even if others don’t think so).

It’s not designed for use in production.. I don’t really care if there’s failing test cases…. if it builds it’s perfect.

It includes the following which could be interesting:

• Removal of ndb_use_exact_count (performance for NDB)
• NDB node status in an INFORMATION_SCHEMA table
• Compressed Backup and LCP for NDB
• Cluster log as CSV
• Skeleton Engine
• MyHTTP Engine
• PBXT Engine
• Skeleton of MyBS support for NDB
  • (in the hope that somebody finishes it)

Currently the additional engines have to be built separately in their storage/ENGINE directories. I have some preliminary patches to get them to build in-tree via the plug.in file, but it’s not finished (patches welcome).

This is all currently based off the 5.1-ndb tree. In future, it will likely be based off 5.1-telco.

 http://www.flamingspork.com/mysql/patch-5.1-ndb-stew1-20071016.patch.gz

and broken out in:
http://www.flamingspork.com/mysql/patch-5.1-ndb-stew1-20071016/
(including the not-quite-working ENGINE_in_tree_build patches)

Known to apply against this tree:

http://www.flamingspork.com/mysql/mysql-5.1-ndb-20071016.tar.bz2

Comments, thoughts, patches to include, all welcome!

I wouldn’t yet say “brilliant” but I’d certainly say “less crap”. I haven’t (yet) completely stabbed it for being stupid.

Today’s xkcd is just wonderful. I think we need giant ones of these on the wall of offices around the world.

I am very good at just staying up late to adjust to a timezone. I can do this fairly reliably. Going to the US and Europe can be done by this method (rather well). Coming back is another story though. Going to sleep at an earlier time (for me) doesn’t come easy. Grr…

Quick experiment with online changing of enabling/disabling compressed backups and local checkpoints (LCPs).

Backup is incredibly trivial and correct (even have some nodes do compressed, some not).

LCPs are a bit trickier when it comes to restore… currently how the code sits is that a block using the compressed file interface in NDBFS must specify if it wants to use the compressed read/write interface or not. So when you have LCPs that differ in compressed/non-compressed than the current config file setting, you’re not going to be able to restore them (although setting CompressedLCP=1 should let you restore either compressed or non-compressed LCPs).

At some point, I’ll probably move AsyncFile (our async file IO class) to just use azio alway, and modify azio to be transparent for non-compressed files…. I just have to fix up azio for direct io.