{"id":463,"date":"2005-09-04T18:49:07","date_gmt":"2005-09-04T08:49:07","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=463"},"modified":"2013-10-04T09:27:00","modified_gmt":"2013-10-03T23:27:00","slug":"memberdb-election-results-performance-on-new-laptop","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2005\/09\/04\/memberdb-election-results-performance-on-new-laptop\/","title":{"rendered":"MemberDB election-results performance on new laptop"},"content":{"rendered":"

So I picked up my new laptop on friday. It’s an ASUS V6V – nice and fast, light, good resolution screen and lots of disk and RAM (it came with 1GB, I’ve got 2GB).<\/p>\n

Anyway, the transfer of data from my PowerBook went fine. I waited for xfsdump to dump \/home from the powerbook to a firewire drive (and for “waiting” I do mean going out and seeing Charlie and the Chocolate Factory – which was very good).<\/p>\n

Installing Ubuntu<\/a> on the ASUS went like a dream. Everything, and i do mean everything worked out-of-the-box with only one tweak. That was uncommented the ACPI sleep configuration option do-dad in \/etc\/default\/acpi-something-foo to get suspend to ram working.<\/p>\n

The WEP didn’t work in the installer, so I initially just used the GigE adapter until the first reboot.<\/p>\n

The firewire drivers don’t really behave with this laptop atm… that dreaded “aborted sbp2 command” error too often – so abandoned that and futzed around with a private net and NFS to xfsrestore \/home.<\/p>\n

Go to bed, awake later to find \/home on new laptop (with an extra 23GB of free space!). I had to, of course – rebuild those essential packages for x86 instead of ppc – namely wesnoth<\/a>.<\/p>\n

oh, and cleaning out the ppc binaries from my mysql bk trees and doing a x86 build (I also had to change my CC from ‘ccache distcc powerpc-linux-gcc’ to ‘ccache distcc i386-linux-gcc’). One thing is for certain, it’s quicker at building things – even if the fan ramps up a bit when doing so :)<\/p>\n

MySQL<\/a> builds pretty quickly when you have a 2.8Ghz P4 and a 2.13Ghz Pentium M building it.<\/p>\n

Anyway, set up all the apache foo for hacking on the LA website<\/a> and MemberDB<\/a> today. A load of the elections-result page on digital (the LA server – dual PIII 1.133Ghz) takes about fourteen or fifteen seconds using PostgreSQL<\/a> as the database.<\/p>\n

I previously reported that using MySQL (InnoDB tables) I got about twice the performance on my old laptop (1Ghz G4).<\/p>\n

Well, on this one (2.13Ghz Pentium M) I’m getting the page loading in under three seconds. Sweet. Maybe I won’t go ahead and try to optimise some of the queries :)<\/p>\n

(the query cache is probably coming into this – but i did do the query several times – so it’s not as if there’s any unfair advantage anywhere).<\/p>\n

I’m using the 5.0.12-max-beta gcc dynamic build as downloaded from mysql.com<\/a> for these runs. All other packages (apache2, php) are as shipped in Ubuntu<\/a>. The my.ini file is as-shipped (err.. i think so: no query log, no binlog, slow query log enabled and some paths changed)<\/p>\n","protected":false},"excerpt":{"rendered":"

So I picked up my new laptop on friday. It’s an ASUS V6V – nice and fast, light, good resolution screen and lots of disk and RAM (it came with 1GB, I’ve got 2GB). Anyway, the transfer of data from … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[5,6,13,14],"tags":[],"class_list":["post-463","post","type-post","status-publish","format-standard","hentry","category-cool-gadgets","category-linux-aus","category-memberdb","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-7t","jetpack-related-posts":[{"id":459,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/08\/29\/stillhqcom-did-i-mention-that-apple-service-sucks\/","url_meta":{"origin":463,"position":0},"title":"stillhq.com – Did I mention that Apple service sucks?","author":"Stewart Smith","date":"2005-08-29","format":false,"excerpt":"stillhq.com - Did I mention that Apple service sucks? I totally empathise with Mikal on this one. My adventures with Apple service has been interesting. Although I've usually gotten better result out of being persistent and a giant pain in the arse (I honestly feel sorry for anyone who gets\u2026","rel":"","context":"In "life, the universe and everything"","block_context":{"text":"life, the universe and everything","link":"https:\/\/www.flamingspork.com\/blog\/category\/life-the-universe-and-everything\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":248,"url":"https:\/\/www.flamingspork.com\/blog\/2004\/06\/20\/new-hardware\/","url_meta":{"origin":463,"position":1},"title":"new hardware","author":"Stewart Smith","date":"2004-06-20","format":false,"excerpt":"A firewire card for my desktop (because my Asus P4P800 Deluxe motherboard's connectors DO NOT WORK, but this shintaro one does), a TV tuner card (now i need an ariel), and a new wireless card for my laptop (802.11g, not that i have a g access point, but this one\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":486,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/10\/14\/hey-acpi-buttons-work\/","url_meta":{"origin":463,"position":2},"title":"Hey, ACPI buttons work!","author":"Stewart Smith","date":"2005-10-14","format":false,"excerpt":"rockin. The buttons at the top left of my keyboard work on ubuntu! what looks like running away makes the screensaver come on (password protected). Useful. Replaces that shortcut i'd set. The bluetooth button always has. plugs\/unplugs the internal bluetooth adapter. The world with a ring on it doesn't do\u2026","rel":"","context":"In "cool gadgets"","block_context":{"text":"cool gadgets","link":"https:\/\/www.flamingspork.com\/blog\/category\/cool-gadgets\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":621,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/03\/14\/really-unstable-laptop-2\/","url_meta":{"origin":463,"position":3},"title":"really unstable laptop","author":"Stewart Smith","date":"2006-03-14","format":false,"excerpt":"I'm currently getting hard crashes about five times a day. I thought it was the sound driver, as i got a crash during dist-upgrade (again) while on console and saw the backtrace. Basically looked like something bad happenned when the sound was muted. So, running without sound muted - just\u2026","rel":"","context":"In "life, the universe and everything"","block_context":{"text":"life, the universe and everything","link":"https:\/\/www.flamingspork.com\/blog\/category\/life-the-universe-and-everything\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":345,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/01\/18\/mysql-port-of-memberdb\/","url_meta":{"origin":463,"position":4},"title":"MySQL port of MemberDB","author":"Stewart Smith","date":"2005-01-18","format":false,"excerpt":"Spent probably about 3 hours today porting the database schema to MySQL 5 along with finding some bugs in the process. Pretty minor ones, mainly to do with how things could be improved to improve compatibility with schemas written with postgresql in mind. While chasing up some stuff on why\u2026","rel":"","context":"In "linux-aus"","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":230,"url":"https:\/\/www.flamingspork.com\/blog\/2004\/05\/02\/memberdb-work\/","url_meta":{"origin":463,"position":5},"title":"memberdb work","author":"Stewart Smith","date":"2004-05-02","format":false,"excerpt":"been doing a fair bit of mods to memberdb recently - getting features in. - new css based look (which is almost correct) - more solid code around the place - better error reporting (that needs debugging... hahaha) - a start on the positions tracking UI - change password UI\u2026","rel":"","context":"In "linux-aus"","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=463"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/463\/revisions"}],"predecessor-version":[{"id":3458,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/463\/revisions\/3458"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}