IRC log for #gllug on 20080720

01:35.24*** join/#gllug catalyst (n=catalyst@allegro/user/angelchild)
02:02.50*** join/#gllug DiscordianUK (n=ch@chills.demon.co.uk)
02:08.58*** join/#gllug Leeds (n=richardc@n219079209254.netvigator.com)
03:18.32*** join/#gllug andy (n=cpu@nurburgr.ing.me.uk)
03:36.51*** join/#gllug curson (n=curzon@p1087-ipbf214funabasi.chiba.ocn.ne.jp)
06:49.27*** join/#gllug curson (n=curzon@p1087-ipbf214funabasi.chiba.ocn.ne.jp)
07:34.14*** join/#gllug Armand (n=mcagame@87-194-222-79.bethere.co.uk)
09:59.46*** join/#gllug etoshutl (n=etorix@unaffiliated/etorix)
10:02.17*** join/#gllug etorix (n=etorix@unaffiliated/etorix)
11:17.06*** join/#gllug curson (n=curzon@p1087-ipbf214funabasi.chiba.ocn.ne.jp)
11:21.13*** join/#gllug DiscordianUK (n=ch@chills.demon.co.uk)
11:21.55DiscordianUKgood afternoon
14:44.33*** join/#gllug mindbendr (n=mindbend@81-86-39-225.dsl.pipex.com)
14:44.46mindbendrgood afternoon
15:05.24*** join/#gllug mindbend1 (n=mindbend@81-86-39-225.dsl.pipex.com)
15:09.33*** join/#gllug boudiccas (n=boudicca@88-108-51-216.dynamic.dsl.as9105.com)
15:33.52*** join/#gllug zmey_g (n=egor@87-127-26-43.no-dns-yet.enta.net)
16:03.28halifucking hell, just found out that the company above us at work has got their own cosplay forum :-)
16:03.34halinerd alert! :)
16:09.38mindbendrwhat's cosplay
16:09.56halicostume play, nerds who dress up as fictional characters
16:10.05halilike people walking around in starwars outfits
16:10.50mindbendrtoday there's something like that in earlscourt
16:10.56haliyes
16:10.59halii was there :P
16:11.03mindbendroh
16:11.10mindbendrhow many starwars ppl haven you seen?
16:11.16halii was only there to check out Claudia Black
16:11.16mindbendr*have
16:11.20mindbendrlol
16:11.37halithey are trying some guiness world record with most starwars people in one place
16:11.39mindbendrwhy would you go
16:11.41mindbendri can't understand
16:11.48halididn't see that many actually, 25 perhaps
16:11.54haliit's cheap and it's a good laugh
16:12.02haliwe had two beers and then legged it
16:12.06mindbendri can understand the starwars part
16:12.11mindbendrwhich would be fun for sure
16:12.18mindbendrbut what's the deal with meeting celebs
16:12.18haliit's quite fun just to look at people
16:12.28haliand omg
16:12.53halithere was this girl ressed up as princess liea in star wars, from the jabba the hut scene
16:12.57halidressed*
16:12.59mindbendrlol
16:13.02haliwell, she wasn't very dressed
16:13.04mindbendrhave you taken pictures?
16:13.11haliand unfortunatly she was about 16 stone
16:13.13mindbendrif so, put it online
16:13.33halino didn't take photos
16:14.06haliand they had the Back from the future Delorian car on display too, that was pretty cool actually
16:15.02mindbendrI would want to check Batmobile
16:15.41mindbendrI've read that It was in the movie opening
16:42.32andyhali: question for you.. MySQL, ALTER TABLE ... CONVERT TO CHARACTER SET utf8;
16:42.35andyhow safe is it? ;)
16:44.43halino idea
16:44.49halii lothe mysql
16:45.00halicreate a test vm and try it
16:45.14halioracle is always a pain up the neck with character set conversions
16:45.14AndyMillarandy: mysqldump first ;)
16:45.39halimostly due to extent allocation problems and causing the new data (if more bytes per char) to chain the rows and thus fucking up performance
16:46.18andyAndyMillar: I've hourly backups\
16:46.30AndyMillarandy: heavily used database?
16:46.46haliandy: got writeable snapshots?
16:46.52andyno writable snapshots :(
16:47.03andydb just lives on xfs
16:47.23andythere's about 600 inserts or updates a second
16:47.26andyso its fairly quiet
16:47.32andythe slaves take care of the selects
16:47.43AndyMillarah, so you can't really roll back nicely
16:47.50andynot really
16:48.10andyand I can't really take an outage, either
16:48.24AndyMillarhow many rows?
16:48.30halithe convert will put a lock on the full table for the full operation
16:48.41haliso i would at least guess all updates/inserts wait
16:48.56haliso however long it takes you'll build up backlog
16:48.57andyjust under 4M rows
16:49.01AndyMillarwhat hali said (so you'll ave an outage for as long as the update takes... and i don't think charset converting is quick)
16:49.21hali4M rows should be fairly quick unless the rows are huge
16:50.02AndyMillarandy: could turn on query logging, mysqldump, update and if it all goes tits up you have a log of what changed between update and restore?
16:50.36haliquery logging is not consitant
16:50.41andyI think I'll ignore the problem for now, and find the time to take an outage
17:13.41andyhang on
17:13.41andyhmm
17:14.16andylooks at a backup
17:14.18andyI'm ok!
17:14.28andyDROP TABLE IF EXISTS `AttributeNames`;
17:14.28andySET @saved_cs_client     = @@character_set_client;
17:14.28andySET character_set_client = utf8;
17:14.28andyCREATE TABLE `AttributeNames` ( `id` smallint(6) NOT NULL default '0', `name` varchar(255) NOT NULL, `defaultValue` varchar(255) default NULL, PRIMARY KEY  (`id`)
17:14.28andy) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17:14.30andySET character_set_client = @saved_cs_client;
17:14.41andyits just the database which has a default charset set wotng
17:14.48andybut as we specify for each table, its all cool
17:14.53andyboogie
17:17.14*** join/#gllug mindbendr (n=mindbend@81-86-39-225.dsl.pipex.com)
17:27.54*** join/#gllug mindbendr (n=mindbend@81-86-39-225.dsl.pipex.com)
17:36.18*** join/#gllug mindbendr (n=mindbend@81-86-39-225.dsl.pipex.com)
17:41.18*** join/#gllug mindbend1 (n=mindbend@81-86-39-225.dsl.pipex.com)
18:40.36*** join/#gllug DiscordianUK (n=ch@chills.demon.co.uk)
18:41.52DiscordianUKGood evening
18:42.15boudiccasevening DiscordianUK
18:42.42DiscordianUKHi boudiccas
18:43.26zmey_ghi
19:06.32*** join/#gllug ranner (n=ranner@79.173.187.230)
19:13.03*** join/#gllug DiscordianUK (n=ch@chills.demon.co.uk) [NETSPLIT VICTIM]
19:14.17mindbend1hello
19:14.48boudiccashi mindbend1
19:15.02mindbend1how u doin
19:16.33boudiccasdrinking beer atm
19:16.44boudiccashome brewed and very nice too
19:17.01mindbend1good way to spend sunday
19:17.19boudiccasjust chatting via irc an dsupping beer
19:17.36mindbend1in a pub would be better somehow?
19:18.11wethrinYou wouldn't get her homebrew in a pub, though
19:18.23DiscordianUKindeed
19:18.38DiscordianUKwell you used to sorta with the firkins
19:18.42mindbend1ALE would be ok
19:18.56boudiccasi wouldnt sell it, that means that you get HMRC involved and tax has to be paid
19:19.05wethrinindeed
19:19.27wethrinCider and perry, you can sell a certain amount without incurring duty
19:19.27wethrinBut beer, you have to pay for...
19:19.46*** join/#gllug catalyst (n=catalyst@allegro/user/angelchild)
19:19.50DiscordianUKand spirits are illegal
19:20.12wethrinBelow certain limits, yes....
19:21.05wethrinEr. I think there's a minimum size of stills; certainly there is in Scotland
19:21.42DiscordianUKi was always told stills were illegal
19:22.08wethrinNot any more
19:22.08wethrinThere's two whisky distilleries in England
19:22.38DiscordianUKNot that i much care for spirits
19:24.31DiscordianUKwonders if you can homebrew belgian style ales
19:24.48wethrinDon't see why not. If you have the right malt and hops and yeasts
19:25.01wethrinAnd an appropriate lagering place
19:25.19DiscordianUKhmmm hoegaarden is my favourite tipple
19:25.57wethrinThat's got some stuff added. Coriander, I believe
19:26.09DiscordianUKindeed
19:26.15DiscordianUKand curacao
19:32.12DiscordianUKi think one of my friends is a linux convert now, hope the crap laptop i gave her works
20:08.18*** join/#gllug j0nr (n=jonrserv@5ad41839.bb.sky.com)
20:08.51j0nranyone had any joy installing fuppes?
20:09.02DiscordianUKfuppes?
20:09.48haliupnp server
20:09.51j0nryou haven't then? :p
20:09.57j0nryep
20:10.03halii think i tried it on my nas but the cpu was to slow for any good use
20:10.07DiscordianUKcorrect i haven't
20:10.21j0nri have ran thru installation instructions and there is just nowt happening
20:10.26j0nrbut there were no errors...
20:10.36j0nrjust hopig to find someone with similar experience
20:10.40haliyou added directories to scan?
20:11.21j0nrhali: i havent got that far.... after installing, i am supposed to have a .fuppes directory in home, but i dont...therefore theres no fuppes.cfg to configure
20:11.51zmey_gjust checked some of the mp3's and found this hex in the mp3 file comments http://pastebin.com/d3b1e2ada . any ideas what it could be?
20:17.27catalystI gave up on fuppes
20:17.33catalystI think
20:28.06*** join/#gllug boudicca (n=boudicca@88-108-51-216.dynamic.dsl.as9105.com)
20:28.18DiscordianUKwb
21:40.52*** join/#gllug curson (n=curzon@p1087-ipbf214funabasi.chiba.ocn.ne.jp)
21:53.07*** join/#gllug catalyst` (n=catalyst@allegro/user/angelchild)
23:23.53*** join/#gllug catalyst (n=catalyst@allegro/user/angelchild)
23:32.30*** join/#gllug ranner (n=ranner@87-194-121-121.bethere.co.uk)
23:38.35*** join/#gllug catalyst` (n=catalyst@allegro/user/angelchild)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.