Ramblings

• distrated by shiny things #
• the Sun Corporate Travel Online tool is 1000 percent of total utter fucking fail. #
• hi Amex Travel, let me introduce you to ORDER BY #
• dear Amex Travel, if you displayed the prices of flights up front, you wouldn’t need to “search for lower prices”. fail. #
• Dear Amex Travel, $a == $b is not a lower fare. #
• Dear Amex Travel, remember my Qantas frequent flyer number you fail-mongers. #
• Dear Amex Travel, I’m unlikely to change my meal preference. remember it. fail++ #
• Dear Amex Travel, you’re more expensive than Qantas.com, and have a worse UI. Why do we use you? fail++ #
• loonch time #
• pushing a mysql branch to launchpad takes a *long* time… as in longer than going out for lazy long lunch. #
• waiting immense amount of times to cerate new mysql branch on launchpad.net #
• still waiting for push to launchpad to finish…. only been going about 6.5hrs #

Powered by Twitter Tools.

Vervante Books Etc — MySQL 5.1 Cluster DBA Certification Study Guide

Only $40. Written by absolute brilliant people (and me). Needing to learn MySQL Cluster so you can go and use it? test it out? work out if it’s for you? Get this book!

• “…all you have to do is find the universal perkiness constant…” #

Powered by Twitter Tools.

• “…all you have to do is find the universal perkiness constant…” #

Powered by Twitter Tools.

• coffee is very non-fail #

Powered by Twitter Tools.

• @glynnfoster: for me, image-update gets “url timedout” and just rolls back. i dream of running out of space #

Powered by Twitter Tools.

• hating OpenSSL and yaSSL. a lot. #
• it is tempting just to implement my own crypto routines instead of using these poorly documented, half implemented pieces of trash. #
• @kartar: it’s the little things… like not having any mention on how big an output buffer should be… you know, unimportant things. #
• @kartar want to start libunfuckedcrypto ? #
• the complete lack of return codes in yassl crypto_wrapper makes me want to stab it in the face #

Powered by Twitter Tools.

In code just tested:

ndb_mgm> ndbinfo MEMUSAGE
RESOURCE_NAME    NODE_ID    PAGE_SIZE_KB    PAGES_USED    PAGES_TOTAL    BLOCK
IndexMemory,1,8192,16,160,DBACC
DataMemory,1,32768,20,640,DBTUP
IndexMemory,2,8192,16,160,DBACC
DataMemory,2,32768,20,640,DBTUP

Win!

This is the first time that we’ve been able to get this kind of info out of the cluster without using the magic “all dump 1000″ (or “all report MemUsage”) which end up using events, which go to the log file, aren’t exactly reliable etc.

This performs a scan on the NDBINFO tables (in ndbd) from ndb_mgmd and returns the result to the management client. You can then use this in scripts from the command line. e.g. to find out how many pages of datamemory are used on each node:

$ ./storage/ndb/src/mgmclient/ndb_mgm -c localhost:9311 -e ‘ndbinfo MEMUSAGE’|tail -n +3|grep ‘DataMemory’|cut -d ‘,’ -f4
20
20

now, just to clean it up a bit, fix the one bug (yes, you guessed it: in metadata caching) and get a review….

but, a milestone!

• on facebook, tv trivia: buffy. I am so good at this :) #

Powered by Twitter Tools.

• so not my type of bar #
• another brick in the wall dance mix. somebody must die #
• fuck me, i need a rea drink. #

Powered by Twitter Tools.

Tried a vegan pancake recipe for breakfast (with maple syrup and jam for tapping… and i was wishing i had some soy ice cream around). yum!

The recipe was from Vegan with a Vengeance (a pretty awesome book):