| 00:07.46 | *** join/#uphpu macnewbold (~macnewbol@66.219.204.99.provo.dynamic.broadweavenetworks.net) |
| 00:07.47 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 00:15.41 | *** join/#uphpu Benni_Hanna (~Benni_Han@71-35-214-142.slkc.qwest.net) |
| 00:16.20 | *** join/#uphpu ryan__ (~ryan@c-98-202-195-16.hsd1.ut.comcast.net) |
| 01:01.59 | *** join/#uphpu TuxToaster (~TuxToaste@66.133.98.20) |
| 01:01.59 | *** mode/#UPHPU [+v TuxToaster] by ChanServ |
| 01:26.54 | *** join/#uphpu ryan__ (~ryan@c-98-202-195-16.hsd1.ut.comcast.net) |
| 01:38.12 | *** join/#uphpu supernovia (~Adium@208.64.91.46.static.utbb.net) |
| 01:38.12 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 01:55.11 | *** join/#uphpu ryan__ (~ryan@c-98-202-195-16.hsd1.ut.comcast.net) |
| 02:01.18 | *** join/#uphpu Benni_Hanna (~Benni_Han@71-35-214-142.slkc.qwest.net) |
| 02:09.37 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 02:09.37 | *** mode/#UPHPU [+v jnbek] by ChanServ |
| 02:14.18 | *** join/#uphpu ninnypan_ (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 02:18.50 | *** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 02:18.50 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 02:37.38 | *** join/#uphpu ryan__ (~ryan@c-98-202-195-16.hsd1.ut.comcast.net) |
| 02:52.18 | *** join/#uphpu HumanCell (~Humancell@207.224.214.130) |
| 03:13.53 | shanemhansen | oh snap |
| 03:13.54 | shanemhansen | http://www.reddit.com/r/PHP/comments/1l7baq/creating_a_user_from_the_web_problem/ |
| 03:49.38 | *** join/#uphpu josephscott (~josephsco@proxy.iad.automattic.com) |
| 03:54.57 | *** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 03:54.57 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 04:35.50 | *** join/#uphpu UtahDave (~Utah_Dave@c-174-52-220-233.hsd1.ut.comcast.net) |
| 05:09.30 | *** join/#uphpu UtahDave (~boucha@c-174-52-220-233.hsd1.ut.comcast.net) |
| 05:09.30 | *** mode/#UPHPU [+o UtahDave] by ChanServ |
| 05:14.30 | *** join/#uphpu mgeary_ (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 05:14.30 | *** mode/#UPHPU [+v mgeary_] by ChanServ |
| 05:20.31 | tierra | shanemhansen: wow, incredible |
| 05:23.38 | *** join/#uphpu mgeary_ (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 05:23.38 | *** mode/#UPHPU [+v mgeary_] by ChanServ |
| 12:44.11 | *** join/#uphpu eggyknap (~jtolley@sl5.endpoint.com) |
| 12:44.11 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 12:44.11 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 13:49.35 | *** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 13:49.35 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 13:55.52 | *** join/#uphpu MikeHansenMe (~mike@67.166.121.53) |
| 14:18.52 | *** join/#uphpu eggyknap_ (~jtolley@184-11-45-120.dr01.dlta.ut.frontiernet.net) |
| 14:20.13 | *** join/#uphpu itimber (~Adium@204.10.234.111) |
| 14:20.14 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 14:21.17 | *** join/#uphpu cro (~Adium@204-228-149-217.ip.xmission.com) |
| 14:22.26 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 14:22.26 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 14:27.27 | *** join/#uphpu macnewbold (~macnewbol@66.219.204.98.provo.dynamic.broadweavenetworks.net) |
| 14:27.27 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 14:27.38 | *** join/#uphpu mindjuju_ (~mindjuju@173-10-26-193-BusName-utah.ut.hfc.comcastbusiness.net) |
| 14:34.45 | *** join/#uphpu ryan__ (~ryan@2002:421d:b58e:0:4486:a6aa:e79b:668a) |
| 14:34.48 | *** join/#uphpu josephscott (~josephsco@proxy.iad.automattic.com) |
| 14:46.41 | *** join/#uphpu Benni_Hanna (~Benni_Han@neutroninteractive-xmission.xmission.com) |
| 14:51.05 | *** join/#uphpu MikeHansenMe (~mike@c-67-166-121-53.hsd1.ut.comcast.net) |
| 14:56.04 | *** join/#uphpu SunSparc (~jonathan@69-27-175-74.acedatacenter.com) |
| 14:56.04 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 14:56.16 | *** join/#uphpu mgeary (~mgeary@67.136.112.81) |
| 14:56.16 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 14:58.28 | *** join/#uphpu TuxToaster (~TuxToaste@66.219.204.99.provo.dynamic.broadweavenetworks.net) |
| 14:58.28 | *** mode/#UPHPU [+v TuxToaster] by ChanServ |
| 14:58.45 | *** join/#uphpu ryan__ (~ryan@66.29.181.142.static.utbb.net) |
| 15:03.30 | *** join/#uphpu ponderability (~Adium@happybunny.chpc.utah.edu) |
| 15:04.58 | *** join/#uphpu kendsnyder (~kendsnyde@67.214.245.39) |
| 15:04.58 | *** mode/#UPHPU [+v kendsnyder] by ChanServ |
| 15:09.08 | *** join/#uphpu supernovia (~Adium@208.64.91.46.static.utbb.net) |
| 15:09.08 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 15:09.53 | *** join/#uphpu kendsnyder (~kendsnyde@67.214.245.39) |
| 15:09.53 | *** mode/#UPHPU [+v kendsnyder] by ChanServ |
| 15:12.14 | *** join/#uphpu ninnypants (~ninnypant@unaffiliated/ninnypants) |
| 15:12.14 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 15:13.30 | *** join/#uphpu clintberry (~clintberr@75-148-102-17-Utah.hfc.comcastbusiness.net) |
| 15:13.30 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 15:13.32 | TuxToaster | ~rlart |
| 15:13.32 | infobot | throws ryan__'s poor little doggy off a cliff |
| 15:30.24 | ninnypants | josephscott: who runs the wpsitecare.com? Just noticed they're sponsoring WC SLC |
| 15:31.23 | josephscott | Ryan Sullivan |
| 15:31.36 | josephscott | hopefully he'll be at the meetup tonight |
| 15:33.32 | ninnypants | Cool I don't know that I've ever heard of him |
| 15:33.36 | josephscott | I've not met him before |
| 15:42.25 | ninnypants | josephscott: does he work with Patrick? |
| 15:42.39 | *** join/#uphpu UtahDave (~boucha@63.230.12.160) |
| 15:42.39 | *** mode/#UPHPU [+o UtahDave] by ChanServ |
| 15:42.48 | josephscott | no idea |
| 15:43.59 | ninnypants | I don't think so I was thinking he might be his friend that did the WC SLC logo but it doesn't look like it |
| 15:44.24 | *** join/#uphpu ryan__ (~ryan@66.29.181.142.static.utbb.net) |
| 15:49.16 | *** join/#uphpu wGEric (~wGEric@107.0.84.214) |
| 15:49.16 | *** join/#uphpu wGEric (~wGEric@unaffiliated/wgeric) |
| 15:55.56 | UtahDave | Hey, everyone. SaltStack is hiring: http://careers.stackoverflow.com/jobs/employer/SaltStack |
| 15:55.57 | UtahDave | http://saltstack.com/careers |
| 15:57.02 | *** join/#uphpu hhatfield (~hhatfield@64.147.139.68) |
| 15:57.03 | *** mode/#UPHPU [+v hhatfield] by ChanServ |
| 15:57.25 | UtahDave | The Systems Engineer position doesn't require mad Python skills, just some great system administration abilities and knowledge |
| 16:02.46 | unum | that's next door to my second job :) |
| 16:04.40 | UtahDave | nice. We are moving our office soon, though. We'll be down by 106th south |
| 16:05.05 | hhatfield | did carmony tell people we're hiring again? PHP dev |
| 16:05.27 | carmony | I tweeted :P |
| 16:05.46 | hhatfield | $lart carmony |
| 16:06.11 | hhatfield | ~lart carmony |
| 16:06.11 | infobot | blasts carmony with a huge firehose then strangles carmony with it |
| 16:06.18 | hhatfield | ~mourn raifbot |
| 16:06.18 | infobot | ACTION lights some candles for raifbot |
| 16:06.22 | carmony | ouch |
| 16:15.11 | josephscott | UtahDave: where on 106? |
| 16:15.20 | josephscott | ~sandy++ |
| 16:28.26 | *** join/#uphpu ponderability (~ponderabi@dongato.chpc.utah.edu) |
| 16:30.18 | *** join/#uphpu SunSparc (~jonathan@69-27-175-74.acedatacenter.com) |
| 16:30.19 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 16:36.12 | UtahDave | First floor of the Craig Swapp building, josephscott. I'm not sure if they've made the final decision for that exact office space, but that was the plan |
| 16:36.45 | *** join/#uphpu SunSparc (~jonathan@69-27-175-74.acedatacenter.com) |
| 16:41.09 | macnewbold | ooooh, me too! Vivint is hiring awesome folks also. JS and JS/PHP mostly, unless there are some .Net devs lurking in here. |
| 16:41.54 | SunSparc | ~.Net |
| 16:41.54 | infobot | when .NET system goes online, human decisions are removed from the office environment. It contains Application Center 2000, SQL server 2000, Exchange 2000, Host Integration Server 2000, BizTalk 2000, Commerce Server 2000. They seperate every single bit of simple operation into many buzzword-servers. Don't you hate your money? |
| 16:48.33 | *** join/#uphpu captbrogers (~brian@70-89-245-77-Bank-of-Utah-ut.hfc.comcastbusiness.net) |
| 16:56.21 | *** part/#uphpu captbrogers (~brian@70-89-245-77-Bank-of-Utah-ut.hfc.comcastbusiness.net) |
| 16:58.52 | *** join/#uphpu NoCoolName_Tom (~NoCoolNam@64.124.34.34) |
| 17:26.48 | ninnypants | so I'm running into issues with apache where I'll have a bunch of processes that are just sitting and sleeping and taking up a bunch of memory from running top I see 9 that together take up 58% of my server memory https://gist.github.com/ninnypants/1fb82bba23bb1969bc61 |
| 17:27.20 | ninnypants | does that just mean I need to lower my keep alive timeout? |
| 17:31.21 | mindjuju | so ninnypants, i'm going to give you an answer in 2 parts |
| 17:31.26 | mindjuju | first, the why |
| 17:32.03 | mindjuju | I've found that apache tuning depends on several variables and thus isn't an exact science of Do this and Do that |
| 17:32.34 | mindjuju | It really depends on how efficent the code you've got running is (how much memory does each child require) |
| 17:32.47 | tierra | also depends on which mods you have enabled |
| 17:32.52 | mindjuju | yup |
| 17:33.02 | mindjuju | so, here is a good site for some ideas |
| 17:33.05 | mindjuju | http://thethemefoundry.com/blog/optimize-apache-wordpress/ |
| 17:33.23 | tierra | one mod, loaded for every Apache child process can add up |
| 17:33.41 | mindjuju | and it does go into disabling mods, and also max clients, etc |
| 17:35.22 | tierra | if you don't see wide variances in web traffic, you can probably safely tune down min spare servers for example, but they're there by default to handle traffic spikes that you won't be able to handle if those aren't already running |
| 17:35.30 | mindjuju | like fungus always says though, the apache site is a good place to go to learn how to tune |
| 17:39.27 | ninnypants | ok just wasn't sure if those particular projecesses going to sleep before hitting their timeout was causing issues with memory usage. For the most part everything is running really quickly I'm just running into out of memory issues |
| 17:40.38 | mindjuju | so ninnypants, the reason i pointed you to that site is because you can dictate how many children are waiting around to answer requests |
| 17:40.45 | tierra | definitely pull out mods you aren't using in that case, and also tweak your max servers |
| 17:40.53 | mindjuju | but like tierra pointed out, you don't want to trim back too many or you can't handle spikes |
| 17:40.58 | tierra | if you're hitting OOM, you should do that at least |
| 17:42.05 | tierra | ideally, clients will just end up in TIME_WAIT for a child to handle the request (possibly timing out), but the server will stay up without hitting OOM |
| 17:42.44 | tierra | and if that's happening, and you're confident it's tuned down as much as it can be, then it's time to start looking at load balancing :) |
| 17:42.58 | tierra | and that's certainly a good problem to have usually :) |
| 17:43.46 | mindjuju | i think in ninnypants case though, he's running on 512MB, so i'd recommend more memory to load balance |
| 17:44.12 | tierra | heh, yeah, that'd be better |
| 17:45.43 | ninnypants | yeah I'll just upgrade if I can't get it cleared up didn't realize they would wait to handle request but that makes sense i'll look through my mods I think there are a decent number that I probably don't need |
| 17:46.39 | mindjuju | ninnypants: if this is a server you can play around with, i would first MAKE A COPY OF YOUR httpd.conf file |
| 17:46.48 | mindjuju | then, this look reasonable http://wordpress.org/support/topic/required-apache-modules-for-running-wp |
| 18:25.22 | *** join/#uphpu john-anderson (~john-ande@192.150.9.201) |
| 18:49.01 | jsmith | supernovia: Ping? |
| 18:50.03 | supernovia | O hai |
| 18:52.13 | jsmith | supernovia: Our office in Tempe, AZ is having a product fair, to help some of our new customer service agents better understand our product offerings and the common apps that run on our hosting platform. Would you be interested in attending, or do you have a colleague in the Phoenix area that might? |
| 18:52.57 | supernovia | Ah, the product fair was lots of fun. |
| 18:53.22 | supernovia | I'd love to go if the timeframe fits, but either way I'm sure we could wrangle a few people :) |
| 19:01.51 | mindjuju | ~seen josephscott |
| 19:01.56 | infobot | josephscott <~josephsco@proxy.iad.automattic.com> was last seen on IRC in channel #uphpu, 2h 46m 36s ago, saying: '~sandy++'. |
| 19:02.04 | *** join/#uphpu josephscott (~josephsco@proxy.iad.automattic.com) |
| 19:02.12 | mindjuju | curious |
| 19:02.22 | fungus | lol |
| 19:10.05 | *** join/#uphpu hhatfield (~hhatfield@64.147.139.68) |
| 19:10.05 | *** mode/#UPHPU [+v hhatfield] by ChanServ |
| 19:13.57 | mgeary | okay, folks. Need some mysql help here |
| 19:14.21 | mgeary | a server just started refusing new db connections because the max connections had been hit |
| 19:15.08 | fungus | Is it normal to have that many connections, or close to that many? If so, increast max_connections. |
| 19:15.14 | mgeary | i pulled up the process list (there were 198 connections), but they were all pretty tame queries, but they showed as "locked" |
| 19:15.37 | mgeary | well, i should be able to increase, because the server wasn't under any real load |
| 19:15.43 | mgeary | but i'm trying to figure out why these were all locked |
| 19:15.55 | mgeary | there was one in "user sleep" state |
| 19:15.58 | fungus | Since it isn't normal you find the query in the list that isn't locked and is blocking all the others. |
| 19:16.06 | mindjuju | race condition? |
| 19:16.07 | mgeary | would that be it? |
| 19:16.22 | fungus | Yes, you have a table locked, and all those queries are waiting for it. |
| 19:16.30 | mgeary | what is "User sleep" ? |
| 19:16.48 | fungus | column names? |
| 19:17.00 | jsmith | mgeary: MyISAM or InnoDB tables? |
| 19:17.02 | mgeary | no, that's the "state" of this query |
| 19:17.03 | mgeary | myisam |
| 19:17.10 | tierra | are you using persistent connections from PHP? |
| 19:17.12 | fungus | sleep is a state for a process. meaning it's waiting and not blocking anything. |
| 19:17.30 | mindjuju | ~/query carmony |
| 19:17.35 | mindjuju | oops |
| 19:17.36 | fungus | mgeary, just go through all of them that aren't locked or sleeping. |
| 19:17.37 | carmony | >.> |
| 19:17.47 | fungus | likely one will be "Updating" or something like that. |
| 19:17.54 | jsmith | mgeary: Ah, MyISAM tables are aweful for table locks. Have you tried using InnoDB tables instead? |
| 19:17.55 | mgeary | fungus: that's just it. those are the only states showing |
| 19:18.05 | jsmith | mgeary: (or just moving to PostgreSQL, which supports MVCC) |
| 19:18.24 | mgeary | could do. this is a fairly old app, though, and i am reluctant to change too much |
| 19:18.28 | fungus | mgeary, then maybe a table is locked because it's corrupted. |
| 19:18.36 | fungus | What table are they waiting for? |
| 19:18.46 | mgeary | how can i tell? |
| 19:18.47 | fungus | run "repair table ..." on that table. |
| 19:19.06 | fungus | The query it self should tell you what table it's querying. |
| 19:19.30 | mgeary | ok, there does appear to be one table in common |
| 19:25.34 | mgeary | there. we'll see how that goes |
| 19:31.03 | *** join/#uphpu john-anderson (~john-ande@192.150.9.201) |
| 19:41.39 | *** join/#uphpu undertakingyou (~undertaki@50.8.75.63) |
| 19:41.39 | *** mode/#UPHPU [+v undertakingyou] by ChanServ |
| 20:27.58 | *** join/#uphpu hhatfield (~hhatfield@64.147.139.68) |
| 20:27.58 | *** mode/#UPHPU [+v hhatfield] by ChanServ |
| 21:08.35 | *** join/#uphpu skinner (~david@72.250.214.16) |
| 21:08.35 | *** mode/#UPHPU [+v skinner] by ChanServ |
| 21:12.39 | *** join/#uphpu skinner (~david@72.250.214.16) |
| 21:12.39 | *** mode/#UPHPU [+v skinner] by ChanServ |
| 21:18.33 | clintberry | If anyone has any overflow and is looking for a good consultant for after hours work, let me know. I need some extra cash :-) http://www.linkedin.com/in/clintonberry |
| 21:25.47 | *** join/#uphpu NoCoolName_Tom (~NoCoolNam@64.124.34.34) |
| 21:58.23 | mindjuju | the only kind of overflow i know of is in the back of the warehouse in a small room ;) but i don't think you mean that kind of overflow |
| 22:01.59 | *** join/#uphpu hhatfield (~hhatfield@64.147.139.68) |
| 22:02.00 | *** mode/#UPHPU [+v hhatfield] by ChanServ |
| 22:07.29 | *** join/#uphpu hhatfield_ (~hhatfield@64.147.139.68) |
| 22:07.29 | *** mode/#UPHPU [+v hhatfield_] by ChanServ |
| 22:32.19 | *** join/#uphpu littleSkinner1 (~JSkinn@asa-2.fbp.ore.fiber.net) |
| 22:36.20 | *** join/#uphpu supernovia (~Adium@208.64.91.46.static.utbb.net) |
| 22:36.23 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 22:54.52 | SunSparc | ~overflow mindjuju |
| 22:55.45 | *** join/#uphpu supernovia (~Adium@208.64.91.46.static.utbb.net) |
| 22:55.56 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 22:59.11 | *** join/#uphpu supernovia1 (~Adium@208.64.91.46.static.utbb.net) |
| 23:11.43 | *** join/#uphpu com4 (~com4@i.am.a.sad.cat.xshellz.com) |
| 23:34.31 | *** part/#uphpu skinner (~david@72.250.214.16) |