| 00:16.35 | mgeary | hey, i don't do much with mysql transactions, but if, within a transaction, you're inserting multiple rows, are you able to grab the *next* (not the last) auto-increment ID and rest assured that no other simultaneous insert could also be using that ID? |
| 00:19.12 | *** join/#uphpu _psychic__ (~johnander@64.0.193.30) |
| 00:19.12 | *** mode/#UPHPU [+v _psychic__] by ChanServ |
| 00:24.05 | SunSparc | Night all!!! |
| 00:32.18 | josephscott | $chuck-fact |
| 00:32.55 | *** join/#uphpu raifbot (~raifbot@ec2-184-73-163-211.compute-1.amazonaws.com) |
| 00:36.38 | josephscott | $chuck-fact |
| 00:36.38 | raifbot | Although it is not common knowledge, there are actually three sides to the Force: the light side, the dark side, and Chuck Norris. |
| 00:37.45 | *** part/#uphpu mgeary (~mgeary@166.70.44.49) |
| 00:42.26 | josephscott | $lart carmony |
| 00:42.27 | raifbot | gives carmony a good seeing to. |
| 00:42.33 | josephscott | $rlart |
| 00:43.12 | *** join/#uphpu raifbot (~raifbot@ec2-184-73-163-211.compute-1.amazonaws.com) |
| 00:43.36 | josephscott | $rlart |
| 00:43.36 | raifbot | hits Heartsbane with an anvil and laughs with a contralto voice ... Haha Ha HA Ha. |
| 00:43.50 | josephscott | $lart carmony |
| 00:43.50 | raifbot | beats carmony into protomatter with the andromeda galaxy. |
| 00:43.57 | josephscott | $lart mindjuju |
| 00:43.57 | raifbot | takes out mindjuju with the trash. |
| 00:44.04 | josephscott | $rlart |
| 00:44.04 | raifbot | slams Heartsbane against a large cement Tux. |
| 00:44.11 | josephscott | $rlart |
| 00:44.11 | raifbot | hauls josephscott up by the scruff of the neck and spanks him until he waddles. |
| 00:44.17 | josephscott | $rlart |
| 00:44.17 | raifbot | gives unum a "free" copy of Windows and then charges double for "Upgrades". |
| 00:44.26 | josephscott | ok, lart feature works now :-) |
| 01:09.53 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 01:09.53 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 01:28.08 | *** join/#uphpu DexterTh1Dragon (~admin@cartkev.fttp.xmission.com) |
| 02:24.13 | ninnypants | $chuck-fact |
| 02:24.13 | raifbot | The Great Wall of China was originally created to keep Chuck Norris out. It failed misserably. |
| 02:31.53 | *** join/#uphpu wps (~wps@63-224-110-223.slkc.qwest.net) |
| 02:31.53 | *** mode/#UPHPU [+o wps] by ChanServ |
| 02:36.16 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 02:36.16 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 02:36.28 | carmony | ~lart dexterthedragon |
| 02:36.28 | ibot | --purges dexterthedragon |
| 02:36.45 | DexterTheDragon | ~dtdhit carmony |
| 02:36.45 | ibot | ACTION stikes at carmony with the evil rooster chop blinding carmony in one eye! |
| 02:40.12 | *** join/#uphpu macnewbold (~Adium@c-98-202-75-24.hsd1.ut.comcast.net) |
| 02:40.12 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 02:45.29 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 02:45.29 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 02:59.42 | *** join/#uphpu wps_ (~wps@63-224-110-223.slkc.qwest.net) |
| 02:59.42 | *** mode/#UPHPU [+o wps_] by ChanServ |
| 03:48.47 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 03:48.47 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 04:19.51 | *** join/#uphpu itimber (~Adium@106.73.124.24.cm.sunflower.com) |
| 04:19.51 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 04:31.04 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 04:31.04 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 04:35.41 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 04:53.04 | *** join/#uphpu wps_ (~wps@63-224-110-223.slkc.qwest.net) |
| 04:53.05 | *** mode/#UPHPU [+o wps_] by ChanServ |
| 04:55.46 | josephscott | $crypt hello |
| 04:55.46 | raifbot | josephscott - crypt( 'hello' ) : $1$ckfH7mdY$.Pz.vcmIfqnkHEbpdwgrQ0 |
| 04:55.56 | josephscott | $md5 hello |
| 04:55.56 | raifbot | josephscott - md5( 'hello' ) : 5d41402abc4b2a76b9719d911017c592 |
| 04:56.15 | DexterTheDragon | $chuck-fact |
| 04:56.15 | raifbot | Chuck Norris is what Willis was talking about |
| 04:58.51 | josephscott | $rot13 hello |
| 04:58.51 | raifbot | josephscott - rot13( 'hello' ) : uryyb |
| 04:59.00 | josephscott | $rot13 uryyb |
| 04:59.00 | raifbot | josephscott - rot13( 'uryyb' ) : hello |
| 05:01.54 | josephscott | $uuencode hello |
| 05:01.54 | raifbot | josephscott - uuencode( 'hello' ) : %:&5L;&\` |
| 05:02.04 | josephscott | $uudecode %:&5L;&\` |
| 05:02.04 | raifbot | josephscott - uudecode( '%:&5L;&\`' ) : hello |
| 05:02.10 | DexterTheDragon | $chuck-fact |
| 05:02.10 | raifbot | Chuck Norris owns the greatest poker face of all-time. It helped him win the 1983 world series of poker despite him holding just a joker, a 2 of clubs, a 7 of spades, and a green number 4 from Uno and a monopoly âget out of jail freeâ card. |
| 05:03.01 | josephscott | $8ball did carmony's db server ever stop using swap? |
| 05:03.01 | raifbot | josephscott - Ask again later. |
| 05:03.30 | josephscott | $chuck-fact |
| 05:03.30 | raifbot | Chuck Norris' iPod came with a real charger instead of just a USB cord |
| 05:04.11 | josephscott | $host yahoo.com |
| 05:04.11 | raifbot | josephscott - host( 'yahoo.com' ) : 67.195.160.76 |
| 05:04.51 | carmony | nope, it just recently swapped |
| 05:05.14 | carmony | but it takes like 2 hours to get to a point where it hits swap |
| 05:07.03 | josephscott | any idea why? |
| 05:08.36 | carmony | well, to be honest, its probably because I don't know how to tune mysql |
| 05:09.10 | DexterTheDragon | mindjuju: ping |
| 05:09.31 | carmony | I just kinda guess when I make changes to my.cnf |
| 05:09.43 | carmony | educated guesses, but they are more like guesses than decisions |
| 05:17.12 | josephscott | $lart mysql |
| 05:17.12 | raifbot | takes a rusty axe and swings it violently, taking mysql's head off. |
| 05:17.37 | DexterTheDragon | ~lart mysql |
| 05:17.37 | ibot | gives mysql an extra strength ACME sleeping pill, sending mysql to sleep for 150 years, and awakening to seven strange dwarfs and a large apple |
| 05:18.06 | josephscott | $lart ibot |
| 05:18.06 | raifbot | blasts ibot to oblivion with a kamehameha wave. |
| 05:25.45 | *** join/#uphpu wps (~wps@63-224-110-223.slkc.qwest.net) |
| 05:25.45 | *** mode/#UPHPU [+o wps] by ChanServ |
| 05:31.10 | josephscott | $weather Sandy, UT |
| 05:31.10 | raifbot | Clear 15f / -9c Humidity: 79% Wind: E at 7 mph |
| 05:32.07 | josephscott | $weather 95826 |
| 05:32.07 | raifbot | josephscott - Current weather for 95826 - Clear 40f / 4c Humidity: 98% Wind: N at 0 mph |
| 05:37.23 | *** join/#uphpu SunSparc (~sparky@c-67-172-224-227.hsd1.ut.comcast.net) |
| 05:37.23 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 05:43.02 | josephscott | $weather Sandy, UT |
| 05:43.02 | raifbot | current weather for Sandy, UT - Clear 15f / -9c Humidity: 79% Wind: E at 7 mphjosephscott - current weather for Sandy, UT - Clear 15f / -9c Humidity: 79% Wind: E at 7 mph |
| 05:43.27 | josephscott | $weather Sandy, UT |
| 05:43.27 | raifbot | josephscott - current weather for Sandy, UT - Clear 15f / -9c Humidity: 79% Wind: E at 7 mph |
| 05:43.56 | josephscott | $weather outside |
| 05:43.57 | raifbot | josephscott sorry, I couldn't get weather data for outside |
| 05:44.09 | *** join/#uphpu wps (~wps@63-224-110-223.slkc.qwest.net) |
| 05:44.09 | *** mode/#UPHPU [+o wps] by ChanServ |
| 05:45.28 | *** join/#uphpu SunBot (~SunBot@c-67-172-224-227.hsd1.ut.comcast.net) |
| 05:45.28 | SunBot | Hello There! |
| 05:45.28 | SunBot | I am a bot. Written in 33 lines of Python code. Beat that raifbot. ;) |
| 05:46.20 | SunSparc | heh |
| 05:46.34 | josephscott | I was actually going to write raifbot in python, wanted to play with PHP anonymous functions though, this was an easy excuse :-) |
| 05:47.53 | josephscott | if you want to go on line count, simple PHP bot in 20 lines |
| 05:48.05 | josephscott | but you know Perl would come along and do it in one :-) |
| 05:49.25 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 05:51.12 | josephscott | $weather salt lake city, UT |
| 05:51.12 | raifbot | current weather for salt lake city, UT - Partly Cloudy 19f / -7c Humidity: 85% Wind: N at 0 mphjosephscott - current weather for salt lake city, UT - Partly Cloudy 19f / -7c Humidity: 85% Wind: N at 0 mph |
| 05:52.00 | josephscott | hmmm, that wasn't quite right |
| 05:55.48 | josephscott | $weather Reno, NV |
| 05:55.48 | raifbot | josephscott - current weather for Reno, NV - Partly Cloudy 26f / -3c Humidity: 81% Wind: N at 3 mph |
| 05:55.59 | josephscott | better |
| 05:56.46 | josephscott | $weather Reno, NV |
| 05:56.46 | raifbot | josephscott -* current weather for Reno, NV - Partly Cloudy 26f / -3c Humidity: 81% Wind: N at 3 mph |
| 06:03.04 | josephscott | $weather outside |
| 06:03.05 | raifbot | josephscott sorry, I couldn't get weather data for outside |
| 06:03.10 | josephscott | $weather outside |
| 06:03.10 | raifbot | josephscott -* sorry, I couldn't get weather data for outside |
| 06:03.55 | josephscott | $8ball is time to go to bed? |
| 06:03.55 | raifbot | josephscott - Cannot predict now. |
| 06:07.53 | *** join/#uphpu itimber (~Adium@106.73.124.24.cm.sunflower.com) |
| 06:07.53 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 06:14.05 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 06:14.05 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 06:19.07 | *** join/#uphpu summerbug13 (~summerbug@202.129.235.27) |
| 06:19.13 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 06:23.34 | *** part/#uphpu summerbug13 (~summerbug@202.129.235.27) |
| 06:53.53 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 06:53.53 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 07:00.33 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 07:00.33 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 07:28.13 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 07:28.13 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 07:46.39 | *** join/#uphpu optikal (optikal@failcore.com) |
| 07:46.39 | *** mode/#UPHPU [+v optikal] by ChanServ |
| 09:30.51 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 11:20.39 | *** join/#uphpu itimber (~Adium@106.73.124.24.cm.sunflower.com) |
| 11:20.39 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 11:30.53 | *** join/#uphpu itimber (~Adium@106.73.124.24.cm.sunflower.com) |
| 11:30.53 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 13:16.45 | influx | ? |
| 13:16.47 | influx | 'lo? |
| 13:57.38 | jsmith | Howdy influx |
| 13:57.48 | jsmith | Morning all! |
| 14:15.35 | influx | mornin' jsmith |
| 14:15.41 | influx | :] |
| 14:38.54 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 14:38.54 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 15:04.29 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 15:04.29 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 15:14.43 | *** join/#uphpu Utah_Dave (~Utah_Dave@72-166-51-162.dia.static.qwest.net) |
| 15:14.43 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 15:22.46 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 15:44.09 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 15:44.09 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 15:49.04 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 15:49.04 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:58.03 | influx | So I have been putting together a Karate tournament registration system and am nearly done. Once the project is complete, the user will be able to fill out personal details, choose their tournament divisions, order additional tickets, review their order before they click on a button that will take them to PayPal, and then be taken to a thankyou page that will insert into a database all the pertinent information they submitted. |
| 15:59.06 | influx | Currently, I am trying to determine the best way to ensure that a user can't just go to the review page and then directly to the thankyou page to have their information inserted without paying through paypal first. |
| 15:59.39 | influx | I have yet to think of anything. Can any of you? |
| 15:59.40 | mindjuju | ~DtD, pong |
| 16:02.08 | mindjuju | what parameters does paypal provide you after a successful transaction? |
| 16:02.49 | *** join/#uphpu thebigdog (~thebigdog@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 16:02.49 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 16:02.53 | influx | Other than any passthrough variables provided to it? I don't know. |
| 16:02.55 | influx | :| |
| 16:03.09 | mindjuju | how do you know the transaction was successful? |
| 16:03.40 | mindjuju | you can pass it variables and it pass them back to you? |
| 16:03.50 | macnewbold | influx: you probably want to use Paypal IPN (instant payment notification) |
| 16:04.00 | macnewbold | it's a non-spoofable way to get confirmation from paypal that they really paid |
| 16:04.10 | macnewbold | you'd want to finalize the order when you get that, rather than when they hit Thank You. |
| 16:04.32 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 16:04.33 | macnewbold | it's pretty easy - you just set up a url to receive their requests, which come as http(s) posts |
| 16:04.33 | influx | *nod* |
| 16:04.47 | influx | I'll take a gander. |
| 16:05.12 | influx | macnewbold: How would I securely determine that the post variable(s) came from paypal? |
| 16:05.19 | influx | whoop |
| 16:05.27 | influx | thought mindjuju said the IPN stuff. |
| 16:07.57 | macnewbold | influx: there's some authentication stuff they send for that purpose |
| 16:08.03 | macnewbold | based on a shared secret, if I recall correctly |
| 16:08.47 | macnewbold | i.e. they put some order details along with the secret and md5 it. on your end, you do the same, and if you don't get the same md5 its fake |
| 16:09.49 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 16:09.49 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:11.10 | influx | aye |
| 16:15.37 | *** join/#uphpu wps (~wps@76.8.223.101) |
| 16:15.37 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:15.47 | *** join/#uphpu jamund (~jamund@24-104-129.146.hfc.mediarain.com) |
| 16:16.09 | mgeary | now THIS is awesome: http://challenge.gov/FCC/114-fcc-open-internet-apps-challenge |
| 16:17.25 | wps | I'm not getting any response from that link |
| 16:17.46 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 16:23.48 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 16:23.48 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 16:27.21 | *** join/#uphpu wps (~wps@76.8.223.101) |
| 16:27.21 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:38.37 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 16:38.37 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:45.43 | *** join/#uphpu utahcon (~utahcon@li51-147.members.linode.com) |
| 16:47.45 | *** join/#uphpu utahcon (~utahcon@li51-147.members.linode.com) |
| 16:47.45 | *** mode/#UPHPU [+v utahcon] by ChanServ |
| 16:48.56 | mindjuju | doesn't ces start today? |
| 16:49.12 | DexterTheDragon | yeep |
| 16:49.18 | mindjuju | heard that iphone coming to verizon, announcing at ces |
| 16:49.22 | mindjuju | course, that's just a rumor |
| 16:52.14 | fungus | that's a silly rumor |
| 16:52.23 | mindjuju | :) |
| 16:52.26 | fungus | When has Apple ever announced something significant at CES? |
| 16:52.29 | mindjuju | you don't think it'll happen/ |
| 16:52.41 | josephscott | does Apple even show up at CES? |
| 16:52.45 | fungus | Nope |
| 16:53.08 | utahcon | Apple doesn't do consumer electronics |
| 16:53.08 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 16:53.12 | utahcon | they do sheep electronics |
| 16:53.15 | fungus | But now that Macworld is gone, it's possible, but unlikely |
| 16:53.59 | mindjuju | wow, huh? |
| 16:54.05 | mindjuju | http://www.fastcompany.com/1714727/apple-launches-mac-app-store-sells-iphone-3gs-for-49-steals-cess-thunder |
| 16:55.56 | utahcon | wow |
| 16:55.58 | utahcon | $49 |
| 16:56.14 | utahcon | it is now the commodity phone |
| 16:56.26 | josephscott | <PROTECTED> |
| 16:56.38 | utahcon | josephscott: and the sheeple will eat it up like cake |
| 16:56.54 | josephscott | utahcon: not been watching tech for the last 20 years? |
| 16:57.04 | fungus | Almost commodity, still requires a data plan, that will keep it out of the commodity phone market for a while. |
| 16:57.06 | *** join/#uphpu jamund (~jamund@24-104-129.146.hfc.mediarain.com) |
| 16:57.07 | josephscott | old stuff comes down in price when new stuff is in the works/out |
| 16:57.52 | josephscott | hard to take anyone serious who claims the iphone is such a horrible device that only sheep buy it ;-) |
| 16:57.58 | utahcon | josephscott: I am really surprised that Apple has let the 3GS live. |
| 16:58.16 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 16:58.33 | *** join/#uphpu SunSparc (~sparky@24-104-129.146.hfc.mediarain.com) |
| 16:58.33 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 16:59.09 | fungus | It'll only live until iPhone 5 |
| 16:59.26 | mindjuju | so this "revolution" in computing, the mac store, it looks like a steam wanna-be |
| 16:59.31 | mindjuju | am i seeing this wrong? |
| 16:59.51 | josephscott | hard to tell exactly what might happen if verizon does indeed get the iphone |
| 17:00.04 | utahcon | mindjuju: I am with you there |
| 17:00.05 | josephscott | might alter the schedule a bit |
| 17:00.17 | jsmith | josephscott: I'm less interested in whether or not Verizon gets it than I am on whether or not it'll be LTE |
| 17:00.28 | jsmith | josephscott: (or, perhaps, CDMA+LTE) |
| 17:00.29 | mindjuju | ^5 utahcon |
| 17:00.36 | josephscott | seems unlikely it will be LTE |
| 17:00.50 | josephscott | mindjuju: steam is just a rip off of the FreeBSD ports system ;-) |
| 17:00.55 | *** join/#uphpu thebigdog (~thebigdog@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 17:00.55 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 17:01.19 | mindjuju | don't know about the freebsd port system, i'm guessing that's the ability to shop for apps and down loadthem? |
| 17:01.19 | SunSparc | josephscott: imitation is the highest form of flattery |
| 17:01.28 | josephscott | now a single iphone that works on verizon and at&t would be interesting |
| 17:01.37 | utahcon | josephscott: and a miracle |
| 17:01.48 | utahcon | gsm + cdma... haven't seen one of those in a while |
| 17:03.38 | josephscott | just a shot in the dark, but I get the feeling that battery life is something Apple is really going after in a big way |
| 17:03.51 | josephscott | wouldn't be surprised if the next iphone makes a big jump in that area |
| 17:03.58 | wps | I have an MySQL query that runs without error from MySQL Monitor, but via PHP mysql_query, it throws a syntax error |
| 17:04.04 | wps | any ideas? |
| 17:04.14 | josephscott | PHP syntax error? |
| 17:04.30 | wps | mysql syntax error |
| 17:04.35 | mindjuju | only fungus worries about battery life, i don't mind carrying a nuclear reactor to power my gear |
| 17:04.38 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 17:04.57 | thebigdog | wps what is the query? |
| 17:05.13 | fungus | If the nuclear reactor can fit nicely inside on not add much more weight, i'm all for that. |
| 17:05.21 | josephscott | does MySQL Monitor do it's own parsing, or does it send it to the server? |
| 17:05.40 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 17:06.11 | wps | thebigdog: http://d.pr/HGrC |
| 17:06.46 | josephscott | the PHP mysql libs probably didn't like the multistatment |
| 17:07.20 | thebigdog | yeah you might need the multi statement function is that the one you are using |
| 17:07.36 | wps | I wasn't aware of a multi-statement function |
| 17:07.56 | wps | mysqli_multi_query ? |
| 17:08.04 | josephscott | are you using http://php.net/manual/en/mysqli.multi-query.php ? |
| 17:08.12 | wps | I'll give that a try |
| 17:08.19 | wps | any reason to not always use mysqli_multi_query() ? |
| 17:08.19 | thebigdog | yeah that is the one |
| 17:08.25 | wps | it says one ore more |
| 17:08.37 | josephscott | to prevent use of multi-statements :-) |
| 17:08.44 | wps | ah |
| 17:08.47 | wps | thanks, gents |
| 17:08.59 | thebigdog | when you dont want multi statements in a trans |
| 17:10.34 | *** join/#uphpu _psychic_ (~johnander@64.0.193.15) |
| 17:10.34 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 17:10.35 | thebigdog | multi is great when you have queries that are a uow |
| 17:11.41 | wps | uow? |
| 17:11.53 | thebigdog | unit of work |
| 17:22.56 | wps | what's the "i" in mysqli_multi_query() ? |
| 17:23.23 | thebigdog | improved hehe |
| 17:23.27 | mindjuju | mysqli is improved |
| 17:23.28 | mindjuju | yeah |
| 17:23.30 | wps | thanks |
| 17:23.55 | thebigdog | cause the first extension sucked hehe |
| 17:24.13 | wps | can you mix and match use of mysql and mysqli functions in the same script? |
| 17:24.36 | mindjuju | it's the mysql driver for php |
| 17:24.39 | mindjuju | i don't think you could |
| 17:24.53 | wps | dangâ¦Â I really don't have time to rewrite my entire database class |
| 17:25.42 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 17:25.42 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 17:25.43 | *** part/#uphpu mgeary (~mgeary@166.70.44.49) |
| 17:25.53 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 17:26.28 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 17:26.28 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 17:27.24 | josephscott | $chuck-fact |
| 17:27.24 | raifbot | When Chuck Norris does a pushup, he isn't lifting himself up, he's pushing the Earth down. |
| 17:27.39 | mindjuju | $weather houston, texas |
| 17:27.39 | raifbot | mindjuju - current weather for houston, texas - Partly Cloudy 59f / 15c Humidity: 38% Wind: N at 6 mph |
| 17:27.50 | mindjuju | wow, it's cold in houston |
| 17:28.05 | eggyknap | The bots around here never cease to surprise me. |
| 17:28.08 | thebigdog | wps just dont combine your queries |
| 17:28.38 | wps | I'd actually rather not |
| 17:28.52 | wps | I thought I needed to because I need to lock the table while I run those several queries |
| 17:29.16 | wps | and my database class frees the result (connection) after each query |
| 17:29.29 | thebigdog | why do you have to lock the table |
| 17:30.01 | wps | I'm following this: |
| 17:30.01 | wps | http://dev.mysql.com/tech-resources/articles/hierarchical-data.html |
| 17:30.31 | wps | under "Adding New Nodes," three-quarters of the way down |
| 17:31.18 | eggyknap | Recursive queries are how that's supposed to be done (oh, and table locks suck) |
| 17:31.20 | thebigdog | for sure...pgsql fotw |
| 17:31.34 | wps | I'd love to switch to postgres but that's not an option today |
| 17:31.35 | eggyknap | Not that wps likely has the freedom to switch dbs like that. |
| 17:31.45 | wps | his recommendation to lock the table for that is sound, no? |
| 17:32.47 | eggyknap | Why would you need to lock the whole table? Is this assuming MyISAM or something? |
| 17:32.51 | thebigdog | man it sounds like he is lock to do trans |
| 17:33.16 | josephscott | yeah, trying to isolate any chances in the tree |
| 17:33.19 | josephscott | changes |
| 17:33.22 | wps | right |
| 17:33.28 | thebigdog | that is just so stupid imho |
| 17:33.34 | wps | what is stupid? |
| 17:33.44 | thebigdog | locking the table to create isolation |
| 17:33.59 | wps | what if another query changed something while the first was processing? you'd be screwed |
| 17:34.09 | eggyknap | Can you do something like SELECT ... FOR UPDATE to just lock the important rows? |
| 17:34.25 | thebigdog | that is what transactions are for |
| 17:34.40 | eggyknap | srsly |
| 17:34.45 | wps | k |
| 17:34.55 | wps | I don't know anything about transactions yet (on my to-do list) |
| 17:34.58 | josephscott | doing this kind of tree is one of those, possible, but at the sacrifice of many other things situation |
| 17:35.02 | eggyknap | In short, trying to fake transactions when you don't have them will cause awful performance, period. |
| 17:35.10 | eggyknap | Not to mention you'll probably get it wrong anyway :) |
| 17:35.15 | wps | k |
| 17:35.19 | wps | thanks for your opinions advice |
| 17:35.55 | josephscott | it's possible that getting the feature is more important than specific performance, for this particular case. But I'm stabbing in the dark on that one since I don't know what wps is working on :-) |
| 17:36.15 | wps | would your recommendations then be to keep my current system (Adjacency List Model, what he describes at the beginning of the article) for nowâ¦Â and then look into transactions for a future enhancement? |
| 17:36.16 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 17:36.42 | mindjuju | my understanding of a transaction is that it is a way of grouping SQL commands such that they all must collectively successfully execute, if any sql command fails, then they all roll back to what they were before and the whole transaction fails |
| 17:36.50 | thebigdog | wps what are you trying to modle? |
| 17:36.55 | wps | my reason for looking into this (Nested Set Model) is that it's MUCH better for performanceâ¦Â a single query instead of multiple |
| 17:36.55 | thebigdog | model |
| 17:36.59 | wps | navigation for a website |
| 17:37.14 | eggyknap | mindjuju: that's it, but it gets trickier than that. |
| 17:37.14 | wps | currently, I have to hit the database several times (in a recursive PHP function) to build the entire tree |
| 17:37.45 | thebigdog | how often are you doing multiple queries? |
| 17:37.49 | josephscott | wps: cache it? |
| 17:37.50 | mindjuju | @eggyknap, i've only used it on very basic levels |
| 17:37.52 | wps | every time a page loads |
| 17:37.54 | mindjuju | :) |
| 17:38.01 | thebigdog | wps: yeah cache it |
| 17:38.03 | wps | I can cache it, yesâ¦Â and that would eliminate the issue |
| 17:38.07 | thebigdog | mysql will cache much too |
| 17:38.16 | wps | kâ¦Â I was already planning on that (cahcing) |
| 17:38.18 | wps | thanks everyone |
| 17:38.20 | josephscott | yep, query cache in mysql could help |
| 17:38.29 | thebigdog | if the queries are constant, but memcache or another might work well |
| 17:38.56 | josephscott | how often is the nav changed? |
| 17:39.12 | wps | not very often |
| 17:39.14 | eggyknap | transaction presentation slides are here, though of little use without the accompanying presentation: https://github.com/eggyknap/eggyknap_preso/raw/master/TransactionSystems/transaction-systems.pdf |
| 17:39.35 | wps | thanks, eggyknap |
| 17:39.39 | josephscott | caching would likely be a big win, things that don't change very often usually have a high cache hit rate |
| 17:41.43 | josephscott | and much less hassle than trying to create a new complex system |
| 17:42.34 | wps | big waste of time |
| 17:43.39 | josephscott | better to find out now than after another two days |
| 17:43.44 | wps | indeed |
| 17:43.49 | wps | thanks, thebigdog |
| 17:43.54 | wps | I'd really like to learn postgres |
| 17:44.11 | thebigdog | it is a amazing for open source |
| 17:44.42 | mgeary | it seems annoyingly complex in some ways, but i suppose many new things appear that way |
| 17:45.04 | thebigdog | not really |
| 17:45.10 | thebigdog | it has some amazing features |
| 17:45.15 | thebigdog | even back in the day |
| 17:45.29 | mgeary | the whole multiple schemas, multiple databases, multiple whatnots that i don't even understand |
| 17:45.33 | mgeary | bah |
| 17:45.45 | josephscott | in the way early days (research project UCB) it has some really amazing (and complex) features |
| 17:45.54 | thebigdog | oh schemas are freaking awesome |
| 17:45.58 | josephscott | like point in time queries, that would be awesome to have |
| 17:46.13 | wps | alright, next question |
| 17:46.21 | thebigdog | eggyknap did a great job on the presentation |
| 17:46.22 | wps | (I'm going to keep you guys on topic todayâ¦Â no talking about CES :) ) |
| 17:46.28 | thebigdog | he has some good stuff in there like 2pc |
| 17:46.31 | herlo | wps: heh |
| 17:46.34 | wps | I have a function that recursively queries the database and builds an array |
| 17:46.38 | eggyknap | mgeary: that's mysql's fault, actually -- schemas are in teh SQL standard; MySQL's databases are the equivalent of the SQL standard "schema" |
| 17:46.40 | herlo | nobody like CES until *after* announcemetns are made |
| 17:46.49 | wps | but it's not building it right |
| 17:46.54 | wps | I need it to be flat |
| 17:46.54 | wps | http://d.pr/GHXE |
| 17:47.00 | herlo | see, that's just craziness |
| 17:47.03 | wps | there's a paste to the function and the output |
| 17:47.04 | eggyknap | thebigdog: were you there, and did I meet you? I know we've chatted before, but I don't have a face to pin to the nick :) |
| 17:47.06 | herlo | spewing from josephscott's mouf |
| 17:47.20 | stderr | eggyknap: are you emotionally scarred? |
| 17:47.20 | thebigdog | wps we used schemas back in the day for that project we worked on |
| 17:47.24 | josephscott | oops, extra S :-) |
| 17:47.28 | eggyknap | stderr: very. |
| 17:47.30 | eggyknap | :) |
| 17:47.32 | thebigdog | eggyknap: no i just read your pres |
| 17:47.32 | stderr | then you probably saw him |
| 17:47.49 | thebigdog | ^5 stderr hehe |
| 17:47.52 | stderr | hehe ^5 |
| 17:48.01 | wps | I've tried everything I can think of to keep the recursion to not nest but can't get it |
| 17:48.13 | thebigdog | i have done some cool stuff imho with pgsql |
| 17:48.50 | thebigdog | schemas where just the start of it all |
| 17:49.07 | thebigdog | and views are amazing too i love them |
| 17:49.18 | eggyknap | we're using schemas + custom data types to work around all kinds of limitations in various automatic query tools |
| 17:49.29 | eggyknap | Works nicely, but it takes a bit to grok the workflow. |
| 17:49.57 | thebigdog | custom data types are really nice |
| 17:50.19 | thebigdog | and postgis is so killer |
| 17:50.25 | josephscott | I've used domains in pgsql to do some fun stuff |
| 17:51.00 | thebigdog | domains are way cool too |
| 17:51.26 | thebigdog | i love to use domains for addresses |
| 17:52.05 | thebigdog | and stored procedures are way cool |
| 17:52.08 | eggyknap | I haven't had much use for domains, myself |
| 17:52.14 | eggyknap | stored procs on the other hand... |
| 17:52.16 | thebigdog | there are some limitations, but still rocking |
| 17:53.01 | thebigdog | cursors are nice too |
| 17:53.48 | josephscott | for people coming from an Oracle/DB2/MS SQL/Sybase/etc. back ground PostgreSQL usually lines up better with their expectations than MySQL |
| 17:54.09 | thebigdog | so true |
| 17:54.57 | thebigdog | now oracle i will take over the other ones |
| 17:55.06 | thebigdog | i hate db2 and sybase with a passion |
| 17:55.11 | herlo | I actually found terminology and such to be confusing coming from MySQL to postgresql |
| 17:55.29 | thebigdog | i think that is expected |
| 17:56.09 | herlo | yes, but I was just saying I think it makes things harder if you already know one... |
| 17:56.22 | josephscott | MySQL has a history of doing things a little different, so going from MySQL to almost anything else will likely involve a bigger shift |
| 17:57.06 | josephscott | then there was msql before that, but I don't think anyone uses that anymore |
| 17:59.11 | josephscott | yeah, last release was almost 5 years ago - http://www.hughes.com.au/ - I'd consider that dead then |
| 17:59.49 | mgeary | heh. well, by that logic, you'd almost have had to consider RHEL dead ;) |
| 17:59.56 | josephscott | lol |
| 18:00.14 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 18:00.15 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 18:00.27 | mgeary | ~nudge jsmith |
| 18:00.27 | ibot | ACTION elbows jsmith until he gets jsmith's attention |
| 18:00.54 | jsmith | mgeary: Huh? RHEL is anything but dead! |
| 18:01.09 | mgeary | ~rib jsmith |
| 18:01.10 | ibot | ACTION sharpens her elbows and jabs them playfully into jsmith's ribs, "i'm just sayin'!" |
| 18:01.10 | SunSparc | ~Internet |
| 18:01.10 | ibot | for pr0n! |
| 18:01.37 | macnewbold | speaking of which, we had a funny thing happen today |
| 18:01.47 | josephscott | $chuck-fact |
| 18:01.47 | raifbot | If paper beats rock, rock beats scissors, and scissors beats paper, what beats all 3 at the same time? Answer: Chuck Norris. |
| 18:01.58 | macnewbold | coworker had an email coming to him that got held up in spam quarantine, one of the reasons was that it mentioned porn terms |
| 18:02.30 | macnewbold | topic of the email was the "farm" servers (aka cloud/grid servers) at our hosting company - that was the only thing in the email we could remotely think might be porn related |
| 18:03.13 | josephscott | $lart farm servers |
| 18:03.14 | raifbot | takes a large goose feather pillow and swings it wildly in farm servers's direction, hitting farm servers and sending farm servers flying into the closet. |
| 18:06.34 | josephscott | $lart chuck norris |
| 18:06.34 | raifbot | josephscott are you insane? I'm not risking a round house kick from Chuck just to satisfy your lart'ing needs. |
| 18:06.41 | thebigdog | oh actually by Alice In Chains...i love that song |
| 18:08.11 | thebigdog | man you guys hear about that accident in SLC, i thought it was another bomb scare at my office |
| 18:08.34 | herlo | thebigdog: no, what was it? |
| 18:09.09 | thebigdog | http://www.ksl.com/index.php?nid=148&sid=13900756 |
| 18:09.18 | thebigdog | just crazy |
| 18:09.53 | thebigdog | dude must have been cruising |
| 18:10.26 | herlo | wow |
| 18:14.03 | thebigdog | but that chevy could be fixed and still run for sure |
| 18:14.05 | thebigdog | sad though |
| 18:14.22 | herlo | seemed the truck was at fault from what I could tell |
| 18:15.02 | eggyknap | Seems like a bunch of fatal wrecks lately. But one of 'em was my neighbor, so perhaps that's why it seems that way |
| 18:15.26 | mindjuju | ouch |
| 18:15.30 | eggyknap | srsly |
| 18:15.49 | eggyknap | She drove off I-215 a couple days ago. Left three kids and a husband. |
| 18:15.57 | *** join/#uphpu brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 18:15.57 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 18:16.30 | mindjuju | scarry |
| 18:16.32 | mindjuju | scary |
| 18:16.51 | herlo | eggyknap: wow, slid off or just drove off? |
| 18:32.16 | Utah_Dave | eggyknap: I read about that. |
| 18:32.20 | Utah_Dave | crazy |
| 18:32.47 | Utah_Dave | They say she slid 40 or 50 feet along the barrier before it fell off. Really sad |
| 18:41.09 | mindjuju | wow, that one guy asking for a free antivirus opened a flamewar on FOSS / MS / MS security essentials |
| 18:41.32 | mindjuju | letter posted to PLUG |
| 18:42.08 | herlo | mindjuju: that's PLUG for you |
| 18:42.56 | mindjuju | it's interesting to see the escalation |
| 18:45.59 | jsmith | No, it's sick and twisted to follow PLUG |
| 18:46.26 | josephscott | is there something in the water down there? |
| 18:46.39 | DexterTheDragon | jsmith: I think you answered your own question |
| 18:46.55 | jsmith | DexterTheDragon: I'm glad somebody caught it :-) |
| 18:46.58 | influx | Paypal provides the seller with the buyer's contact information, yeah? |
| 18:47.27 | herlo | jsmith: I have the entire mailing list marked as read when the messages come in. On occasion, there are good things down that way... |
| 18:47.42 | herlo | influx: it depends |
| 18:49.44 | influx | On what does it depend? |
| 18:50.07 | herlo | influx: you reading the documentation :) |
| 18:51.07 | influx | Enlightening. |
| 18:51.11 | influx | Thank you. |
| 18:51.37 | josephscott | $lart herlo |
| 18:51.37 | raifbot | slaps herlo around with a large trout. |
| 18:51.55 | mindjuju | $weather houston, texas |
| 18:51.55 | raifbot | mindjuju - current weather for houston, texas - Partly Cloudy 62f / 17c Humidity: 34% Wind: NW at 6 mph |
| 18:52.04 | mindjuju | wow, nice and warm |
| 18:52.22 | mindjuju | $weather orem, utah in the artic circle |
| 18:52.22 | raifbot | mindjuju - sorry, I couldn't get weather data for orem, utah in the artic circle |
| 18:52.33 | mindjuju | $weather orem, utah |
| 18:52.34 | raifbot | mindjuju - current weather for orem, utah - Partly Cloudy 23f / -5c Humidity: 74% Wind: NE at 1 mph |
| 18:53.05 | mindjuju | and people complain about the humidity in texas, psh! |
| 18:53.47 | josephscott | $weather sandy, ut |
| 18:53.47 | raifbot | josephscott - current weather for sandy, ut - Partly Cloudy 25f / -4c Humidity: 66% Wind: E at 3 mph |
| 18:54.00 | josephscott | $weather sandy, ut |
| 18:54.00 | raifbot | josephscott -* current weather for sandy, ut - Partly Cloudy 25f / -4c Humidity: 66% Wind: E at 3 mph |
| 18:54.19 | carmony | lol |
| 18:54.27 | carmony | I'm going to call josephscott the compression nazi ;) |
| 18:54.57 | josephscott | I like to think of it as being selfish, if everyones sites are faster then I don't have to wait so long for them to load :-) |
| 18:55.29 | carmony | haha, true true |
| 18:55.31 | herlo | josephscott: why thanks |
| 18:56.00 | herlo | influx: seriously though, the details are a bit dependent on what information you want to have your customers provide in the api |
| 18:56.31 | herlo | influx: so reading the documentation is kind of important. It depends on the service, privacy policy and a bunch more stuff |
| 18:57.53 | josephscott | $lart slow sites |
| 18:57.53 | raifbot | chops slow sites in half with a free AOL CD. |
| 18:59.37 | mindjuju | $lart josephscott |
| 18:59.37 | raifbot | hooks into a hydrant and hoses josephscott down. |
| 19:00.26 | mindjuju | wow, transformation complete |
| 19:00.53 | mindjuju | we've gone from anti-virus software -> MS -> FOSS -> Democracy |
| 19:03.38 | carmony | ok, wth, I'm closing my connections via mysql_close |
| 19:03.50 | carmony | yet it still shows them opened on the server? |
| 19:07.21 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 19:07.21 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 19:12.07 | *** join/#uphpu TuxToaster (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 19:12.15 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 19:12.15 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 19:27.21 | carmony | wth, I'm getting a call from the BBB :P |
| 19:28.16 | utahcon | anyone with experience on a polycom soundstation 6000 ? I keep booting to a blank screen |
| 19:30.24 | mindjuju | utahcon, that's a good question for utah_dave or jsmith |
| 19:31.03 | jsmith | utahcon: Sorry, no clue... |
| 19:31.17 | carmony | rofl, now I know why they called me |
| 19:31.44 | carmony | they wanted me to sign up for their accreditation, aka $400 a year :P |
| 19:33.04 | mindjuju | is that for carmony tech or ddna? |
| 19:33.11 | carmony | Carmony Tech |
| 19:33.16 | carmony | which is really weird |
| 19:33.21 | carmony | since I have such a small pool of customers |
| 19:33.52 | mindjuju | they are prolly just going down the list from the utah list of businesses |
| 19:34.10 | mindjuju | normally i think it's good to be listed with the BBB, but for consultants, not so sure |
| 19:34.24 | mindjuju | prolly good arguments for and against |
| 19:36.30 | redroy | does anyone know of a quick way to rig mamp to work with oracle db? |
| 19:37.13 | redroy | I need to temporarily connect to oracle for a project but don't want to mess with my current setup too much |
| 19:42.28 | josephscott | there are oracle extensions for PHP, you'd need to get one of those installed |
| 19:44.30 | jsmith | ibot: join #utah |
| 19:45.26 | redroy | josephscott, thanks I'll keep digging further |
| 19:49.15 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 20:01.31 | fungus | redroy, you need to download and install an Oracle Client, InstantClient is sufficient. |
| 20:01.45 | fungus | Then build the extension, and load it into PHP |
| 20:02.02 | fungus | http://us.php.net/manual/en/oci8.installation.php |
| 20:02.28 | josephscott | nice that Oracle has reasonable support for PHP now |
| 20:02.45 | fungus | Then when you are done, just remove the oci8.so extension |
| 20:03.05 | mindjuju | sounds pretty easy |
| 20:03.13 | josephscott | years ago I remember having to download a leaked oracle lib for freebsd and then hack that to death to get anything useful to build |
| 20:03.27 | josephscott | from a russian ftp site no less |
| 20:03.36 | fungus | hehe, that would suck. |
| 20:04.29 | fungus | Ever since Oracle Instantclient, most of these libraries became much easier. |
| 20:04.42 | josephscott | it was, interesting, to be sure |
| 20:05.23 | josephscott | even MS supports PHP now for SQL Server, so you know the world is coming to an end any day now ;-) |
| 20:06.13 | fungus | Getting PHP to connect to SQL Server was always a pain, with TDS and such. |
| 20:07.46 | josephscott | yep, used TDS several times years ago |
| 20:08.02 | redroy | fungus, mucho thanks! |
| 20:10.22 | fungus | eww |
| 20:10.46 | mindjuju | ~lart jsmith $lart jsmith |
| 20:10.46 | ibot | send killer squirrels to attack jsmith $lart jsmith |
| 20:10.49 | jsmith | But that was going on close to ten years ago |
| 20:10.59 | mindjuju | darn, hoping that would do both |
| 20:10.59 | jsmith | I've certainly learned my lessons since :-p |
| 20:11.15 | jsmith | mindjuju: ibot doesn't know about pipes |
| 20:11.19 | jsmith | ~pipe mindjuju |
| 20:11.39 | mindjuju | josephscott, can you maike raif have a pipe |
| 20:12.31 | josephscott | any pattern you can write code for it should be able to support |
| 20:12.41 | jsmith | ibot: pipe $victim is <action> puts $victim in his pipe and lights $victim up |
| 20:12.41 | ibot | jsmith: okay |
| 20:12.45 | jsmith | ~pipe mindjuju |
| 20:12.45 | ibot | ACTION puts mindjuju in his pipe and lights mindjuju up |
| 20:27.05 | carmony | ok, who wants to help me figure out why my connections are not closing? :P |
| 20:40.26 | macnewbold | ~seen beandog |
| 20:40.38 | ibot | beandog <~steve@gentoo/developer/beandog> was last seen on IRC in channel #uphpu, 14d 3h 2m 36s ago, saying: 'dunno.'. |
| 20:46.28 | *** join/#uphpu Muad`Dib (~sparky@24-104-129.146.hfc.mediarain.com) |
| 20:46.28 | *** mode/#UPHPU [+v Muad`Dib] by ChanServ |
| 20:48.47 | *** join/#uphpu thebigdog (~thebigdog@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 20:48.47 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 20:49.07 | carmony | see, look at this: |
| 20:49.08 | carmony | http://screencast.com/t/UozyaI2zdjGJ |
| 20:49.12 | carmony | bloody crazy |
| 20:50.31 | thebigdog | carmony: pretty, you should cut your connection times down |
| 20:52.20 | josephscott | yikes |
| 20:54.21 | carmony | whats where is when the # of connections climb, the web server CPU is like at 30%, and when it goes down, the web server CPU is closer to 80-90% |
| 20:54.36 | thebigdog | yeah |
| 20:54.44 | thebigdog | you can turn down your wait timeout |
| 20:54.58 | carmony | wait timeout? |
| 20:55.08 | carmony | for php's mysql config? |
| 20:55.21 | thebigdog | on the database |
| 20:55.25 | *** join/#uphpu _psychic_ (~johnander@64.0.193.15) |
| 20:55.25 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 20:56.26 | thebigdog | what is your current wait_timeout on your db? |
| 20:57.16 | carmony | rofl |
| 20:57.16 | carmony | 28800 |
| 20:57.29 | thebigdog | oh wow |
| 20:57.39 | thebigdog | set that to like 60 |
| 20:58.03 | thebigdog | or is that you threads created? |
| 20:58.10 | thebigdog | cause that is crazy high |
| 20:58.44 | thebigdog | how many threads are in your cache? |
| 20:59.04 | josephscott | 8 hours |
| 20:59.57 | *** join/#uphpu TuxToaster (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 21:01.15 | carmony | how can I tell how many threads are in my cache? |
| 21:01.29 | thebigdog | show status |
| 21:01.41 | thebigdog | Threads_cached |
| 21:02.16 | thebigdog | you might want to find a happy median for you wait_timeout |
| 21:02.42 | thebigdog | same with your thread cache |
| 21:03.00 | thebigdog | not sure on your average connections |
| 21:03.04 | carmony | ah, 65 |
| 21:03.52 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 21:04.07 | thebigdog | you will want to montior the threads created |
| 21:04.15 | thebigdog | that tells you that you are creating more than your cache |
| 21:04.35 | carmony | and I have a threads created |
| 21:04.38 | carmony | er |
| 21:04.44 | carmony | threads_cache_size of 80 |
| 21:04.45 | thebigdog | so when that numbers starts to slow down then your cache is getting at that money spot |
| 21:06.06 | carmony | thebigdog: you know mysql and mysql performance tuning very well? |
| 21:10.51 | fungus | carmony, have you ever used mysqlreport? Great tuning tool. Usually comes with MySQL server in most distributions. |
| 21:11.05 | fungus | http://hackmysql.com/mysqlreportguide Will give you lots of details on how to understand it. |
| 21:11.15 | *** join/#uphpu TuxToaster (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 21:15.04 | thebigdog | carmony: yeah i have done db tuning and server tuning |
| 21:15.18 | thebigdog | and everything in between |
| 21:21.48 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 21:23.58 | thebigdog | carmony: http://www.mysqlperformanceblog.com/ |
| 21:24.16 | thebigdog | that book is a really good read |
| 21:24.26 | josephscott | that blog is great, good stuff in there |
| 21:40.28 | *** join/#uphpu TuxToaster (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 21:42.25 | *** join/#uphpu supernovia (~supernovi@76.8.222.23) |
| 21:49.05 | josephscott | $chuck-fact |
| 21:49.05 | raifbot | Chuck Norris can sit in the corner of a circular room |
| 21:51.59 | _psychic_ | Wouldn't everyone be sitting in a corner if they're against the wall? |
| 21:52.18 | josephscott | $chuck-fact |
| 21:52.18 | raifbot | If you can see Chuck Norris, he can see you. If you can't see Chuck Norris you may be only seconds away from death. |
| 21:59.20 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 22:01.25 | *** join/#uphpu jamund (~jamund@24-104-129.146.hfc.mediarain.com) |
| 22:09.33 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 22:11.07 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 22:18.28 | *** part/#uphpu josephscott (~josephsco@74.200.246.169) |
| 22:18.39 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 22:18.40 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 22:18.55 | josephscott | $chuck-fact |
| 22:18.55 | raifbot | Chuck Norris doesnât wear a watch. HE decides what time it is. |
| 22:25.43 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 22:25.43 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 22:25.57 | jkr801 | hey thebigdog |
| 22:28.14 | thebigdog | hey jkr801 |
| 22:28.46 | jkr801 | you see the new droid bionic thebigdog? |
| 22:30.54 | thebigdog | yeah with the dual cpu |
| 22:31.20 | thebigdog | or dual core i mean |
| 22:34.00 | thebigdog | dual core hit faster than i thought i was thinking 2nd quarter |
| 22:34.09 | thebigdog | but man the battery is going to suck hard |
| 22:34.40 | thebigdog | i am waiting for a tab w/ honeycomb - that will be awesome |
| 22:52.57 | thebigdog | mac lovers - http://pastebin.com/1eWf9LCg |
| 22:53.04 | thebigdog | now that is pretty fast |
| 22:55.14 | josephscott | let the arms race begin :-) |
| 22:57.09 | SunSparc | thebigdog: Nice |
| 22:57.50 | thebigdog | hehe |
| 22:57.55 | thebigdog | that is not mine thouh |
| 22:58.02 | thebigdog | i guess that is now all over the web |
| 22:58.08 | thebigdog | only took about 12 hours |
| 22:58.47 | SunSparc | Free apps for all. |
| 22:58.52 | SunSparc | Thanks Apple. |
| 22:59.14 | thebigdog | i wonder how many people like angry birds is pissed now |
| 22:59.49 | fungus | I doubt it will work with all apps. Since the receipt verification is always app dependent, and not required. |
| 23:00.27 | fungus | I am more likely to think that Angry Birds devs, and others, probably didn't do a good job actually checking the receipt. |
| 23:04.58 | thebigdog | some are saying it is working for most apps |
| 23:07.44 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 23:11.58 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 23:14.00 | carmony | lol |
| 23:14.06 | carmony | I was checking the stats on my memcache instance |
| 23:14.28 | carmony | and one refresh it was doing 6666.6 r/s |
| 23:17.58 | carmony | think I should try running two instances of memcache? |
| 23:18.14 | josephscott | if the data breaks out nicely that can help |
| 23:18.29 | josephscott | I believe memcached is single threaded, so the process will only use one CPU |
| 23:18.45 | josephscott | I know that is the case for redis |
| 23:19.04 | josephscott | so some folks have take to running multiple copies on the same box to soak up more CPU |
| 23:21.12 | thebigdog | can you force redis to use a certain cpu? |
| 23:21.29 | thebigdog | would suck if they used the same one hehe |
| 23:21.45 | josephscott | that would mean your OS CPU scheduler would suck |
| 23:22.01 | josephscott | http://www.cyberciti.biz/tips/setting-processor-affinity-certain-task-or-process.html |
| 23:22.22 | josephscott | $google linux cpu affinity |
| 23:22.22 | raifbot | josephscott searching http://www.google.com/search?q=linux+cpu+affinity -- http://www.cyberciti.biz/tips/setting-processor-affinity-certain-task-or-process.html -- http://www.linuxjournal.com/article/6799 -- http://www.ibm.com/developerworks/linux/library/l-affinity.html |
| 23:23.46 | thebigdog | yeah though i have seen some linux boxes that do not push to the other cpu all that much not sure why |
| 23:23.57 | thebigdog | and some solaris as well |
| 23:24.13 | josephscott | sucky cpu scheduler ;-) |
| 23:24.55 | thebigdog | what gets me is that solaris is solid with threading |
| 23:25.04 | thebigdog | and cpus |
| 23:25.43 | thebigdog | oh i remember is was perl yeah thats it |
| 23:34.41 | josephscott | $rlart |
| 23:34.41 | raifbot | rm -rf's ChanServ. |
| 23:40.43 | carmony | lol, I love it when I google something |
| 23:40.57 | carmony | and I find in the results my blog with the answer |
| 23:41.08 | josephscott | :-) |
| 23:41.31 | josephscott | that's why I started a blog, to remember the things I knew I would forget |
| 23:55.22 | carmony | ok, if I wanted to run two instances of memcached, how would I do that? |
| 23:56.46 | josephscott | just run it twice, on different ports |