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.55 | DiscordianUK | good afternoon |
14:44.33 | *** join/#gllug mindbendr (n=mindbend@81-86-39-225.dsl.pipex.com) |
14:44.46 | mindbendr | good 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.28 | hali | fucking hell, just found out that the company above us at work has got their own cosplay forum :-) |
16:03.34 | hali | nerd alert! :) |
16:09.38 | mindbendr | what's cosplay |
16:09.56 | hali | costume play, nerds who dress up as fictional characters |
16:10.05 | hali | like people walking around in starwars outfits |
16:10.50 | mindbendr | today there's something like that in earlscourt |
16:10.56 | hali | yes |
16:10.59 | hali | i was there :P |
16:11.03 | mindbendr | oh |
16:11.10 | mindbendr | how many starwars ppl haven you seen? |
16:11.16 | hali | i was only there to check out Claudia Black |
16:11.16 | mindbendr | *have |
16:11.20 | mindbendr | lol |
16:11.37 | hali | they are trying some guiness world record with most starwars people in one place |
16:11.39 | mindbendr | why would you go |
16:11.41 | mindbendr | i can't understand |
16:11.48 | hali | didn't see that many actually, 25 perhaps |
16:11.54 | hali | it's cheap and it's a good laugh |
16:12.02 | hali | we had two beers and then legged it |
16:12.06 | mindbendr | i can understand the starwars part |
16:12.11 | mindbendr | which would be fun for sure |
16:12.18 | mindbendr | but what's the deal with meeting celebs |
16:12.18 | hali | it's quite fun just to look at people |
16:12.28 | hali | and omg |
16:12.53 | hali | there was this girl ressed up as princess liea in star wars, from the jabba the hut scene |
16:12.57 | hali | dressed* |
16:12.59 | mindbendr | lol |
16:13.02 | hali | well, she wasn't very dressed |
16:13.04 | mindbendr | have you taken pictures? |
16:13.11 | hali | and unfortunatly she was about 16 stone |
16:13.13 | mindbendr | if so, put it online |
16:13.33 | hali | no didn't take photos |
16:14.06 | hali | and they had the Back from the future Delorian car on display too, that was pretty cool actually |
16:15.02 | mindbendr | I would want to check Batmobile |
16:15.41 | mindbendr | I've read that It was in the movie opening |
16:42.32 | andy | hali: question for you.. MySQL, ALTER TABLE ... CONVERT TO CHARACTER SET utf8; |
16:42.35 | andy | how safe is it? ;) |
16:44.43 | hali | no idea |
16:44.49 | hali | i lothe mysql |
16:45.00 | hali | create a test vm and try it |
16:45.14 | hali | oracle is always a pain up the neck with character set conversions |
16:45.14 | AndyMillar | andy: mysqldump first ;) |
16:45.39 | hali | mostly 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.18 | andy | AndyMillar: I've hourly backups\ |
16:46.30 | AndyMillar | andy: heavily used database? |
16:46.46 | hali | andy: got writeable snapshots? |
16:46.52 | andy | no writable snapshots :( |
16:47.03 | andy | db just lives on xfs |
16:47.23 | andy | there's about 600 inserts or updates a second |
16:47.26 | andy | so its fairly quiet |
16:47.32 | andy | the slaves take care of the selects |
16:47.43 | AndyMillar | ah, so you can't really roll back nicely |
16:47.50 | andy | not really |
16:48.10 | andy | and I can't really take an outage, either |
16:48.24 | AndyMillar | how many rows? |
16:48.30 | hali | the convert will put a lock on the full table for the full operation |
16:48.41 | hali | so i would at least guess all updates/inserts wait |
16:48.56 | hali | so however long it takes you'll build up backlog |
16:48.57 | andy | just under 4M rows |
16:49.01 | AndyMillar | what 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.21 | hali | 4M rows should be fairly quick unless the rows are huge |
16:50.02 | AndyMillar | andy: 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.36 | hali | query logging is not consitant |
16:50.41 | andy | I think I'll ignore the problem for now, and find the time to take an outage |
17:13.41 | andy | hang on |
17:13.41 | andy | hmm |
17:14.16 | andy | looks at a backup |
17:14.18 | andy | I'm ok! |
17:14.28 | andy | DROP TABLE IF EXISTS `AttributeNames`; |
17:14.28 | andy | SET @saved_cs_client = @@character_set_client; |
17:14.28 | andy | SET character_set_client = utf8; |
17:14.28 | andy | CREATE TABLE `AttributeNames` ( `id` smallint(6) NOT NULL default '0', `name` varchar(255) NOT NULL, `defaultValue` varchar(255) default NULL, PRIMARY KEY (`id`) |
17:14.28 | andy | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
17:14.30 | andy | SET character_set_client = @saved_cs_client; |
17:14.41 | andy | its just the database which has a default charset set wotng |
17:14.48 | andy | but as we specify for each table, its all cool |
17:14.53 | andy | boogie |
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.52 | DiscordianUK | Good evening |
18:42.15 | boudiccas | evening DiscordianUK |
18:42.42 | DiscordianUK | Hi boudiccas |
18:43.26 | zmey_g | hi |
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.17 | mindbend1 | hello |
19:14.48 | boudiccas | hi mindbend1 |
19:15.02 | mindbend1 | how u doin |
19:16.33 | boudiccas | drinking beer atm |
19:16.44 | boudiccas | home brewed and very nice too |
19:17.01 | mindbend1 | good way to spend sunday |
19:17.19 | boudiccas | just chatting via irc an dsupping beer |
19:17.36 | mindbend1 | in a pub would be better somehow? |
19:18.11 | wethrin | You wouldn't get her homebrew in a pub, though |
19:18.23 | DiscordianUK | indeed |
19:18.38 | DiscordianUK | well you used to sorta with the firkins |
19:18.42 | mindbend1 | ALE would be ok |
19:18.56 | boudiccas | i wouldnt sell it, that means that you get HMRC involved and tax has to be paid |
19:19.05 | wethrin | indeed |
19:19.27 | wethrin | Cider and perry, you can sell a certain amount without incurring duty |
19:19.27 | wethrin | But beer, you have to pay for... |
19:19.46 | *** join/#gllug catalyst (n=catalyst@allegro/user/angelchild) |
19:19.50 | DiscordianUK | and spirits are illegal |
19:20.12 | wethrin | Below certain limits, yes.... |
19:21.05 | wethrin | Er. I think there's a minimum size of stills; certainly there is in Scotland |
19:21.42 | DiscordianUK | i was always told stills were illegal |
19:22.08 | wethrin | Not any more |
19:22.08 | wethrin | There's two whisky distilleries in England |
19:22.38 | DiscordianUK | Not that i much care for spirits |
19:24.31 | DiscordianUK | wonders if you can homebrew belgian style ales |
19:24.48 | wethrin | Don't see why not. If you have the right malt and hops and yeasts |
19:25.01 | wethrin | And an appropriate lagering place |
19:25.19 | DiscordianUK | hmmm hoegaarden is my favourite tipple |
19:25.57 | wethrin | That's got some stuff added. Coriander, I believe |
19:26.09 | DiscordianUK | indeed |
19:26.15 | DiscordianUK | and curacao |
19:32.12 | DiscordianUK | i 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.51 | j0nr | anyone had any joy installing fuppes? |
20:09.02 | DiscordianUK | fuppes? |
20:09.48 | hali | upnp server |
20:09.51 | j0nr | you haven't then? :p |
20:09.57 | j0nr | yep |
20:10.03 | hali | i think i tried it on my nas but the cpu was to slow for any good use |
20:10.07 | DiscordianUK | correct i haven't |
20:10.21 | j0nr | i have ran thru installation instructions and there is just nowt happening |
20:10.26 | j0nr | but there were no errors... |
20:10.36 | j0nr | just hopig to find someone with similar experience |
20:10.40 | hali | you added directories to scan? |
20:11.21 | j0nr | hali: 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.51 | zmey_g | just 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.27 | catalyst | I gave up on fuppes |
20:17.33 | catalyst | I think |
20:28.06 | *** join/#gllug boudicca (n=boudicca@88-108-51-216.dynamic.dsl.as9105.com) |
20:28.18 | DiscordianUK | wb |
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) |