| 00:05.12 | *** join/#uphpu brasto (n=brasto@fw.oremut02.us.wh.verio.net) |
| 00:05.12 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 00:07.24 | *** join/#uphpu brasto (n=brasto@fw.oremut02.us.wh.verio.net) |
| 00:07.25 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 00:30.11 | *** join/#uphpu cyco|w (n=cyco@66.114.120.2) |
| 02:53.39 | *** join/#uphpu herlo (n=herlo@adsl-70-251-1-96.dsl.rcsntx.swbell.net) |
| 02:53.46 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 04:26.37 | *** join/#uphpu Utah_Dave (n=boucha@d103.digis.net) |
| 04:26.37 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 04:32.59 | *** part/#uphpu Utah_Dave (n=boucha@d103.digis.net) |
| 04:44.09 | *** join/#uphpu Utah_Dav1 (n=boucha@fbp-ore-bdr2-pl107771.serial.fiber.net) |
| 05:24.37 | *** join/#uphpu herlo (n=herlo@65.212.203.130) |
| 05:24.41 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 12:40.40 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 12:40.40 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 12:50.06 | timinator | morning guys |
| 14:08.58 | *** join/#uphpu herlo (n=herlo@216-110-89-130.static.twtelecom.net) |
| 14:09.05 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 14:15.03 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 14:15.14 | *** mode/#UPHPU [+o wps] by ChanServ |
| 14:48.07 | *** join/#uphpu jsmith_ (n=jsmith@dsl017-122-217.mci1.dsl.speakeasy.net) |
| 14:55.18 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 14:58.05 | *** join/#uphpu gibba[w] (i=gibbawho@209-253-35-21.ip.mcleodusa.net) |
| 15:10.09 | *** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net) |
| 15:10.09 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:10.33 | gibba[w] | mornin folks |
| 15:10.45 | timinator | morning gibba[w] |
| 15:11.46 | *** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net) |
| 15:11.57 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:29.21 | jsmith | timinator: Guess what I'm eating ;-) |
| 15:29.41 | timinator | ...... |
| 15:29.46 | timinator | something in KC? |
| 15:29.52 | jsmith | timinator: They come in a nice yellow box... with "Lamar's" on the top |
| 15:29.58 | timinator | AAAHHHHH |
| 15:30.28 | timinator | they're good, huh |
| 15:30.37 | jsmith | Of course... |
| 15:30.55 | timinator | you suck |
| 15:31.05 | timinator | :) |
| 15:32.11 | jsmith | Sorry, can't type and eat a chocolate-covered old-fashioned at the same time ;-) |
| 15:46.46 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 15:46.46 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:46.59 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 15:46.59 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:47.39 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 15:47.39 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 16:29.58 | *** join/#uphpu _psychic__ (n=_psychic@65.103.232.203) |
| 16:57.09 | *** join/#uphpu eco_ (n=eco@gnuk.net) |
| 17:09.24 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 17:09.24 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 17:14.50 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 17:14.50 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 17:35.01 | mindjuju | sup all |
| 17:35.11 | timinator | sup mindjuju |
| 17:36.40 | mindjuju | ugh, i hate bbs spam bots |
| 17:37.26 | timinator | I hate it when people eat Lamar's doughnuts in front of me and don't share!!!! |
| 17:37.36 | timinator | *cough jsmith *cough |
| 17:37.54 | jsmith | timinator: I'll email one to you... what's your email address? |
| 17:38.03 | timinator | :) |
| 17:38.11 | timinator | forget it now... they're 2 hrs old |
| 17:38.44 | timinator | timothy.humphrey [at] gmail [dot] com |
| 17:38.51 | timinator | I'll take a pic |
| 17:39.00 | timinator | make it my desktop background |
| 17:40.05 | mindjuju | too bad they can't fedex it |
| 17:40.14 | timinator | ya, too bad |
| 17:40.23 | mindjuju | i was thinking of ordering a chicago deep dish from some resturant i saw on food channel |
| 17:40.43 | mindjuju | it was like $17 for a 12" which isn't to bad and supposedly included shipping |
| 17:41.04 | timinator | just throw it in your oven?!? |
| 17:41.09 | mindjuju | yup |
| 17:41.21 | mindjuju | they make it then freeze it and send it in dry ice |
| 17:41.27 | mindjuju | you bake it when your ready |
| 17:41.43 | mindjuju | course though, there is a place in Memphsis that sends their bbq fed ex |
| 17:41.47 | mindjuju | was thinking about doing that |
| 17:41.58 | _psychic_ | dude |
| 17:42.01 | mindjuju | and a place in Texas that will send it's brisket fed ex |
| 17:42.01 | _psychic_ | that'd be cool |
| 17:42.13 | mindjuju | sup _psychic_ |
| 17:42.26 | _psychic_ | morning bro |
| 17:42.51 | mindjuju | which one would be cool, the Memphis bbq , Texas Brisket or Chicago Pizza? |
| 17:43.34 | _psychic_ | I could go for the pizza |
| 17:43.37 | _psychic_ | $17? |
| 17:43.46 | mindjuju | yeah |
| 17:43.58 | mindjuju | let me see if i have the page in my IE history |
| 17:44.05 | _psychic_ | IE?!?! |
| 17:45.29 | timinator | heretic... blasphemy.... stone him!!!! |
| 17:46.05 | _psychic_ | I'm sorry, but I'm going to have to rip a corner off your geek ID card. |
| 17:47.11 | mindjuju | _psychic_ , did you have a toten chip card? |
| 17:47.26 | mindjuju | here is the link for the pizza by the way |
| 17:47.27 | mindjuju | http://www.giordanos.com/shop/home.php?cat=1 |
| 17:47.38 | mindjuju | cheapest is $15 and pricest is $20 |
| 17:47.56 | _psychic_ | mindjuju: for a few days, yeah |
| 17:48.21 | mindjuju | which REALLY isn't bad, considering you could get Pizza Hut for just a few $$ less and this resturant i saw on food channel and is suppose to be one of the best |
| 17:49.29 | *** join/#uphpu tierra (n=tierra@ibaku.net) |
| 17:49.29 | *** mode/#UPHPU [+v tierra] by ChanServ |
| 17:50.03 | _psychic_ | I wonder how easy it is to prepare, though |
| 17:51.52 | timinator | probably won't taste the same unless you own a pizza oven |
| 17:52.25 | mindjuju | actually, we just got some pizza from this place in utah that wasn't bad at all |
| 17:52.50 | mindjuju | pie pizzeria or pizzeria pie |
| 17:52.53 | mindjuju | one of those |
| 17:53.01 | timinator | just don't pull a link from IE |
| 17:53.16 | mindjuju | we actually got it for a big tech meet we had the other day so we got their 32" |
| 17:53.25 | mindjuju | biggest pizza i ever saw |
| 17:53.31 | timinator | dang.... sounds like a tv |
| 17:53.47 | mindjuju | k, this is the crazy part, you had to tilt the box to get it through the door |
| 17:54.01 | mindjuju | and crust was good |
| 17:54.14 | timinator | nice |
| 17:54.26 | mindjuju | yeah, maybe we should eat there next geek lunch |
| 17:54.51 | *** join/#uphpu weechat_user (n=weechat@64.251.22.233) |
| 17:57.00 | mindjuju | which, i was thinking, this time was in the north, time before was in the south, i think we should find some place to the east |
| 17:57.23 | jsmith | Say, near Washington D.C.? |
| 17:58.12 | _psychic_ | Tokyo |
| 17:58.55 | jsmith | _psychic_: Me too! |
| 17:58.55 | timinator | mmmm sushi |
| 17:59.10 | jsmith | timinator: There's a great little sushi place down by Brookside |
| 17:59.28 | _psychic_ | There's a place in Provo thats $13 all you can eat sushi |
| 17:59.53 | timinator | that sounds scary _psychic_ |
| 17:59.54 | jsmith | _psychic_: Yeah... Asuka. It's decent |
| 18:00.01 | jsmith | _psychic_: Get the Ernie roll there ;-) |
| 18:00.09 | _psychic_ | Vegas roll rocks too |
| 18:00.15 | _psychic_ | the rules are a little tricky |
| 18:00.18 | jsmith | Yeah, it's almost the same |
| 18:00.22 | _psychic_ | but its good food for pretty cheap |
| 18:00.25 | _psychic_ | jsmith: yeah |
| 18:00.28 | jsmith | Make sure you eat it all and don't leave any |
| 18:00.51 | timinator | they have private rooms too |
| 18:00.52 | _psychic_ | jsmith: except for the first three you order... I think... |
| 18:00.53 | timinator | :) |
| 18:01.04 | jsmith | _psychic_: Yes, exactly |
| 18:01.52 | _psychic_ | Dangit.. Why did we have to start talking about sushi right now :( |
| 18:04.16 | timinator | I'm starving |
| 18:05.16 | dataw0lf | mraaaawr |
| 18:06.08 | mindjuju | rwaaaarm |
| 18:06.51 | *** mode/#UPHPU [+v dataw0lf] by ChanServ |
| 18:06.59 | dataw0lf | hmmm |
| 18:07.19 | dataw0lf | muhahahaha |
| 18:18.52 | *** join/#uphpu mindjuj1 (n=mindjuju@65-121-75-195.dia.static.qwest.net) |
| 18:22.56 | wps | what's going on in here? |
| 18:24.45 | dataw0lf | >_> |
| 18:24.46 | dataw0lf | <_< |
| 18:24.53 | dataw0lf | wps: I have no idea. I blacked out for a moment. |
| 18:25.02 | wps | :) |
| 18:25.04 | dataw0lf | I think Liberace's ghost possessed my body for a moment.. |
| 18:25.26 | mindjuj1 | i had a transendental experience and saw myself leave the room |
| 18:25.27 | mindjuj1 | (11:22:44 AM) mindjuju left the room (quit: Read error: 145 (Connection timed out)). |
| 18:25.34 | mindjuj1 | creepy! |
| 18:28.22 | macnewbold | ~cookie |
| 18:28.29 | macnewbold | ~toss cookie |
| 18:28.35 | mindjuj1 | hey macnewbold |
| 18:28.37 | macnewbold | morning mindjuj1 |
| 18:28.48 | mindjuj1 | i was thinking your on the eastside |
| 18:28.57 | macnewbold | ~punk mindjuj1 |
| 18:28.59 | jbot | ACTION kicks mindjuj1 in the shins |
| 18:28.59 | mindjuj1 | maybe next month geek lunch should be over there somewheres |
| 18:29.11 | macnewbold | sure, that works |
| 18:29.23 | mindjuj1 | am i mindjuj1 ? how confusing |
| 18:29.31 | *** part/#uphpu mindjuj1 (n=mindjuju@65-121-75-195.dia.static.qwest.net) |
| 18:29.36 | *** join/#uphpu mindjuj1 (n=mindjuju@65-121-75-195.dia.static.qwest.net) |
| 18:29.39 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:250:8dff:fe71:9a6b) |
| 18:29.39 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 18:30.04 | *** join/#uphpu atoponce (n=atoponce@oalug/member/atoponce) |
| 18:30.06 | *** mode/#UPHPU [+v atoponce] by ChanServ |
| 18:30.14 | macnewbold | ~bonk mindjuju |
| 18:30.17 | jbot | ACTION bonks mindjuju over the head |
| 18:30.31 | mindjuju | ~timattack macnewbold |
| 18:30.32 | jbot | ACTION uses a 2 handed log saw and starts to chase macnewbold! |
| 18:30.41 | macnewbold | ~macattack timinator |
| 18:30.42 | jbot | ACTION jumps on bell rope, causing bell to hit timinator! |
| 18:30.57 | timinator | ~timattack macnewbold |
| 18:30.59 | jbot | ACTION grabs an axe and starts to go postal on macnewbold! |
| 18:31.06 | macnewbold | ~postal mindjuju |
| 18:31.13 | macnewbold | ~lart mindjuju |
| 18:31.16 | macnewbold | ~insult mindjuju |
| 18:31.18 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 18:31.27 | mindjuju | k, that's better |
| 18:31.34 | mindjuju | already, who be smackin' me |
| 18:31.53 | mindjuju | ~dhit macnewbold |
| 18:31.54 | jbot | ACTION appears right behind macnewbold and slaps him in the back of the head |
| 18:32.29 | _psychic_ | psyhit still working? |
| 18:32.37 | _psychic_ | (is that what it was called?) |
| 18:32.48 | mindjuju | i pulled it cause it was having issues |
| 18:33.03 | mindjuju | but, i was just thinking, we should make your telepathic attacks |
| 18:33.03 | _psychic_ | yeah, struggling with its awesome power |
| 18:33.43 | mindjuju | if you do, make sure it has the Mr. T plug in |
| 18:33.46 | mindjuju | that's hilarious |
| 18:33.54 | _psychic_ | ? |
| 18:34.10 | mindjuju | you say something like ~mrT go away |
| 18:34.21 | mindjuju | and it takes the string go away and says it the way Mr. T would |
| 18:34.29 | timinator | nice |
| 18:34.31 | _psychic_ | I pity da foo |
| 18:34.54 | timinator | I pity da foo that would go away |
| 18:35.07 | mindjuju | jbot is suppose to have it, but its not enabled |
| 18:35.24 | _psychic_ | jbot is a java bot, right? |
| 18:35.29 | mindjuju | ~jbot |
| 18:35.32 | jbot | somebody said jbot was only marginally useful at best, He got a C- on his Turing Test |
| 18:35.40 | _psychic_ | ~java |
| 18:35.41 | jbot | rumour has it, java is at (Link: http://www.blackdown.org)http://www.blackdown.org or at (Link: http://www.javasoft.com)http://www.javasoft.com or at (Link: http://www.savaje.com)http://www.savaje.com or at (Link: http://www.pocketlinux.com)http://www.pocketlinux.com or at (Link: http://java.sun.com)http://java.sun.com or at http://www.insignia.com, or see the ... |
| 18:35.44 | mindjuju | ~help |
| 18:35.59 | _psychic_ | ... ? |
| 18:36.11 | _psychic_ | He had a stroke or something. |
| 18:36.52 | mindjuju | no, he sent it to me personally |
| 18:36.59 | mindjuju | so if you type that, he'll im you and tell you |
| 18:37.04 | mindjuju | ~wantnick |
| 18:37.07 | _psychic_ | gotcha |
| 18:37.46 | mindjuju | brb |
| 18:42.39 | *** join/#uphpu Lone_Wanderer (n=chatzill@208-186-98-2.customer.csolutions.net) |
| 18:42.39 | *** mode/#UPHPU [+v Lone_Wanderer] by ChanServ |
| 18:43.10 | Lone_Wanderer | Ahoy |
| 18:43.23 | dataw0lf | SET datatype or new table in MySQL? |
| 18:43.45 | dataw0lf | <your guy's opinions here> |
| 18:44.01 | Lone_Wanderer | new table for sure |
| 18:44.19 | Lone_Wanderer | <justification here> |
| 18:44.27 | dataw0lf | index lookups? |
| 18:44.29 | dataw0lf | yea |
| 18:44.33 | dataw0lf | that's what I thought, too. |
| 18:44.49 | Lone_Wanderer | I worked at home for a few hours this morning |
| 18:44.56 | Lone_Wanderer | got more done in a few hours than I normally do all day |
| 18:49.44 | Lone_Wanderer | bigdog, where were you on Friday? |
| 18:49.50 | Lone_Wanderer | We missed you. |
| 18:50.54 | *** join/#uphpu Black_Chaos (n=admin@70-57-91-148.slkc.qwest.net) [NETSPLIT VICTIM] |
| 18:50.55 | *** join/#uphpu eco (n=eco@gnuk.net) [NETSPLIT VICTIM] |
| 18:50.55 | *** join/#uphpu optikal (i=optikal@li2-248.members.linode.com) [NETSPLIT VICTIM] |
| 18:50.55 | *** join/#uphpu drip (n=drip@67.96.135.254) |
| 18:50.55 | *** mode/#UPHPU [+v drip] by ChanServ |
| 18:54.34 | *** join/#uphpu burnin (n=burnin@42dbe40a.dsl.aros.net) |
| 18:54.55 | macnewbold | ~lart bigdog_ut |
| 18:55.03 | Lone_Wanderer | burnin...ator? |
| 18:55.23 | macnewbold | ~trogdor burnin |
| 18:55.26 | jbot | ACTION burninates burnin |
| 18:55.33 | macnewbold | ~burninate Lone_Wanderer |
| 18:55.34 | jbot | ACTION burninates Lone_Wanderer and thrashes him soundly with Trogdor's meat arm. |
| 18:55.56 | Lone_Wanderer | Truly your jbot fu is greater than mine. |
| 18:56.06 | burnin | heh, pummeled with an meat arm. |
| 19:16.14 | Lone_Wanderer | If a girl is dating a jerk and asks me for advice in fixing things up with him, should I give faulty advice in an effort to hasten their breakup? |
| 19:16.29 | Lone_Wanderer | Today on Oprah. |
| 19:16.57 | drip | hmm.. didn't know there was an Oprah RSS feed in here. |
| 19:17.01 | drip | he he |
| 19:17.14 | Lone_Wanderer | Yeah I channel it through my IRC client :p |
| 19:42.28 | macnewbold | Lone_Wanderer channels the Oprah rss feed telepathically I think... |
| 20:03.55 | fungus | hrm, kernel panic... |
| 20:04.14 | fungus | aha! damn fscking RAM from ebay. |
| 20:06.43 | drip | look at it on the bright side.. at least you could probably ebay it. =P |
| 20:08.20 | fungus | lol, I guess |
| 20:12.26 | Lone_Wanderer | ~lart reality |
| 20:13.10 | Lone_Wanderer | I think I'm going to get a PhD and work in Academia |
| 20:13.25 | Lone_Wanderer | where the ugly head of real-life systems ne'er is seen |
| 20:24.08 | tierra | you know... now that I've had to work with a bigger PHP project involving more classes and member function/variable separation, I can't express how annoyed I am with constantly referencing $this |
| 20:25.06 | tierra | I can't believe they didn't fix that PHP5 |
| 20:27.21 | Lone_Wanderer | So, in this VoIP signup system that I'm working on |
| 20:27.31 | Lone_Wanderer | there's no "customer account" page |
| 20:27.55 | Lone_Wanderer | that is, existing customers have no way to log into the site and change, add, or delete stuff relating to their account |
| 20:28.22 | bigdog_ut | thats what a dba is for |
| 20:28.38 | Lone_Wanderer | so if they go to order more services |
| 20:28.48 | Lone_Wanderer | they just have to create a new account |
| 20:29.03 | Lone_Wanderer | practical upshot: almost every customer we've got has multiple accounts in our database |
| 21:03.45 | *** join/#uphpu Utah_Dav1 (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 21:24.50 | *** join/#uphpu diskotec|w (n=jm001@12.125.156.114) |
| 21:29.50 | bigdog_ut | wps did you get the utosc notice? |
| 21:35.28 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 21:41.01 | *** join/#uphpu gibba[w] (i=gibbawho@209-253-35-21.ip.mcleodusa.net) |
| 22:01.39 | wps | bigdog_ut: yes |
| 22:01.49 | bigdog_ut | k |
| 22:02.12 | bigdog_ut | are you going to post to mailing list? |
| 22:13.01 | Lone_Wanderer | No, he's not. |
| 22:22.04 | Utah_Dave | I'm trying to get MySQL to do a delayed INSERT or delayed REPLACE |
| 22:22.31 | Utah_Dave | but it's not letting other reads to get through until the entire insert or REPLACE is finished |
| 22:22.51 | timinator | delayed how long? |
| 22:23.25 | Utah_Dave | well, about 1 minute |
| 22:24.11 | Utah_Dave | We're updating from another database, and when the update is going on the user's info page just stops working until the update is done |
| 22:24.45 | timinator | I'd load it into another table w/ a timestamp.... then have a cron script check every second for any entries over a 59 seconds old to do the actual insert/replace.... then the user can go on w/ life w/o waiting |
| 22:25.28 | Utah_Dave | is there some MySQL tweak I should be looking for? I've gone over the documentation really well and it seems that a INSERT DELAYED or REPLACE DELAYED should allow other reads to go through |
| 22:25.32 | timinator | or |
| 22:25.40 | timinator | you could issue a PHP sleep() |
| 22:25.50 | timinator | for 60 seconds... which will make the user wait |
| 22:26.32 | Utah_Dave | Well, it's a cron job that runs a stored procedure |
| 22:26.35 | timinator | your last question is something I don't know... sorry |
| 22:26.43 | timinator | ah |
| 22:26.53 | timinator | so there's no user involved? |
| 22:27.04 | *** join/#uphpu cyco|w (n=cyco@66.114.120.2) |
| 22:27.08 | Utah_Dave | no, it's not even php running the update |
| 22:27.31 | timinator | oh, my mistake... I assumed PHP |
| 22:27.33 | Utah_Dave | it's just that the user needs to view his/her work info, but they can't until the update script finishes |
| 22:29.51 | Utah_Dave | macnewbold: dataw0lf any ideas? |
| 22:29.56 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 22:29.56 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 22:30.52 | Utah_Dave | maybe I'm reading the documentation incorrectly |
| 22:32.12 | cyco|w | hey, i'm just looking for opinions on which is better from any experiences.. the apache prefork mpm or the worker mpm.. |
| 22:54.58 | bigdog_ut | cyco|w, with regards to php? |
| 22:58.02 | Lone_Wanderer | Today is going by way too slowly. |
| 22:58.18 | Lone_Wanderer | It needs to just end so I can go to the bookstore and read |
| 22:58.19 | wps | really? |
| 22:58.22 | wps | I can't believe it's already four |
| 22:58.24 | Utah_Dave | macnewbold: you around? |
| 22:58.32 | macnewbold | I'm awake, I'm awake |
| 22:58.34 | macnewbold | oh, yeah |
| 22:58.35 | macnewbold | hi |
| 22:58.41 | macnewbold | just got here |
| 22:58.43 | Lone_Wanderer | oh it is already four! |
| 22:59.35 | Utah_Dave | I'm trying to do an INSERT DELAYED or a REPLACE DELAYED |
| 23:00.00 | Utah_Dave | but it's not letting other reads come through like the documentation says it should |
| 23:00.21 | Utah_Dave | I have a cron job that calls a stored procedure once an hour |
| 23:00.29 | Utah_Dave | it takes a little more than a minute to run |
| 23:00.40 | macnewbold | is it doing some kind of locking? |
| 23:00.49 | Utah_Dave | but during that time, our intranet that accessess those tables comes to a screeching halt |
| 23:01.17 | Utah_Dave | Yeah, I believe the MyISAM tables get locked during the INSERT |
| 23:01.22 | macnewbold | cyco|w: prefork has always been my favorite |
| 23:01.49 | Utah_Dave | but the mysql docs say that INSERT DELAYED should look for other reads coming in and let them go, and then continue with the INSERT |
| 23:02.05 | macnewbold | once it starts though, if it is locked you won't be able to get others in |
| 23:02.23 | macnewbold | can one of the two operate on a copy of the database? |
| 23:02.33 | Utah_Dave | http://dev.mysql.com/doc/refman/5.0/en/insert-delayed.html |
| 23:02.39 | macnewbold | is there anything that could be done to shorted the time it is locked? |
| 23:02.45 | macnewbold | are you using 5.0? |
| 23:04.04 | bigdog_ut | +1 Lone_Wanderer |
| 23:04.18 | Utah_Dave | yes, mysql 5.0.27 |
| 23:09.53 | macnewbold | Utah_Dave: your insert is providing a value list, right? Is it one value list or is it one query doing many rows? or many queries? |
| 23:11.57 | bigdog_ut | ~smack cyco|w |
| 23:12.00 | jbot | ACTION smacks cyco|w upside the head. |
| 23:12.24 | Utah_Dave | macnewbold: hm, that might be it |
| 23:15.58 | *** join/#uphpu herlo (n=herlo@65.212.203.130) |
| 23:16.05 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 23:16.22 | bigdog_ut | as i was saying that herlo guys |
| 23:16.42 | bigdog_ut | well speak of the devil |
| 23:17.09 | herlo | bigdog_ut: nice! |
| 23:17.11 | Utah_Dave | I'm doing a REPLACE DELAYED INTO mydb.mytable(field1, field2) SELECT field1, field2 FROM mydb1.mytable; |
| 23:17.22 | bigdog_ut | lol...messing with you herlo |
| 23:18.09 | Utah_Dave | herlo: can you fix my MySQL problems? :) |
| 23:18.21 | herlo | Utah_Dave: what are you trying to do exactly? |
| 23:18.55 | bigdog_ut | Utah_Dave, what system are you on? |
| 23:18.55 | Utah_Dave | I'm trying to do a REPLACE DELAYED but it's not delaying. |
| 23:18.55 | bigdog_ut | os? |
| 23:18.55 | *** join/#uphpu brasto (n=brasto@71-219-136-168.slkc.qwest.net) |
| 23:18.55 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 23:18.55 | Utah_Dave | FC6, mysql 5.0.27 |
| 23:19.16 | herlo | Utah_Dave: is it innoDB? |
| 23:19.22 | Utah_Dave | myisam |
| 23:19.30 | bigdog_ut | ok, rpm -qa | grep mysql* | xargs -i sudo rpm -e "{}" |
| 23:19.35 | bigdog_ut | i would do that |
| 23:19.38 | brasto | is there an estimated attendance number for this Thursday - when I'm presenting on parsing RSS with PHP5? |
| 23:19.47 | herlo | bigdog_ut: don't be mean |
| 23:19.53 | bigdog_ut | lol |
| 23:20.02 | Utah_Dave | thanks, bigdog_ut! |
| 23:20.14 | herlo | Utah_Dave: don't run it, bigdog_ut is being a punk |
| 23:20.14 | bigdog_ut | then do yum install postgresql |
| 23:20.15 | Utah_Dave | that worked great! |
| 23:20.28 | herlo | ~poo bigdog_ut |
| 23:20.33 | jbot | ACTION summons a troop of flying monkeys to fling their poo at bigdog_ut |
| 23:20.39 | bigdog_ut | lol |
| 23:20.42 | *** join/#uphpu brasto (n=brasto@71-219-136-168.slkc.qwest.net) |
| 23:20.42 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 23:21.09 | bigdog_ut | Utah_Dave knows never to listen to me |
| 23:21.19 | herlo | bigdog_ut: seems like he does |
| 23:21.28 | brasto | i got disconnected for a few seconds, if anyone replied to my question, please reply again. |
| 23:21.35 | bigdog_ut | when teaching solaris cert class i let my class run rm -fr / |
| 23:21.39 | Utah_Dave | herlo: should I switch to innoDB and just do a REPLACE? |
| 23:21.43 | bigdog_ut | on the last day |
| 23:21.48 | herlo | Utah_Dave: no |
| 23:21.58 | herlo | innoDB doesn't support DELAYED supposedly |
| 23:22.08 | herlo | but did notice something in your sql |
| 23:22.13 | Utah_Dave | but doesn't it just do a row lock? |
| 23:22.16 | brasto | wps, macnewbold, is this Thursday still good for presenting on RSS parsing with PHP5? |
| 23:23.16 | macnewbold | brasto: the meeting is on the 3rd Thursday, which is the 21st this month - next week |
| 23:23.23 | brasto | I'm wondering because of the SLLUG mtg Wednesday, and the possible conflict with finals and Christmas vacations |
| 23:23.25 | brasto | ah |
| 23:23.35 | brasto | i'm *mostly* prepared |
| 23:23.41 | macnewbold | Utah_Dave: I don't think MyISAM supports row-level locking |
| 23:23.43 | brasto | and i'll be very ready by then |
| 23:24.07 | macnewbold | so why is the insert taking so long? Is it one query with a ton of rows? |
| 23:24.11 | herlo | Utah_Dave: if you were using innoDB, you could use LOW_PRIORITY |
| 23:24.14 | brasto | However, December 23rd may be even worse since it's 2 days before Christmas |
| 23:24.23 | macnewbold | ah |
| 23:24.42 | macnewbold | Utah_Dave: there's a note on the link you pasted that says that delayed is ignored if it is an insert select |
| 23:24.46 | macnewbold | so that's part of why |
| 23:24.53 | Utah_Dave | macnewbold: MyISAM doesn't do row-level blocking, but innoDB does |
| 23:24.57 | Utah_Dave | macnewbold: you're right. |
| 23:25.10 | macnewbold | does it need to be atomic, or could you do a select followed by an insert? |
| 23:25.12 | brasto | wps, macnewbold, Utah_Dave et al, should I send an email to the list to see who might come? |
| 23:25.21 | Utah_Dave | I've been trying REPLACE now and supposedly it does do delayed |
| 23:25.26 | macnewbold | are you using innoDB or MyISAM for the table you're inserting it into? |
| 23:25.32 | Utah_Dave | macnewbold: no it doesn't need to be atomic at all |
| 23:25.38 | Utah_Dave | both tables are MyISAM |
| 23:26.14 | *** join/#uphpu swb (n=designsi@70.98.111.41) |
| 23:26.18 | wps | I'm planning on being there on the twenty-first |
| 23:26.28 | *** mode/#UPHPU [+v swb] by ChanServ |
| 23:26.37 | macnewbold | where does it say that replace into ... select from; supports delayed? is there another page besides the insert delayed page? |
| 23:26.55 | brasto | brb in a bit |
| 23:27.00 | macnewbold | if you can separate it out into multiple single-row inserts instead of one giant one, you might have better luck |
| 23:27.06 | Utah_Dave | http://dev.mysql.com/doc/refman/5.0/en/replace.html |
| 23:27.09 | herlo | Utah_Dave: are you getting any errors back from mysql? |
| 23:27.46 | herlo | Utah_Dave: that's the one I am reading too |
| 23:28.08 | Utah_Dave | macnewbold: the problem is a lot of the rows need to be updated, based on a primary key, and the others need to be inserted |
| 23:28.38 | macnewbold | right, but a select and a bunch of replaces was what I meant |
| 23:28.40 | macnewbold | would that work? |
| 23:28.48 | Utah_Dave | herlo: where should I look for errors? I'm not seeing any being returned |
| 23:29.05 | Utah_Dave | macnewbold: it might work. how would that query work? |
| 23:29.17 | herlo | Utah_Dave: so it's probably inserting...right? just not delayed? |
| 23:29.25 | herlo | err, replacing rather |
| 23:29.43 | macnewbold | the replace page says it can support delayed, but since it says it works exactly like insert, except that it might delete a row first, I'm guessing delayed doesn't work with replace if it wouldn't work with the same query as an insert |
| 23:29.48 | Utah_Dave | yeah, it's doing the replace without the delay |
| 23:30.11 | Utah_Dave | macnewbold: that appears to be what's happening |
| 23:30.20 | macnewbold | Utah_Dave: you'd have to do two parts (with a script or maybe stored procedure or something): first select the rows you're copying, then run a replace for each one |
| 23:30.33 | macnewbold | a bunch of short queries rather than one huge uninterruptible one that locks the table |
| 23:30.42 | macnewbold | or go to innoDB and do row-level locks |
| 23:31.27 | bigdog_ut | use a stored proc |
| 23:31.36 | Utah_Dave | we tried innoDB, but it slowed down the whole database so much that we couldn't tell if the insert was faster or not |
| 23:32.16 | bigdog_ut | lol |
| 23:32.44 | Utah_Dave | macnewbold: if we do a select, then a bunch of inserts, how do we glue those together? |
| 23:33.20 | macnewbold | what do you mean glue them together? |
| 23:33.45 | macnewbold | I thought they didn't need to be atomic together |
| 23:34.08 | brasto | wps, good point - it's the 21st - macnewbold make note of that. I'll send an email to the list next week to see if anyone has suggestions like mac did last month. In that same email, i'll see if there will be a good turnout. |
| 23:34.22 | wps | sounds great |
| 23:34.39 | bigdog_ut | Utah_Dave, a stored procedure will help with that |
| 23:34.44 | Lone_Wanderer | I feel like this company is a tiger and I have been given the job of taming it. |
| 23:35.20 | brasto | see y'all laterz |
| 23:35.20 | Lone_Wanderer | And we've missed you! |
| 23:35.26 | Lone_Wanderer | (Just kidding, I have no idea who you are.) |
| 23:35.31 | brasto | lol |
| 23:35.34 | *** part/#uphpu brasto (n=brasto@71-219-136-168.slkc.qwest.net) |
| 23:35.35 | swb | see ya brasto, looking forward to your presentation |
| 23:35.40 | swb | doh |
| 23:36.20 | swb | did I miss a discussion about the RSS presentation? |
| 23:36.37 | bigdog_ut | swb, yes you missed it all |
| 23:37.14 | swb | awwww |
| 23:37.15 | Utah_Dave | bigdog_ut, herlo, macnewbold, OK, I'll look into a stored procedure that does that. Thanks for trying to help, guys |
| 23:38.35 | bigdog_ut | Utah_Dave, a stored proc will allow you to do that all in a atomic action (notice not transaction because im not sure that the table will allow the rollback) however you will be able to do crud in the stored proc |
| 23:39.46 | Utah_Dave | ok, that sounds like my best bet. We're already doing most of this in a stored procedure anyway |
| 23:48.07 | dataw0lf | mraaaaaaaaaawr |
| 23:48.12 | cyco|w | whoa |
| 23:48.18 | Lone_Wanderer | err, wolf |
| 23:48.22 | dataw0lf | :D |
| 23:48.27 | cyco|w | hey dw, aren't you coming up here? |
| 23:48.31 | dataw0lf | next Friday |
| 23:48.36 | cyco|w | sweet man.. |
| 23:49.04 | dataw0lf | cyco|w: let me guess. YOU'RE DOWN FOR DRINKING SOME ALCOHOL, AIN'T YAH? |
| 23:49.05 | timinator | DW: you're down here next Friday? |
| 23:49.10 | dataw0lf | timinator: yessir |
| 23:49.20 | Lone_Wanderer | is "down here" in Salt Lake? |
| 23:49.25 | dataw0lf | correct. |
| 23:49.33 | cyco|w | dw, c'mon.. like you even have to ask me that.. |
| 23:49.37 | Lone_Wanderer | Whereabouts do you go to drink alcohol? |
| 23:49.44 | dataw0lf | cyco|w: that's why I did it so sarcastically |
| 23:49.58 | cyco|w | ahh.. |
| 23:50.01 | cyco|w | the republican |
| 23:50.09 | Lone_Wanderer | There's a bar called The Republican? |
| 23:50.10 | dataw0lf | sounds good to me! |
| 23:50.29 | cyco|w | yeah, as in republic of ireland republican.. |
| 23:50.37 | cyco|w | not democrap or republican |
| 23:50.37 | Lone_Wanderer | Where is it? |
| 23:50.48 | Lone_Wanderer | I've never heard of it. Not that I've been in the loop for very long or anything. |
| 23:50.50 | cyco|w | ~950 south state |
| 23:50.53 | Lone_Wanderer | ok |
| 23:51.43 | cyco|w | d-dub, you have my number still? |
| 23:56.03 | dataw0lf | no sirree bob |
| 23:56.21 | *** join/#uphpu jsmith_ (n=jsmith@dsl017-122-217.mci1.dsl.speakeasy.net) |