| 00:04.01 | mgeary | hey |
| 00:04.10 | mgeary | anyone ever gotten a "table is full" error from mysql? |
| 00:04.46 | mgeary | i'm getting it on a table with 7.5 million records -- 11.1 GB |
| 00:04.55 | mgeary | myisam |
| 00:04.55 | brasto | nope... |
| 00:05.29 | mgeary | yeah |
| 00:05.31 | mgeary | me too |
| 00:06.04 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 00:06.06 | brasto | usually determined by operating system constraints on file sizes, not by MySQL internal limits |
| 00:06.11 | brasto | http://dev.mysql.com/doc/refman/5.0/en/full-table.html |
| 00:06.44 | brasto | mgeary, did you find that page? |
| 00:06.54 | mgeary | yeah, reading it |
| 00:07.23 | brasto | google "I'm Feeling Lucky" for: "table is full" mysql |
| 00:07.30 | brasto | I wonder... |
| 00:07.40 | brasto | ~google "table is full" mysql |
| 00:08.57 | brasto | ~google $1 is <action> http://google.com/search?q=$1 |
| 00:09.22 | brasto | ~google "table is full" mysql |
| 00:09.30 | brasto | oh well... |
| 00:09.44 | mgeary | that page itself is actually not very useful |
| 00:42.31 | timinator | I'm out... later guys |
| 00:46.53 | mgeary | ~hungry |
| 00:46.53 | jbot | extra, extra, read all about it, hungry is http://www.thehungersite.com/ or http://www.thehungersite.com/cgi-bin/WebObjects/HungerSite or http://www.hungryminds.com/ |
| 00:48.26 | mindjuju | ~mgeary |
| 00:48.26 | jbot | methinks mgeary is not a vedic astrologer |
| 00:48.36 | mindjuju | curious |
| 00:48.51 | mindjuju | jbot, mgeary is also the resident flash guru |
| 00:48.52 | jbot | go do something useful |
| 00:49.18 | mindjuju | jbot, no, mgeary is also the resident flash guru |
| 00:49.19 | jbot | okay, mindjuju |
| 00:49.26 | mindjuju | ~mgeary |
| 00:49.26 | jbot | well, mgeary is not a vedic astrologer, or the resident flash guru |
| 00:49.38 | mindjuju | much better |
| 00:49.55 | mgeary | so i'm neither vedic nor a flash guru. works for me |
| 00:50.20 | mindjuju | oh wait, yeah, bummer |
| 00:50.55 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 00:50.55 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 00:51.29 | mindjuju | jbot, forget mgeary |
| 00:51.29 | jbot | i forgot mgeary, mindjuju |
| 00:51.46 | mgeary | hey, someone remind me how to specify a non-backreferenced parenthesis in a regex |
| 00:51.49 | mindjuju | jbot mgeary is the resident flash guru and not a vedic astrologer |
| 00:51.49 | jbot | go do something useful |
| 00:52.21 | mgeary | that is, i want it to be invisible to $1 backreferences, but i want to group an OR (something|somethingelse) |
| 00:57.06 | mindjuju | k, got confused by regex question, what was it you were looking for? how to regex a ) or go backstream and find a ) for a particular start point? |
| 00:58.01 | bradym | mgeary: "A "?" directly after |
| 00:58.01 | bradym | <PROTECTED> |
| 00:58.01 | bradym | character determines the purpose of the match (?:a|b|c) will match any of a b or c without producing a backreference" |
| 00:58.09 | bradym | http://www.faqs.org/faqs/perl-faq/part1/ |
| 00:58.23 | mgeary | that's what i thought. thanks |
| 01:02.56 | mindjuju | ~mgeary |
| 01:03.32 | mindjuju | jbot, mgeary is the resident flash guru and not a vedic astrologer |
| 01:03.32 | jbot | go do something useful |
| 01:03.51 | mindjuju | jbot, mgeary is also the resident flash guru and not a vedic astrologer |
| 01:03.52 | jbot | go do something useful |
| 01:03.57 | mindjuju | ~flip jbot |
| 01:03.58 | jbot | ACTION gives jbot the .|.. ..|. |
| 01:04.25 | *** join/#uphpu Utah_Dave (n=coveylin@69.27.14.174) |
| 01:04.38 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 01:04.49 | Utah_Dave | anyone got time for a quick linux question? |
| 01:05.14 | mindjuju | mgeary $1 is <reply> the resident flash guru or not a vedic astrologer |
| 01:05.19 | mindjuju | freak! |
| 01:05.27 | mgeary | reply? |
| 01:05.38 | mindjuju | jbot, mgeary is <reply> the resident flash guru or not a vedic astrologer |
| 01:05.39 | jbot | go do something useful |
| 01:05.45 | mgeary | heh |
| 01:05.51 | mindjuju | curious |
| 01:05.57 | mindjuju | ~stressed |
| 01:05.58 | jbot | Looks like I picked the wrong week to quit amphetamines! |
| 01:06.12 | mindjuju | jbot, testFubar is fubar |
| 01:06.13 | jbot | okay, mindjuju |
| 01:06.23 | mindjuju | jbot, forget testFubar |
| 01:06.23 | jbot | mindjuju: i forgot testfubar |
| 01:06.33 | mindjuju | jbot, mgeary is the resident flash guru |
| 01:06.34 | jbot | go do something useful |
| 01:06.37 | mgeary | all kinds of difficulties ensure when a term has both a "term $1" and a "term" definition |
| 01:07.09 | mindjuju | that's really curious |
| 01:07.33 | mindjuju | ~mgeary |
| 01:12.20 | bradym | Utah_Dave: what's up? i might be able to help |
| 01:12.45 | Utah_Dave | I have a script I want to run on boot. |
| 01:13.05 | Utah_Dave | I'm googling around and it appears I need to copy it to init.d and make a link somewhere else |
| 01:13.47 | bradym | what distro? |
| 01:14.25 | Utah_Dave | fedora 8 |
| 01:15.58 | burnin | /etc/rc.local |
| 01:16.15 | burnin | you can launch a script from there. |
| 01:17.05 | Utah_Dave | burnin: so I just copy the script there and it will be run on boot? |
| 01:17.26 | burnin | yes, or put a command in there to launch the script. |
| 01:17.28 | burnin | how big is it? |
| 01:17.36 | Utah_Dave | it's just a one line script |
| 01:17.45 | burnin | ah, k, rc.local is the way to do it then. |
| 01:17.47 | Utah_Dave | it mounts a samba share |
| 01:18.07 | bradym | Utah_Dave: rc.local is a file, just copy your command into it |
| 01:18.17 | Utah_Dave | oh, OK |
| 01:18.33 | Utah_Dave | sweet |
| 01:18.38 | burnin | is it a password protected share? |
| 01:18.59 | Utah_Dave | nope |
| 01:19.15 | burnin | k, was just concerned about rc.local being readable by regular users. |
| 01:20.09 | Utah_Dave | well, if there's somebody logged into this machine then we're in bigger trouble than somebody knowing about this backup location |
| 01:20.51 | Utah_Dave | ok, running rc.local mounted it correctly. |
| 01:21.01 | Utah_Dave | now I'm going to reboot and make sure it really mounts it. |
| 01:21.10 | Utah_Dave | thanks, burnin and bradym |
| 01:21.13 | *** part/#uphpu Utah_Dave (n=coveylin@69.27.14.174) |
| 01:21.14 | burnin | np |
| 01:21.49 | mgeary | jbot: forget mgeary $1 |
| 01:21.49 | jbot | mgeary: i didn't have anything called 'mgeary $1' to forget |
| 01:22.02 | mgeary | that's what's causing you probs, mindjuju |
| 01:25.12 | mindjuju | curious |
| 01:25.15 | mindjuju | ~mgeary |
| 01:25.31 | mgeary | ~mgeary mindjuju |
| 01:25.32 | jbot | go do something useful |
| 01:25.34 | mgeary | see? |
| 01:25.46 | mgeary | it's the <action> that's getting you |
| 01:25.46 | mindjuju | yeah |
| 01:25.55 | mindjuju | i thought i was making progress, but seem to be stuck on something |
| 01:26.07 | *** join/#uphpu Utah_Dave (n=coveylin@69.27.14.174) |
| 01:26.08 | mgeary | but you can't kill an action if there's also a factoid |
| 01:26.13 | mgeary | ~forget mgeary |
| 01:26.13 | jbot | mgeary: i didn't have anything called 'mgeary' to forget |
| 01:26.19 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 01:26.30 | Utah_Dave | sweet, that worked perfectly. |
| 01:26.37 | Utah_Dave | thanks guys |
| 01:27.07 | Utah_Dave | ~poke mindjuju |
| 01:27.08 | jbot | ACTION cuts down a small tree, sneaks up behind mindjuju, pokes mindjuju repeatedly, hilarity ensues. |
| 01:27.56 | mindjuju | ~poke |
| 01:29.28 | Utah_Dave | ~fart mindjuju |
| 01:29.29 | jbot | ACTION farts in mindjuju's general direction |
| 01:30.02 | mindjuju | ~dhit utah_dave |
| 01:30.02 | jbot | ACTION appears right behind utah_dave and slaps him in the back of the head |
| 01:31.28 | Utah_Dave | ~pimpslap mindjuju |
| 01:31.28 | jbot | utah_dave pimpslaps mindjuju. ouch! |
| 01:33.10 | mgeary | anyone know how to kill multiple mysql processes (from SHOW PROCESSLIST) from the mysql> prompt? |
| 01:33.11 | mindjuju | mgeary, jbot seems to be all kinds of jacked up, i'm going to have to investigate further |
| 01:33.43 | mgeary | s/processes/threads |
| 01:43.02 | bradym | not sure how to do it from mysql prompt, but you can use mysqladmin kill id,id2,id3 |
| 02:00.37 | *** part/#uphpu Utah_Dave (n=coveylin@69.27.14.174) |
| 02:01.10 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 02:26.08 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 02:26.08 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:06.23 | mindjuju | frieddog ? |
| 03:09.29 | *** join/#uphpu jsmith (n=jsmith@68.247.223.142) |
| 03:09.29 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 06:15.49 | *** join/#uphpu bradym (n=bradym@c-98-207-18-133.hsd1.ca.comcast.net) |
| 06:15.50 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 14:26.04 | *** join/#uphpu jsmith (n=jsmith@68.247.223.142) |
| 14:26.04 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 14:53.02 | *** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 14:53.02 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 15:15.45 | *** join/#uphpu wps (n=wps@64.0.192.53) |
| 15:15.45 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:16.17 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 15:27.14 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 15:27.14 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 15:32.20 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 15:32.20 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 15:39.12 | timinator | morning guys |
| 15:39.35 | cole_joplin | Hi |
| 15:42.32 | thebigdog | morning |
| 15:45.33 | *** join/#uphpu macnewbol1 (n=mac@166-70-178-126.ip.xmission.com) |
| 15:45.33 | *** mode/#UPHPU [+o macnewbol1] by ChanServ |
| 15:50.35 | mindjuju | morning gents |
| 15:52.20 | thebigdog | oh so ready for the weekend |
| 15:52.43 | mindjuju | cold_joplin - did you see the new FMS came out? http://www.adobe.com/products/flashmediaserver/ |
| 15:52.58 | mindjuju | well, not out, but it on preorder |
| 15:55.27 | mindjuju | jsmith, i'm jealous, you're always eating tasty food over there |
| 15:56.07 | jsmith | mindjuju: Yes, I love to eat good food |
| 15:56.41 | thebigdog | im going to get some breakfast |
| 15:56.56 | jsmith | Well, all I had this morning was cheese, tomatoes, and salsa... no 'shrooms or sausage or peppers or anything |
| 15:57.06 | jsmith | But I did add some blue cheese crumbles |
| 15:58.57 | mindjuju | ~dhit utah_dave |
| 15:58.58 | jbot | ACTION performs Dog Collar of the Heavens on utah_dave |
| 15:59.24 | mindjuju | sorry, that was only for science |
| 16:00.38 | mindjuju | jsmith, is it possible to capture VOIP packets and then listen to what is being said? |
| 16:01.17 | jsmith | mindjuju: Sure.... |
| 16:02.13 | jsmith | Fire up Wireshark, capture the audio, then go to Statistics -> RTP -> Show all streams |
| 16:02.35 | jsmith | Select your forward (and optionally, reverse) streams, and then you can graph them, save them to an audio file, etc. |
| 16:02.50 | *** join/#uphpu mikesmullin (i=user@63.76.119.176) |
| 16:03.00 | mindjuju | i thought it was possible, but wasn't sure |
| 16:03.10 | jsmith | Very possible |
| 16:03.31 | jsmith | In fact, there's a company that just built a product that records VoIP calls entirely by listening to the network traffic |
| 16:03.53 | jsmith | (you just mirror a port on your network switch, and it listens and records all the calls) |
| 16:04.07 | mindjuju | that sounds pretty scary |
| 16:05.52 | jsmith | Oh, there are much scarier things in the world that that... remember, VoIP is just network traffic -- and we all know what's possible on the network |
| 16:06.32 | mindjuju | k, everybody watch the new powerful jbot attack! in honor of jsmith, the jattack! |
| 16:06.37 | mindjuju | ~jattack utah_dave |
| 16:06.38 | jbot | ACTION mirrors a port on utah_dave 's switch and listens to all the juicy phone calls! |
| 16:06.56 | jsmith | mindjuju: Nice one ;-) |
| 16:07.09 | mindjuju | ~jattack utah_dave |
| 16:07.09 | jbot | ACTION mirrors a port on utah_dave 's switch and listens to all the juicy phone calls! |
| 16:07.16 | mindjuju | dang, it's suppose to be random |
| 16:07.21 | mindjuju | ~jattack utah_dave |
| 16:07.22 | jbot | ACTION reprograms utah_dave 's caller ID so that it says Bill Gates |
| 16:08.17 | jsmith | ~jattack the room |
| 16:08.17 | jbot | ACTION reprograms the room phone to be the new AOL support line |
| 16:08.25 | mindjuju | heh |
| 16:09.43 | *** join/#uphpu pelaofeliz (n=PelaoFel@67.108.236.230) |
| 16:12.42 | *** join/#uphpu fungus (n=olsonl@2001:5c0:8fff:fffe:0:0:0:1647) |
| 16:12.42 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:16.07 | jsmith | s/dear/deer/ |
| 16:16.10 | jsmith | Man, I can't type today |
| 16:16.28 | jsmith | ... must ... take ... typing ... break ... |
| 16:19.37 | *** join/#uphpu brasto (n=brasto@out.lnxi.com) |
| 16:19.37 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 16:21.29 | brasto | ~seen mgeary |
| 16:21.32 | jbot | mgeary <n=mgeary@166.70.44.49> was last seen on IRC in channel #uphpu, 14h 47m 49s ago, saying: 's/processes/threads'. |
| 16:22.09 | brasto | that's hard to read... I guess ibot outputs like that for the html archived page? |
| 16:22.38 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:22.38 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:22.42 | brasto | ibot/jbot |
| 16:22.57 | brasto | funny, I just ~seen mgeary'd then you show up |
| 16:23.10 | mgeary | poof |
| 16:23.24 | mindjuju | mgeary = telepathic |
| 16:23.42 | brasto | lol. Last comment you had before I left yesterday was "that page itself is not very useful" - did you mean the mysql manual page or the google search page? |
| 16:23.51 | mgeary | the mysql manual page |
| 16:24.14 | brasto | Did you find that the limit was not in your os then? |
| 16:24.27 | mgeary | haven't found the cause yet, but none of those criteria appear to have been met |
| 16:24.33 | mgeary | generally speaking, the mysql docs aren't great, imho |
| 16:24.41 | brasto | interesting |
| 16:25.04 | mgeary | worked around the problem for now |
| 16:25.27 | jsmith | generally speaking, mysql isn't so great, imho |
| 16:25.31 | mgeary | heh |
| 16:25.51 | jsmith | Not trying to start a flamewar, just trying to be funny |
| 16:26.18 | mgeary | well, as you say this, i'm frantically running myisamcheck on a mission-critical db that appears to have crashed in some way. so i'm not inclined to argue the point ;) |
| 16:27.17 | jsmith | I did that once... took 12 days to finish fixing the data |
| 16:27.39 | jsmith | But I'm biased, so take my comments with a grain of salt |
| 16:27.42 | Utah_Dave | ~jattack mindjuju |
| 16:27.43 | jbot | ACTION reprograms mindjuju phone to be the new AOL support line |
| 16:27.52 | jsmith | (running one of the largest MySQL installations in the world will do that to you) |
| 16:29.03 | mindjuju | heya utah_dave, that was all for science, eh! |
| 16:29.08 | mindjuju | ;p |
| 16:30.19 | mgeary | while i'm waiting for this database repair... do you mysql users run myisamcheck or repair as a regular part of maintenance? or just when something goes wrong? |
| 16:30.44 | jsmith | Just when things go wrong |
| 16:30.50 | jsmith | Unless you're packing a database |
| 16:31.16 | brasto | brastotack jsmith and mgeary |
| 16:31.21 | brasto | doh! |
| 16:31.29 | brasto | ~brastotack jsmith and mgeary |
| 16:31.30 | jbot | ACTION lectures jsmith and mgeary on properly designed databases, normalization, writing quality code with comments, and active-voice writing until jsmith and mgeary can't take anymore and goes berserk. |
| 16:32.35 | jsmith | brasto: You're still preaching to the choir |
| 16:32.49 | brasto | I figured, but it was funny! |
| 16:43.08 | Utah_Dave | mindjuju: I just forwarded you an email with links to a mixer and microphone that my sound-nut friend sent me. |
| 17:01.45 | mindjuju | awesome! thx! |
| 17:04.01 | thebigdog | mindjuju, you there? |
| 17:04.38 | mindjuju | here |
| 17:07.10 | mindjuju | it's the anticipation that kills... |
| 17:09.33 | *** join/#uphpu kingsol (n=kingsol@64.0.193.254) |
| 17:18.26 | *** join/#uphpu synico (n=squish@pdpc/supporter/student/synic) |
| 17:18.27 | *** mode/#UPHPU [+v synico] by ChanServ |
| 17:19.03 | mindjuju | oh, we're talking in securely through PM |
| 17:19.35 | mindjuju | we're planning a hostile takeover of the nearest whopper king |
| 17:19.39 | mindjuju | whoppers for everybody! |
| 17:20.38 | thebigdog | and then im learning french |
| 17:23.48 | mindjuju | k |
| 17:24.11 | thebigdog | i have to take over the world you konw |
| 17:24.19 | thebigdog | ok what do i need to listen too |
| 17:24.39 | thebigdog | anyone remember that tv series amazing stories? |
| 17:27.41 | thebigdog | oh that is great album |
| 17:27.49 | thebigdog | i got the new alterbridge playing |
| 17:29.06 | mindjuju | man this album reminds me of jr high |
| 17:29.14 | thebigdog | no doubt |
| 17:29.21 | thebigdog | 8-9th grade man |
| 17:29.25 | mindjuju | exactly! |
| 17:29.58 | mindjuju | after black album they went down hill |
| 17:30.02 | mindjuju | i like the older rough cut stuff |
| 17:30.39 | brasto | I think I remember amazing stories |
| 17:30.41 | mindjuju | dataw0lf prolly grew up with pokemon instead of metallica |
| 17:30.50 | mindjuju | that's why he's off |
| 17:30.52 | thebigdog | yeah |
| 17:30.56 | thebigdog | i love the old stuff |
| 17:31.01 | thebigdog | ride the lightning |
| 17:31.19 | mindjuju | ride the lightning! for whom the bells toll! |
| 17:32.08 | thebigdog | yes |
| 17:32.08 | thebigdog | garbage days |
| 17:32.08 | thebigdog | garbage days revisted |
| 17:32.08 | dataw0lf | mindjuju: pft. When I was growing up, it was TMNT |
| 17:32.08 | mindjuju | did you ever hear them do Stone Cold Crazy? |
| 17:32.08 | thebigdog | yeah we had some of that too |
| 17:32.08 | thebigdog | yeah i love that song they did |
| 17:32.10 | brasto | TMNT was when I was in high school... I was still growing up. |
| 17:32.16 | mindjuju | TMNT was cool |
| 17:33.08 | thebigdog | thundercats...ho!!!! |
| 17:33.45 | mindjuju | the 80's -- the best! |
| 17:33.50 | thebigdog | that is why i asked if anyone remembers amazing stories tv series |
| 17:34.33 | thebigdog | http://en.wikipedia.org/wiki/Amazing_Stories_%28TV_series%29 |
| 17:35.22 | thebigdog | i got netflix queued to send me some tv series from back in the day |
| 17:58.13 | thebigdog | anyone have any good css tabs that are easy to work with |
| 17:59.11 | kingsol | does mysql create a temporary table any time you have multiple sorting options in a query? |
| 18:00.04 | pelaofeliz | kingsol: not necessarily |
| 18:00.34 | pelaofeliz | kingsol: usually it won't if you have the indexes you need |
| 18:07.44 | kingsol | interesting. |
| 18:08.08 | kingsol | so my query "ORDER BY cr_segment DESC, cr_conversion DESC" |
| 18:08.14 | kingsol | is creating a tmp table |
| 18:08.23 | kingsol | when I remove cr_conversion it does not |
| 18:08.28 | kingsol | should I index that column? |
| 18:09.01 | brasto | ~dude |
| 18:09.02 | jbot | Be most excellent to each other! |
| 18:09.10 | thebigdog | check the explain and see where it is doing table scan |
| 18:09.37 | pelaofeliz | kingsol: right -- if you have an index with both cr_segment and cr_conversion, it should be fine |
| 18:10.10 | kingsol | in the output of the explain, how do you know it is doing a table scan? |
| 18:10.15 | kingsol | thanks for the help by the way |
| 18:10.34 | thebigdog | http://dev.mysql.com/doc/refman/5.0/en/explain.html |
| 18:11.03 | thebigdog | that will tell you what each item is refering too |
| 18:11.27 | thebigdog | eq_ref and ref |
| 18:11.32 | thebigdog | under type |
| 18:11.52 | thebigdog | and others under type will help you |
| 18:11.52 | kingsol | awesome thank you thebigdog and pelaofeliz |
| 18:12.30 | thebigdog | i would suggest checking out mysql optimzations too |
| 18:12.32 | thebigdog | that is a good read |
| 18:13.00 | thebigdog | and checking variations of the where clause with explain |
| 18:13.25 | thebigdog | what indexes the query optimizer uses is dependent on the where clause and how it is setup |
| 18:14.01 | thebigdog | meaning...just becuase you have an index...does not mean that the query optimizer will use it |
| 18:14.27 | thebigdog | that has bite me in the butt various times |
| 18:15.55 | mgeary | whew |
| 18:15.59 | thebigdog | if you are using myisam and/or bdb tables i would run myisamchk --analyze to make sure you get the best results for the optimizer too |
| 18:16.04 | mgeary | the db seems to be happy again |
| 18:16.38 | brasto | mgeary: did you find the problem, or did myisamcheck take care of it without any info on what it did? |
| 18:17.06 | mgeary | it took care of it. had to run it multiple times, though |
| 19:12.19 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 19:12.20 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 19:13.01 | herlo | brasto: ping |
| 19:14.33 | herlo | brasto: hi |
| 19:17.58 | brasto | me too. it was a good conversation. it looks like our upper management wants us to take any courses on our own time, and work our normal 40 hours on top of it. so my immediate manager wants to turn it down since that seems unreasonable for a company to want to train it's employees and yet not train them on company time. |
| 19:18.42 | brasto | there are even enough people it would qualify for onsite, but they don't want to use up our precious hours at work with something as trivial as... training... |
| 19:20.03 | herlo | brasto: on site is bad though compared to at a training center. |
| 19:20.07 | brasto | I do empathize with our management though, and understand that sometimes these decisions are complicated. |
| 19:20.12 | brasto | ah |
| 19:20.25 | herlo | If onsite is the only way, that's okay, but I *highly* recommend at a training center |
| 19:20.29 | herlo | a couple reasons why |
| 19:21.01 | herlo | 1, when you are at the office, and someone needs you, they can just come and pull you out. This doesn't help your training experience |
| 19:21.10 | herlo | you miss vitally important things |
| 19:21.34 | brasto | they offer tuition reimbursement that I can use for such a thing if they do not choose to offer the training, but I'd have to fork up the dough myself and wait for the reimbursement. I may do this anyway, but it'd be after the holidays. |
| 19:21.36 | herlo | if you are 30-45 minutes away (at least), they not only hav eto pull you out, but then you have to get back, that's more time lost... |
| 19:22.09 | brasto | makes sense herlo |
| 19:24.00 | herlo | :) |
| 19:24.34 | herlo | brasto: the other reason is that providing reasonable equipment and environment is almost essential to the training experience |
| 19:25.00 | brasto | s/almost// |
| 19:25.03 | brasto | ;) |
| 19:25.45 | herlo | brasto: agreed |
| 19:26.19 | herlo | the thing is, when we do onsites, it takes twice as long to get everything set up and if the location doesn't set up the network correctly, it takes even longer. |
| 19:26.59 | *** join/#uphpu undertak1ngyou (n=will@71-219-84-28.slkc.qwest.net) |
| 19:35.34 | brasto | that makes three reasons |
| 19:37.06 | herlo | :) |
| 19:38.47 | herlo | brasto: that kind of goes along with onsites though, so maybe 2.5 reasons :) |
| 19:39.43 | brasto | true |
| 19:40.16 | brasto | jk |
| 19:57.35 | herlo | brasto: you crack me up |
| 20:01.30 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 20:01.30 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 20:03.01 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 20:28.05 | brasto | anyone here use testopia, formerly test runner? it's a plugin for bugzilla... |
| 21:47.34 | PoeticIntensity | got a pgsql question: |
| 21:47.43 | PoeticIntensity | Is there an easy way to determine the number of days which has passed? |
| 21:47.45 | PoeticIntensity | e.g.: |
| 21:47.59 | thebigdog | from a given time |
| 21:48.07 | PoeticIntensity | I have a timestamp field reflecting 3 days ago... |
| 21:48.13 | PoeticIntensity | and I know today's timestamp... |
| 21:48.22 | thebigdog | yeah using >< |
| 21:48.24 | PoeticIntensity | any way to get that returned as "3 days"? |
| 21:48.32 | PoeticIntensity | within the SQL? |
| 21:48.51 | PoeticIntensity | It's easy to do the math... I'm more concerned about formatting the result. |
| 21:49.06 | PoeticIntensity | in MySQL, there is a "TO_DAYS" function. |
| 21:49.09 | thebigdog | http://www.postgresql.org/docs/8.2/static/functions-datetime.html |
| 21:49.23 | PoeticIntensity | looking now. |
| 21:49.38 | PoeticIntensity | yeah... I've gone through that page before.... |
| 21:49.45 | PoeticIntensity | I was just hoping someone knew of something magical :) |
| 21:50.04 | thebigdog | yeah it is there |
| 21:50.15 | thebigdog | timestamp - '3 days' |
| 21:50.30 | thebigdog | result will be: interval 'something days' |
| 21:50.39 | PoeticIntensity | right... I need to get rid of the "intervale" portion. |
| 21:50.42 | thebigdog | timestamp - '3 day' |
| 21:50.44 | PoeticIntensity | er... interval. |
| 21:50.51 | thebigdog | interval is the datatype |
| 21:50.56 | thebigdog | that will not be returned |
| 21:51.00 | PoeticIntensity | oh.... |
| 21:51.03 | thebigdog | but will be the datatype it is in |
| 21:51.15 | thebigdog | like integer, timestamp |
| 21:51.18 | thebigdog | etc |
| 21:51.25 | PoeticIntensity | ah... |
| 21:51.49 | thebigdog | you will need to cast your '3 day' to and interval though |
| 21:52.07 | thebigdog | like this '3 day'::interval |
| 21:52.08 | PoeticIntensity | how do you cast in PSQL? |
| 21:52.12 | PoeticIntensity | gotcha. |
| 21:52.28 | PoeticIntensity | this might just work... |
| 21:52.32 | PoeticIntensity | thanks tons, thebigdog . |
| 21:52.41 | thebigdog | np |
| 21:53.08 | thebigdog | you can also use overlaps to check on the lapping of time |
| 21:53.13 | thebigdog | which is a killer function |
| 21:54.12 | thebigdog | you can also use cast( expression as type) too |
| 21:54.25 | thebigdog | like ('3' cast integer) |
| 21:54.40 | thebigdog | or cast('3 day' as interval); |
| 22:08.15 | *** join/#uphpu bradym (n=bradym@Qst4FC.quinstreet.com) |
| 22:08.15 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 22:28.11 | timinator | In SQL, is there a way to pipe the results from 1 query into another? |
| 22:28.49 | timinator | such as: SELECT `order_id` FROM `orders` WHERE `destination_id`=0 AND `destination_company`='' GROUP BY `order_id` | SELECT * FROM `orders` WHERE `order_id`=%d |
| 22:31.25 | undertakingyou | timinator: nested queries |
| 22:37.54 | thebigdog | timinator, can you combined the 2 queries into 1 |
| 22:38.22 | timinator | I'm working on that now... I bet that'll be the best solution |
| 22:38.23 | timinator | thx |
| 22:38.52 | thebigdog | for mindjuju |
| 22:51.46 | *** part/#uphpu brasto (n=brasto@out.lnxi.com) |
| 22:53.55 | thebigdog | oh yeah |
| 22:59.19 | timinator | I'm still having problems on my earlier MySQL question |
| 22:59.59 | timinator | I can't do a subquery, because each query produces >1 result |
| 23:00.16 | timinator | and I can't figure out how to do a JOIN as they are both using the same table |
| 23:00.34 | timinator | any suggestions? |
| 23:01.00 | pelaofeliz | timinator: have you tried using 'HAVING'? |
| 23:01.17 | timinator | no ....trying |
| 23:01.25 | pelaofeliz | e.g. SELECT `order_id` FROM `orders` WHERE `destination_id`=0 AND `destination_company`='' GROUP BY `order_id`HAVING order_id = %d |
| 23:13.21 | pelaofeliz | still no luck? |
| 23:16.44 | timinator | no |
| 23:19.18 | pelaofeliz | so what exactly are you trying to achieve? |
| 23:20.07 | thebigdog | what is your query now and what is your ddl |
| 23:20.19 | timinator | ddl? |
| 23:21.34 | thebigdog | schema |
| 23:21.45 | mindjuju | timinator, yeah ddl = database schema |
| 23:21.48 | mindjuju | how is it set up |
| 23:21.53 | timinator | ah |
| 23:21.53 | mindjuju | tables, columns and all of that |
| 23:22.20 | mindjuju | sorry gents, had to step out for lunch with the family to eat Indian food |
| 23:22.29 | mindjuju | well, Nepalese / Indian |
| 23:23.01 | timinator | it's alright guys.... I think this is something that'll require some PHP logic in between 2 queries.... and that I can do just fine |
| 23:23.03 | timinator | :) |
| 23:23.17 | thebigdog | ok |
| 23:23.31 | thebigdog | go ahead my smarty pants |
| 23:23.38 | timinator | :) |
| 23:23.42 | timinator | ~wps |
| 23:23.42 | jbot | [wps] Mr. Sexy Pants |
| 23:23.48 | thebigdog | hehe |
| 23:24.00 | mindjuju | timinator, if it is a report you're goign to hit with some frequency, you'll want it to be optomized, but you're right, if this is a one time deal, then fastest way is usually best |
| 23:24.03 | timinator | oh, that's Mr. Sexy Pants rather than Mr. Smarty Pants |
| 23:24.18 | timinator | 1 time deal |
| 23:24.22 | mindjuju | ~timinator |
| 23:24.23 | jbot | timinator is, like, the person formally known as timothy_, or owns his own business, or likes to wear a stetson and chaps with nothing else on! |
| 23:24.38 | timinator | ROTFLOL |
| 23:24.52 | mindjuju | jbot, timinator is also Mr. Smarty Pants |
| 23:24.53 | jbot | okay, mindjuju |
| 23:24.57 | timinator | totally forgot about that stetson thing |
| 23:24.59 | mindjuju | ~timinator |
| 23:25.00 | jbot | timinator is probably the person formally known as timothy_, or owns his own business, or likes to wear a stetson and chaps with nothing else on!. Mr. Smarty Pants |
| 23:25.29 | timinator | jbot, timinator is also who doesn't use Smarty |
| 23:25.30 | jbot | okay, timinator |
| 23:25.35 | timinator | ~timinator |
| 23:25.36 | jbot | i guess timinator is the person formally known as timothy_, or owns his own business, or likes to wear a stetson and chaps with nothing else on!. Mr. Smarty Pants, or who doesn't use Smarty |
| 23:25.47 | timinator | oh, that's no good |
| 23:26.15 | mindjuju | uh, you saw he only wears a stetson and some chaps, and chaps are a kind of pants |
| 23:26.24 | thebigdog | jbot, thebigdog hates smarty |
| 23:27.00 | mindjuju | ~jattack macnewbol1 |
| 23:27.00 | jbot | ACTION starts to capture macnewbol1 VOIP packets and post them to the web |
| 23:55.19 | timinator | I'm out.... later guys... |
| 23:56.30 | *** part/#uphpu pelaofeliz (n=PelaoFel@67.108.236.230) |
| 23:58.47 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |