Back to Home / #linode / 2006 / 11 / Prev Day | Next Day
#linode IRC Logs for 2006-11-09

---Logopened Thu Nov 09 00:00:13 2006
00:16|-|Shaun [~ndci@ip68-5-62-187.oc.oc.cox.net] has joined #linode
00:33|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has quit [Read error: Operation timed out]
00:37|-|Newsome [~sorenson@adsl-75-0-136-70.dsl.chcgil.sbcglobal.net] has quit [Quit: Linux: Now with employee pricing!]
00:48|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has joined #linode
00:53|-|kokoko [~Vampire@84-73-87-14.dclient.hispeed.ch] has quit [Ping timeout: 480 seconds]
01:14|-|prb [~prb@c-24-22-188-196.hsd1.wa.comcast.net] has left #linode []
01:18|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has quit [Quit: This computer has gone to sleep]
01:25|-|Shaun [~ndci@ip68-5-62-187.oc.oc.cox.net] has quit [Ping timeout: 480 seconds]
01:41|-|Nigel [~Nigel@202-154-145-207.ubs-dynamic.connections.net.nz] has joined #linode
01:44<@linbot>New news from forums: Disk Quotas in General Discussion <http://www.linode.com/forums/viewtopic.php?t=2501>
02:24|-|Shaun [~ndci@ip68-5-62-187.oc.oc.cox.net] has joined #linode
02:32|-|internat [~internat@dsl-202-173-191-140.qld.westnet.com.au] has joined #linode
02:33|-|andrew_j_w [~andrew@82-69-30-171.dsl.in-addr.zen.co.uk] has joined #linode
02:52|-|spr [~spr@c-24-10-168-229.hsd1.ut.comcast.net] has quit [Quit: spr]
02:59|-|kokoko [~Vampire@147.86.143.12] has joined #linode
03:21|-|internat [~internat@dsl-202-173-191-140.qld.westnet.com.au] has quit [Quit: This computer has gone to sleep]
03:42|-|donnchaocaoimh [~donncha@212.2.168.99] has joined #linode
03:43|-|SpaceHobo [~spacehobo@host-84-9-50-138.bulldogdsl.com] has quit [Read error: Operation timed out]
04:23<troy> /clear
04:24|-|troy [troy@li9-177.members.linode.com] has quit [Quit: leaving]
04:25|-|troy [troy@li9-177.members.linode.com] has joined #linode
04:31|-|troy [troy@li9-177.members.linode.com] has quit [Quit: leaving]
04:37|-|troy [troy@li9-177.members.linode.com] has joined #linode
04:37|-|SpaceHobo [~spacehobo@217.205.109.249] has joined #linode
05:22|-|SpaceHobo [~spacehobo@217.205.109.249] has quit [Ping timeout: 480 seconds]
05:29|-|SpaceHobo [~spacehobo@217.205.109.249] has joined #linode
05:38|-|adamg [~misthos@zeus.misthos.com] has joined #linode
05:59|-|Nigel [~Nigel@202-154-145-207.ubs-dynamic.connections.net.nz] has quit [Ping timeout: 480 seconds]
06:43|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has joined #linode
07:01|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has quit [Read error: Operation timed out]
07:04|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has joined #linode
07:13|-|darkbeholder [darkbehold@nmathe02.res.csu.edu.au] has quit [Ping timeout: 480 seconds]
08:06|-|Kurt [1000@evvlinlwt-nas-07-s81.cinergycom.net] has joined #linode
08:21|-|darkbeholder [darkbehold@nmathe02.res.csu.edu.au] has joined #linode
09:18|-|schultmc [~schultmc@c-68-58-138-203.hsd1.in.comcast.net] has joined #linode
09:22|-|Dreamr3 [~Dreamer3@0-1pool106-223.nas33.chicago3.il.us.da.qwest.net] has joined #linode
09:28|-|Dreamr_3 [~Dreamer3@0-3pool252-227.nas33.chicago3.il.us.da.qwest.net] has quit [Ping timeout: 480 seconds]
09:32|-|spr [~spr@c-24-10-168-229.hsd1.ut.comcast.net] has joined #linode
09:47|-|FireSlash [~FireSlash@166.217.189.132] has joined #linode
10:11|-|jekil [~alessandr@host64-239-dynamic.2-87-r.retail.telecomitalia.it] has joined #linode
10:24|-|Kurt [1000@evvlinlwt-nas-07-s81.cinergycom.net] has quit [Quit: Help stop socialism: vote Libertarian]
10:28|-|growltiger [~mjd@ip68-111-217-78.sd.sd.cox.net] has quit [Remote host closed the connection]
10:38|-|Newsome [~sorenson@adsl-68-22-220-206.dsl.chcgil.ameritech.net] has joined #linode
10:48|-|jekil [~alessandr@host64-239-dynamic.2-87-r.retail.telecomitalia.it] has quit [Ping timeout: 480 seconds]
10:52|-|kokoko [~Vampire@147.86.143.12] has quit [Ping timeout: 480 seconds]
11:02|-|konoko [~Vampire@84-73-87-14.dclient.hispeed.ch] has joined #linode
11:12|-|donnchaocaoimh [~donncha@212.2.168.99] has quit [Quit: donnchaocaoimh]
11:14|-|adamg [~misthos@zeus.misthos.com] has quit [Ping timeout: 480 seconds]
11:29|-|SpaceHobo [~spacehobo@217.205.109.249] has quit [Ping timeout: 480 seconds]
11:30|-|donnchaocaoimh [~donncha@212.2.168.99] has joined #linode
11:30<@linbot>New news from wiki: GentooSetup <http://www.linode.com/wiki/index.php/GentooSetup>
11:35|-|cmantito [~gphreak@c-68-39-18-162.hsd1.nj.comcast.net] has joined #linode
11:57|-|Kurt [1000@evvlinlwt-nas-03-s188.cinergycom.net] has joined #linode
12:14|-|kekc [~415c93bc@webuser.linode.com] has joined #linode
12:15<kekc>hi, what's going on with host39?
12:16<rko>it was loaded earlier
12:16<rko>but it has been fine for a while
12:17<Kurt>SNAKES ON A LUXURY YACHT
12:17<rko>kekc, you still have problems?
12:18<kekc>yeah, disk IO very slow
12:18<kekc>mysql almost no responding
12:18<rko>cat /proc/io_status
12:18<rko>what does that say?
12:18<kekc>io_count=156216 io_rate=2 io_tokens=-24 token_refill=100 token_max=400000
12:18<warewolf>um
12:18<warewolf>you're throttled
12:18<rko>there we go! diskhog
12:19<warewolf>that means that you were the BadPerson[tm] causing too much disk io
12:19|-|Kurt changed nick to PeytonManning
12:19<rko>hehe, and I was the GoodPreson[tm] who opened the ticket about this hogging
12:19<kekc>hmmm, but recently i've upgraded to linode 400 and everything seems fine till today
12:19<warewolf>kekc: what services are you running? apache/mysql ?
12:20<kekc>yes
12:20<warewolf>have you tuned them according to the linode wiki?
12:20<rko>kekc, I opened ticket about someone hogging the system. You were causing pain to others.
12:21<rko>you gotta do something really bad... on Linode 400 you should have enough memory/CPU to do a lot
12:21<kekc>I have only apache/php + mysql - that's it
12:21<rko>yes, but what do they do?
12:21<kekc>and not much traffic
12:21<kekc>simple websites
12:21<rko>you can have some really bad queries, tables not indexed or something
12:22<warewolf>you're doing something that is taking up a lot of disk io
12:22<rko>you have a lot of data in the table?
12:22<warewolf>you could be swapping
12:22<warewolf>kekc: please run 'free' and nopaste it
12:22<kekc>Swap: 263160k total, 0k used, 263160k free, 173352k cached
12:23<rko>what does your 'uptime' say?
12:23<kekc>I have same type of sites on other VPS hostings and they run w/o problems
12:23<kekc>just restarted few min ago
12:23<rko>I'm not interested in that... just wanted to see load averages
12:24<kekc> total used free shared buffers cached
12:24<kekc>Mem: 396012 303640 92372 0 17344 176028
12:24<kekc>-/+ buffers/cache: 110268 285744
12:24<kekc>Swap: 263160 0 263160
12:24<rko>you're not swapping, but just a normal disk io counts
12:24|-|iamback [~Marjolein@a80-127-23-92.adsl.xs4all.nl] has quit [Read error: Connection reset by peer]
12:24<rko>back to my mysql question... how big tables you have?
12:25|-|cmantito [~gphreak@c-68-39-18-162.hsd1.nj.comcast.net] has quit [Quit: I aer quitted.]
12:25<rko>do you have query cache turned on?
12:25<kekc>yes
12:25<rko>is your table properly indexed?
12:26<warewolf>kekc: please run 'top -b -n1' and nopaste it (and this time please use nopaste)
12:26<kekc>and key_buffer_size, table_cache, etc. - set up correctly
12:26<kekc>nopaste?
12:27<warewolf>yes, www.rafb.net/paste
12:27<kekc>rko: yes, checked every query with explain - everything is optimized
12:27<rko>query optimization helps... but are your tables indexed?
12:28<kekc>i'm using web client
12:28<kekc><rko> 100%
12:28<rko>good :-)
12:28<rko>something is hitting the disk hard...
12:28<rko>or was
12:29<warewolf>kekc: did you run that top command yet?
12:29<caker>also, you might also consider raising mysql's memory settings for caching and the like, since you're not using any swap
12:29<kekc>>something is hitting the disk hard - maybe it's not my VPS?
12:29<rko>yep, you could have tuned your mysqld too tight
12:29<rko>on Linode 400 you can loosen up a little, it's not like those smalles plans
12:30<warewolf>kekc: yes it is you, the linode admins saw it was you from your io counter.
12:30<kekc>but yesterday and before yesterday - everything was fine - and had more traffic
12:30<rko>kekc, because I complained
12:30<rko>it was not fine for others
12:30<warewolf>kekc: ok -- not trying to be rude here
12:30<rko>now it is
12:31<kekc>ic
12:31<rko>neither am I :-)
12:31<rko>but I had horrible problems for few days because of the load issues
12:31<warewolf>kekc: there is obviously something configured wrong for a linode vps
12:31<warewolf>kekc: continuing to say that everything is fine is not helping
12:32<warewolf>kekc: you can let us help you by showing us what you have running, and how it is set up
12:32<warewolf>kekc: otherwise, you will continue thrashing disk, and the linode admins will continue throttling you.
12:32<rko>and I will keep opening tickets :-)
12:33<kekc>ok, 1 min I'll swich to normal irc client
12:34<rko>is there a way to do iostat that would show io for each process?
12:34<caker>not that I'm aware of
12:34<rko>sometimes things like this are tough to figure out... like once I had problems and finally realized it's imapd opening big folders
12:35<rko>swap/memory problems are asy to spot
12:38|-|kekc [~415c93bc@webuser.linode.com] has quit [Quit: CGI:IRC (Ping timeout)]
12:40|-|jekil [~alessandr@host219-174-dynamic.60-82-r.retail.telecomitalia.it] has joined #linode
12:43|-|sash [~sash@bas12-toronto12-1096586172.dsl.bell.ca] has joined #linode
12:47<iggy>caker: mikegrb: ping
12:47<caker>iggy: pong
12:48<iggy>you think it might be at all possible to get my token_refill upped a smidge
12:48<caker>which host/username?
12:49<iggy>the new host that 53 is moving to, and username iomnis1
12:49<sash>what about Contention Ratio <10:1 ? after I've upgraded to linode 400, hast hasn't chaged same host39
12:49|-|sash changed nick to kekc
12:50<iggy>host39
12:50|-|spr_ [~spr@otherlab.cs.byu.edu] has joined #linode
12:50<kekc>warewolf you still here?
12:50<warewolf>yep
12:52<iggy>caker: danke, whatever it was seems to have passed... I think
12:53<tasaro>kekc: Linode 300 and 400 plans are the only plans that share hosts -- we make sure the contention ratio is <10:1
12:55<warewolf>er
12:55<warewolf>tasaro: I think you need to rephrase that.
12:56<tasaro>?
12:57<npmr>all plans "share hosts"
12:57<npmr>this is no host with one linode on it
12:57<kekc>but for '300' it says 15:1
12:58<npmr>i think what tasaro meant is that there are some hosts with both linode 300 and 400 instances on them, but otherwise, each host serves linodes of just one plans
12:59<caker>correct
12:59<tasaro>yes
12:59<npmr>kekc, 10:1 is better than 15:1
12:59<tasaro>sorry
12:59<npmr>kekc, so if you have 300s on a 300/400 host, and there are 10 or fewer linodes, everyone is satisfied
13:02<kekc>ok
13:02<kekc>any admins here?
13:03<kekc>is my disk IO still throttled?
13:03<kekc>io_count=357226 io_rate=56 io_tokens=55767 token_refill=100 token_max=400000
13:04<warewolf>yes
13:04<warewolf>run that top command please
13:04<warewolf>top -b -n1
13:04<warewolf>and nopaste it
13:05|-|Nigel [~Nigel@202-154-145-207.ubs-dynamic.connections.net.nz] has joined #linode
13:05<kekc>top - 14:04:40 up 1:03, 4 users, load average: 1.31, 1.60, 2.60
13:05<kekc>Tasks: 67 total, 1 running, 66 sleeping, 0 stopped, 0 zombie
13:05<kekc>Cpu(s): 10.1% user, 2.2% system, 0.0% nice, 87.7% idle
13:05<kekc>Mem: 396012k total, 388680k used, 7332k free, 30356k buffers
13:05<kekc>Swap: 263160k total, 1144k used, 262016k free, 255612k cached
13:05<kekc>
13:05<kekc> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13:05<warewolf>dude
13:05<kekc> 1 root 8 0 512 512 452 S 0.0 0.1 0:00.20 init
13:05<kekc> 2 root 9 0 0 0 0 S 0.0 0.0 0:00.00 keventd
13:05<warewolf>I SAID NO PASTE
13:05<kekc> 3 root 19 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd_CPU0
13:05<kekc> 4 root 9 0 0 0 0 S 0.0 0.0 0:00.31 kswapd
13:05<kekc> 5 root 9 0 0 0 0 S 0.0 0.0 0:00.00 bdflush
13:05<kekc> 6 root 9 0 0 0 0 S 0.0 0.0 0:00.00 kupdated
13:05<kekc> 7 root 9 0 0 0 0 S 0.0 0.0 0:00.00 jfsIO
13:05<kekc> 8 root 9 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
13:05<kekc> 9 root 9 0 0 0 0 S 0.0 0.0 0:00.00 jfsSync
13:05<kekc> 10 root 9 0 0 0 0 S 0.0 0.0 0:00.00 xfsbufd
13:05<kekc> 11 root 9 0 0 0 0 S 0.0 0.0 0:00.00 xfslogd/0
13:05<kekc> 12 root 9 0 0 0 0 S 0.0 0.0 0:00.00 xfsdatad/0
13:05<kekc> 13 root -1 -20 0 0 0 S 0.0 0.0 0:00.00 mdrecoveryd
13:05<kekc> 14 root 9 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
13:05<kekc> 183 root 9 0 984 984 712 S 0.0 0.2 0:00.00 dhclient3
13:05<kekc> 317 root 9 0 1532 1528 1408 S 0.0 0.4 0:00.28 sshd
13:05<kekc> 340 root 9 0 624 624 528 S 0.0 0.2 0:00.18 syslogd
13:05<kekc> 343 root 9 0 468 464 408 S 0.0 0.1 0:00.00 klogd
13:05<kekc> 350 bind 9 0 3048 3044 2088 S 0.0 0.8 0:00.00 named
13:05<kekc> 352 bind 9 0 3048 3044 2088 S 0.0 0.8 0:00.04 named
13:05<caker>...
13:05<kekc> 353 bind 9 0 3048 3044 2088 S 0.0 0.8 0:00.67 named
13:05<kekc> 354 bind 9 0 3048 3044 2088 S 0.0 0.8 0:00.00 named
13:06<kekc> 355 bind 9 0 3048 3044 2088 S 0.0 0.8 0:00.00 named
13:06<kekc> 405 Debian-e 8 0 1536 1532 1304 S 0.0 0.4 0:00.00 exim4
13:06<kekc> 524 root 8 0 808 808 676 S 0.0 0.2 0:00.00 cron
13:06<kekc> 568 root 9 0 472 472 420 S 0.0 0.1 0:00.00 getty
13:06<kekc> 569 root 9 0 1832 1824 1660 S 0.0 0.5 0:00.00 sshd
13:06<kekc> 571 sash 9 0 1816 1812 1644 S 0.0 0.5 0:00.28 sshd
13:06<kekc> 572 sash 9 0 1528 1528 1176 S 0.0 0.4 0:00.08 bash
13:06<kekc> 573 root 9 0 1832 1824 1660 S 0.0 0.5 0:00.00 sshd
13:06<kekc> 575 sash 9 0 1796 1792 1644 S 0.0 0.5 0:00.07 sshd
13:06<kekc> 576 sash 9 0 1528 1528 1176 S 0.0 0.4 0:00.00 bash
13:06<warewolf>caker mode +m pls
13:06<kekc> 661 root 14 0 1552 1552 1208 S 0.0 0.4 0:00.46 bash
13:06<kekc> 821 root 9 0 1832 1824 1660 S 0.0 0.5 0:00.02 sshd
13:06<kekc> 823 sash 9 0 1816 1812 1644 S 0.0 0.5 0:00.66 sshd
13:06<kekc> 824 sash 9 0 1532 1532 1184 S 0.0 0.4 0:00.11 bash
13:06<kekc> 848 sash 9 0 568 564 484 S 0.0 0.1 0:00.03 tail
13:06<kekc> 1128 root 9 0 1136 1132 944 S 0.0 0.3 0:00.18 mysqld_safe
13:06<kekc> 1171 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:00.68 mysqld
13:06<kekc> 1172 root 9 0 488 484 432 S 0.0 0.1 0:00.00 logger
13:06<kekc> 1176 mysql 0 0 38520 37m 3672 S 0.0 9.7 0:00.00 mysqld
13:06<kekc> 1177 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:00.02 mysqld
13:06|-|adamg [~misthos@zeus.misthos.com] has joined #linode
13:06<kekc> 1219 root 0 0 5272 5268 5168 S 0.0 1.3 0:00.13 apache2
13:06<kekc> 1220 root 9 0 388 384 336 S 0.0 0.1 0:00.09 cronolog
13:06<kekc> 1221 root 9 0 388 384 336 S 0.0 0.1 0:00.00 cronolog
13:06<kekc> 1222 root 9 0 392 388 336 S 0.0 0.1 0:00.18 cronolog
13:06<guinea-pig>*sigh*
13:06<kekc> 1241 sash 9 0 1908 1908 1492 S 0.0 0.5 0:00.01 mysql
13:06<kekc> 1242 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:00.00 mysqld
13:06<kekc> 1304 root 9 0 1832 1824 1660 S 0.0 0.5 0:00.00 sshd
13:06<kekc> 1306 sash 9 0 1800 1796 1644 S 0.0 0.5 0:00.28 sshd
13:06<kekc> 1307 sash 9 0 1528 1528 1176 S 0.0 0.4 0:00.00 bash
13:06<kekc> 1311 sash 9 0 1140 1136 816 S 0.0 0.3 0:00.08 joe
13:06<Nigel>errrr....
13:06<kekc> 1343 www-data 16 0 12648 12m 8132 S 0.0 3.2 0:05.58 apache2
13:06<kekc> 1345 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:02.71 mysqld
13:06<kekc> 1351 root 9 0 1468 1464 1368 S 0.0 0.4 0:00.00 exim4
13:06<kekc> 1352 root 9 0 1916 1912 1804 S 0.0 0.5 0:00.00 exim4
13:06<kekc> 1353 Debian-e 9 0 1964 1960 1808 S 0.0 0.5 0:00.00 exim4
13:06<kekc> 1366 www-data 9 0 11956 11m 7960 S 0.0 3.0 0:03.05 apache2
13:06<kekc> 1368 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:01.51 mysqld
13:06<kekc> 1370 www-data 9 0 11500 11m 7824 S 0.0 2.9 0:01.30 apache2
13:06<kekc> 1371 www-data 9 0 11828 11m 7820 S 0.0 3.0 0:01.41 apache2
13:06<kekc> 1372 www-data 9 0 11200 10m 7752 S 0.0 2.8 0:02.02 apache2
13:06<kekc> 1373 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:00.08 mysqld
13:06<kekc> 1374 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:00.03 mysqld
13:06<kekc> 1375 mysql 9 0 38520 37m 3672 S 0.0 9.7 0:00.22 mysqld
13:06<kekc> 1376 www-data 9 0 5296 5292 5180 S 0.0 1.3 0:00.00 apache2
13:06<kekc> 1377 root 19 0 932 932 744 R 0.0 0.2 0:00.05 top
13:06<kekc>sorry
13:07<guinea-pig>geezus, how many lines is your term? that was 3 screenfulls
13:07<guinea-pig>(for me)
13:07<Nigel>still.... funny ;)
13:07|-|sonorous [sonorous@sonorous.attenuate.org] has joined #linode
13:07<guinea-pig>sorry, only 2... but still
13:07<Nigel>guinea-pig, i thought it was a /exec top
13:07<Nigel>;)
13:08<guinea-pig>Nigel: oh that might be, heh
13:08<guinea-pig>i forget people know about that toy
13:08<warewolf>kekc: ok, do that again, but this time actually NOpaste it
13:08<guinea-pig>but but... my client doesn't have a /nopaste!
13:09<Nigel>haha
13:09[~]guinea-pig runs away squeeling
13:09|-|mode/#linode [+o caker] by ChanServ
13:09<Nigel>guinea-pig, squeeling like a pig?
13:09<Nigel>;)
13:09<guinea-pig>weet! weet!
13:10<kekc>http://www.rafb.net/paste/results/79d7c351.html
13:10<warewolf>ok now.
13:10<warewolf>you have no processes in disk io wait, good.
13:11<warewolf>you have mysql, apache2, bind, and exim running.
13:11<warewolf>first things first
13:11<warewolf>go frob your /etc/syslog.conf
13:11<warewolf>lines need to be like this
13:12<warewolf>authpriv.* -/var/log/secure
13:12<warewolf>see the dash before the log file?
13:12|-|mode/#linode [+o tasaro] by ChanServ
13:12<warewolf>put one in there on all the lines that have /var/log on them -- right up against the forward slash just like that.
13:12<warewolf>you're running debian, ok
13:13<warewolf>read this: http://www.linode.com/wiki/index.php/Slashdot_My_Linode
13:13<warewolf>tune your mysqld according to the mysql section there
13:14<warewolf>caker- where's your my.cnf
13:15<warewolf>caker- and your linode httpd.conf
13:15<kekc>i have
13:15<@caker>theshore.net/~caker
13:15<Nigel>caker, any ideas about my DNS issue?
13:15<kekc>auth,authpriv.* /var/log/auth.log
13:15<kekc>*.*;auth,authpriv.none -/var/log/syslog
13:15<@caker>Nigel: I hvaen't had a chance to look yet
13:15<Nigel>caker, okay, no problem
13:15<warewolf>kekc: that ; in there is wrong
13:16<warewolf>kekc: all I wanted you to do is add a - just before the filename
13:16<kekc>ok
13:16<warewolf>er
13:16<warewolf>I'm sorry the ; is fine
13:16<warewolf>I've just never seen it before
13:16[~]warewolf just rtfm'd
13:24<kekc>warewolf, thank you!
13:25|-|Nigel [~Nigel@202-154-145-207.ubs-dynamic.connections.net.nz] has quit [Quit: Leaving]
13:26|-|kekc [~sash@bas12-toronto12-1096586172.dsl.bell.ca] has quit [Quit: using sirc version 2.211+KSIRC/1.3.12]
13:27<warewolf>durp I wasn't done
13:27<warewolf>I hope he doesn't think he is
13:28<guinea-pig>well
13:28<guinea-pig>if he continues to think he's done for a while longer, chances are he'll never know...
13:29<guinea-pig>dear god, it's 65F
13:33<npmr>!weather 60625
13:33<@linbot>npmr: Temperature: 61.2°F / 16.2°C | Humidity: 43% | Pressure: 29.69in / 1005.3hPa | Conditions: Clear | Wind Direction: ENE | Wind Speed: 0.0mph / 0.0km/h; This Afternoon - Sunny. Highs around 70...cooler near the lake. North winds 10 to 15 mph becoming northeast.; Tonight - Partly cloudy. Lows in the lower 40s. East winds 10 to 15 mph.; Friday - Chance of rain in the morning...then rain in the afternoon. Cooler. (1 more message)
13:33<npmr>huh
13:48|-|growltiger [~mjd@rrcs-66-27-62-2.west.biz.rr.com] has joined #linode
13:48<growltiger>geesh this is taking forever
13:52|-|sash [~sash@bas12-toronto12-1096586172.dsl.bell.ca] has joined #linode
13:52|-|sash changed nick to kekc
13:57<warewolf>kekc: welcome back
13:57<warewolf>kekc: I wasn't done helping you tune your linode.
13:58<growltiger>it's been over 14 hours since i signed up? how long does it take?
14:05|-|schultmc [~schultmc@c-68-58-138-203.hsd1.in.comcast.net] has quit [Quit: Client exiting]
14:05|-|adamg [~misthos@zeus.misthos.com] has quit [Ping timeout: 480 seconds]
14:05|-|FireSlash [~FireSlash@166.217.189.132] has quit [Read error: Connection reset by peer]
14:18|-|besonen_mobile [~besonen_m@71-220-232-86.eugn.qwest.net] has quit [Ping timeout: 480 seconds]
14:24<kekc>warewolf: thx anyway ;)
14:25<kekc>i've made some query opmimization sites useing very big tables - hope it helps lower IO usage
14:28|-|Rifkin [~rifkin@procyondesign.net] has joined #linode
14:33<rko>kekc, and indexed tables?
14:36|-|adamg [~misthos@zeus.misthos.com] has joined #linode
14:39<kekc>rko: indexes are fine, I think I had load problem with queries like this SELECT * FROM table LIMIT 1000,10;
14:40<kekc>I rewrite it like SELECT id from....
14:40<kekc>and use id to get acctual data lik SELECT * from table where id in(1,2,3,4..);
14:40<kekc>much faster
14:41<growltiger>is there an admin awake yet?
14:42<rko>kekc, that will still scan through the whole table and won't use indexes... any chance to add 'where'?
14:43<kekc> SELECT * FROM table LIMIT 1000,10; - scan whole table
14:43<kekc> SELECT id FROM table LIMIT 1000,10; - use Primaru index
14:44<rko>ok
14:44<kekc>seems work fine, mysql stats:6 threads: 1 running, 0 cached. Queries/slow: 30.2K/1 Cache Hit: 99.18%
14:44<rko>I don't know what type of app you have... but maybe this will help...
14:44<rko>I have an app that gets about 60 web hits during the daytime every minute
14:45<rko>and they need data from table that is about 150k records, and is about 35M on disk
14:46<rko>but... 99% of the queries are the same
14:46<rko>yes, caching helps but problem was that when the table is updated, cache is purged
14:46<rko>and suddenly all the requests queue up and it gets nasty
14:46<rko>so...
14:46<rko>what helped was splitting the table into two
14:47<kekc>my sites use it's own tables 1000-30000 records
14:47<rko>and make another a memory based table
14:47<rko>and do writing to big table, reading to small
14:47<kekc>and they do not updating in real-time
14:47<rko>just do a logic to the frontend to determine where the query has to go
14:48<rko>why would you need to select them all every time?
14:49<kekc>it's very simple sites and simple quieries - so I don't know why it consume so many IO
14:49<kekc>i have VPS with different hostings - with less memory, etc and they don't have such problems ;)
14:50|-|schultmc [~schultmc@216-54-159-97.static.twtelecom.net] has joined #linode
14:50<rko>nobody probably has complained yet on other VPSs
14:50<rko>in Linode there's a large community involvement, too
14:50<rko>it's not just anonymous people taking your money
14:50<kekc>i like linode
14:51<rko>in Linode you gotta be 'a good citizen'
14:51<kekc>i'm trying :)
14:51<rko>great :-)
14:51<kekc>cya, hope my optimization will help lower IO
14:51<rko>l8r
14:52|-|kekc [~sash@bas12-toronto12-1096586172.dsl.bell.ca] has quit [Quit: using sirc version 2.211+KSIRC/1.3.12]
15:02<@caker>growltiger: what was the username?
15:05<rko>caker, let me ask this... I know using too much i/o can hurt other people, but can using too much CPU do the same?
15:05<rko>or does UML handle rating so well that it doesn't matter
15:06<@caker>rko: not really -- the host's CPU scheduler doesn't have the same problems as a disk sched
15:07<@caker>since disk throughput decreases exponentially (more or less) the more seeking it has to do (read: thrashing and/or multiple nodes accessing disk at the same time)
15:07<rko>cool, that's good to know
15:08<rko>because I get these CPU spikes sometimes when I get several of requests per second
15:08<rko>but they don't do disk i/o... only apache, (cached) php execution, and cached mysql queries
15:11<rko>btw, that's one thing I'd recommend people to use to optimize their environment... PHP acceleration. I use APC that was very easy to install.
15:11<growltiger>pelle
15:12<growltiger>i really need this done soon as my webhosting on godaddy is expiring soon and i would like to not have any downtime
15:12<rko>uhoh, godaddy
15:12|-|adamg [~misthos@zeus.misthos.com] has quit [Ping timeout: 480 seconds]
15:12<rko>do you know what 'pelle' means in Finnish?
15:13<growltiger>also i would like my reverse ip to point to smallfurrythinginacavegrooving.com (i will set up the foward now in godaddy's nameservers now if you want)
15:13<growltiger>no, it's an old name i used on muds many years ago
15:13<guinea-pig>with a pict?
15:14<guinea-pig>or without a pict?
15:14<rko>pelle = clown
15:14<growltiger>yeah, it's my nick on dalnet
15:15<rko>I thought you were trying to insult me :-) But then I saw you replied to caker's question
15:15<growltiger>i heard it's also a regular man's name
15:16<growltiger>and there was something called "pelle the conqueror' a book or something
15:16<@caker>growltiger: all set, thanks
15:17<growltiger>thanks
15:17<rko>yes, it could be a name... but more common name is Palle
15:17<rko>oooh... and there's a charcter called 'Pelle Peloton'
15:17<rko>the smart invetor guy from disney comics
15:18<guinea-pig>hahah
15:18<guinea-pig>i keep reading it as Pella
15:18<rko>Gyro Gearloose
15:18<rko>that's Pelle Peloton in Finnish transaltions
15:19<rko>http://fi.wikipedia.org/wiki/Pelle_Peloton
15:19<erikh>whoa, dalnet is back?
15:19<erikh>I thought they got DDoS'd out of existence
15:20<sonorous>welcome to the year 2006
15:21[~]linbot dispenses milk and cookies
15:21[~]tierra steals the milk and cookies
15:25[~]guinea-pig is debating upgrading to apache2 still
15:26[~]guinea-pig dunks tierra in the milk, and steals the cookies
15:27|-|Newsome [~sorenson@adsl-68-22-220-206.dsl.chcgil.ameritech.net] has left #linode [Linux: Now with employee pricing!]
15:49|-|Nigel[CPI] [~ca4aca8b@mail.thegrebs.com] has joined #linode
16:03<@caker>Nigel[CPI]: I can verify blank A records aren't resolving
16:09<@caker>this is goofy
16:10<@caker>beta A 66.160.141.x
16:10<@caker>alpha A 66.160.141.x
16:10<@caker> A 66.160.141.x
16:10<@caker>looks correct ot me (I changed the IP)
16:10<@caker>maybe this is the ordering thing again
16:11<npmr>replace blank with "@"
16:11|-|Eman [~go@dyn216-8-131-69.ADSL.mnsi.net] has quit [Ping timeout: 480 seconds]
16:11|-|Eman [~go@dyn216-8-173-202.ADSL.mnsi.net] has joined #linode
16:12|-|andrew_j_w [~andrew@82-69-30-171.dsl.in-addr.zen.co.uk] has quit [Read error: Connection reset by peer]
16:13|-|spr_ [~spr@otherlab.cs.byu.edu] has quit [Quit: "Ah, the bounce has gone from his bungie"]
16:15|-|Battousai [~bryan@216-164-28-158.c3-0.drf-ubr1.atw-drf.pa.cable.rcn.com] has quit [Quit: KVIrc 3.2.5 Anomalies http://www.kvirc.net/]
16:16<@caker>npmr: that worked
16:16<npmr>i know
16:16<npmr>order does not matter in zone files except in two cases
16:17<npmr>1. if you explicitly declare an $ORIGIN in the zone file, every non-qualified name appearing after it is qualified using that origin
16:17<npmr>the default origin is the zone for which the zone file was loaded
16:18<npmr>2. a record with a blank name field is given the same name as the preceeding named field
16:18<npmr>sorry, named record
16:18<npmr>"@" is shorthand for the origin
16:18<@caker>ahaa
16:18|-|Battousai [~bryan@216-164-28-158.c3-0.drf-ubr1.atw-drf.pa.cable.rcn.com] has joined #linode
16:19<npmr>"@" is great for generic zones
16:20<npmr>like, if you've got a bunch of domains that are all going to have exactly the same nameservers, mail servers, www, soa, etc
16:20<npmr>just don't declare your origin in the zone file
16:20<npmr>and then load that zone file for all of the domains
16:21<@caker>neat
16:22<guinea-pig>i'm a big fan of *
16:23<npmr>*.@ ^_^
16:23<rko>is someone hogging host39 again?
16:23<rko>I am getting big 10+ load spikes again
16:24<rko>going down now
16:24<guinea-pig>rko: yes. i built a nest inside. it's warm and cozy
16:24<rko>heh
16:25<npmr>hmmmm
16:25<@caker>rko: looks ok here
16:25<npmr>frotz is on 39
16:25|-|schultmc [~schultmc@216-54-159-97.static.twtelecom.net] has quit [Quit: Client exiting]
16:27<rko>ok caker
16:27<rko>it has dropped
16:27<guinea-pig>speaking of which... i really should try ubuntu sometime
16:28<rko>but my 10 min load average is still 5.86... I don't see anything on my system doing it
16:28<@caker>rko: we missed to boat, I guess ... I'll keep vmstat up
16:28<rko>thanks :-)
16:43|-|Battousai [~bryan@216-164-28-158.c3-0.drf-ubr1.atw-drf.pa.cable.rcn.com] has quit [Quit: KVIrc 3.2.5 Anomalies http://www.kvirc.net/]
16:44<Nigel[CPI]>woo... lets try @
16:44<@caker>Nigel[CPI]: already done
16:44<@caker>Nigel[CPI]: leave it blank in the editor
16:44<Nigel[CPI]>oh right
16:44<Nigel[CPI]>you've changed the back end?
16:44<@caker>yup
16:44<Nigel[CPI]>thanks a lot
17:00|-|schultmc [~schultmc@216-54-159-97.static.twtelecom.net] has joined #linode
17:02|-|Newsome [~sorenson@adsl-75-0-136-70.dsl.chcgil.sbcglobal.net] has joined #linode
17:05|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has quit [Read error: Operation timed out]
17:13|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has joined #linode
17:14<Nigel[CPI]>caker: just confirmed, resolves 100% ;), except, isn't ns2 meant to mirror ns1?
17:24|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has quit [Read error: Operation timed out]
17:26|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has joined #linode
17:28<@caker>Nigel[CPI]: it should be
17:30<Nigel[CPI]>werid, whenever dnsstuff queries ns2 it gets redirected to root, and has to query again, until it hits ns1
17:31<guinea-pig>I NEED SUSTENANCE
17:31<Nigel[CPI]>caker: i'll check it myself when i get home... and send in a ticket once i can confirm it...
17:32<Nigel[CPI]>dnsstuff can be a bit dodgy
17:59<erikh>oh damn. it's christmas in hollis
18:00<troy>[4~
18:00<@caker>mom's cooking chicken and collard greens
18:02<erikh>I'm glad someone got that
18:03<Nigel[CPI]>i didn't but that could be due to not been american
18:04<erikh>Nigel[CPI]: it's a rap song old enough to date those who remember it rather well
18:07|-|internat [~internat@c210-49-250-210.ipswc1.qld.optusnet.com.au] has quit [Read error: Operation timed out]
18:08<Nigel[CPI]>ahhh right
18:09<@caker>also, collard greens++
18:44|-|internat [~internat@203-206-122-140.dyn.iinet.net.au] has joined #linode
18:47|-|growltiger [~mjd@rrcs-66-27-62-2.west.biz.rr.com] has quit [Remote host closed the connection]
18:51|-|PeytonManning [1000@evvlinlwt-nas-03-s188.cinergycom.net] has quit [Ping timeout: 480 seconds]
18:52|-|Rifkin [~rifkin@procyondesign.net] has quit [Server closed connection]
18:52|-|Rifkin [~rifkin@procyondesign.net] has joined #linode
18:55|-|donnchaocaoimh [~donncha@212.2.168.99] has quit [Quit: donnchaocaoimh]
19:14|-|dc0e [~dc0e@c-69-243-116-179.hsd1.md.comcast.net] has quit [Quit: ↻ or ↓]
19:22|-|Nigel[CPI] [~ca4aca8b@mail.thegrebs.com] has quit [Quit: http://thegrebs.com/oftc/ (EOF)]
19:45|-|Newsome [~sorenson@adsl-75-0-136-70.dsl.chcgil.sbcglobal.net] has quit [Ping timeout: 480 seconds]
19:46|-|Rifkin [~rifkin@procyondesign.net] has quit [Quit: leaving]
19:49|-|internat [~internat@203-206-122-140.dyn.iinet.net.au] has quit [Quit: This computer has gone to sleep]
20:17|-|jekil [~alessandr@host219-174-dynamic.60-82-r.retail.telecomitalia.it] has quit [Ping timeout: 480 seconds]
20:24|-|sprouse [~45fb9a95@webuser.linode.com] has joined #linode
21:12|-|internat [~internat@203-206-122-140.dyn.iinet.net.au] has joined #linode
21:23|-|Dreamr_3 [~Dreamer3@0-1pool106-249.nas33.chicago3.il.us.da.qwest.net] has joined #linode
21:30|-|Dreamr3 [~Dreamer3@0-1pool106-223.nas33.chicago3.il.us.da.qwest.net] has quit [Ping timeout: 480 seconds]
21:35|-|Newsome [~sorenson@adsl-75-0-136-70.dsl.chcgil.sbcglobal.net] has joined #linode
22:13|-|AndyHat [~andyhat@user-10lf9kj.cable.mindspring.com] has quit [Server closed connection]
22:13|-|AndyHat [~andyhat@user-10lf9kj.cable.mindspring.com] has joined #linode
22:20|-|Newsome [~sorenson@adsl-75-0-136-70.dsl.chcgil.sbcglobal.net] has left #linode [Linux: Now with employee pricing!]
22:21|-|FireSlash [~FireSlash@166.217.106.113] has joined #linode
22:59|-|VS_ChanLog [~stats@ns.theshore.net] has left #linode [Rotating Logs]
22:59|-|VS_ChanLog [~stats@ns.theshore.net] has joined #linode
23:05|-|Nigel [~Nigel@202-154-147-15.ubs-dynamic.connections.net.nz] has joined #linode
23:08<Nigel>caker, hmmm, yeah, ns2 doesn't seem to pick up on my zones...
23:08<Nigel>any chance it has lost sync or something?
23:09|-|internat [~internat@203-206-122-140.dyn.iinet.net.au] has quit [Quit: This computer has gone to sleep]
23:21<@caker>Nigel: diff says they're the same
23:21<@caker>Nigel: turn off edit mode
23:22<Nigel>i just have (again)
23:22<Nigel>caker, try dig'ing ns2 etc though (i turned edit mode on about 10 mins ago, and just turned it off again)
23:23<@caker>are you clicking generate, or letting our system regenerate them for you?
23:23<@caker>(every hour)
23:23<Nigel>i've clicked generate a couple of times to visually see the files yes
23:24<@caker>hmm .. both your zones should regenerate on the hour -- mind waiting to see if that happens?
23:24<Nigel>yeah sure
23:25<Nigel>half an hour to go ;)
23:25<Nigel>oh in that case...
23:25<@caker>feel free to make edits during that time
23:27<Nigel>yeah
23:32<Nigel>caker, actually, i'm not the one regenerating it, it's actually regenerating it, itself
23:33<@caker>I ran it manually
23:34<@caker>and discovered another bug (the last generated date becomes the update date...
23:34<Nigel>caker, yeah, thats what i was thinking
23:35<Nigel>i didn't want to suggest it, because i hate accusing people of mistakes when it mightn't be ;)
23:37<Nigel>caker, when you said diff reckons the zone files are identical on ns1 and ns2.... could it be that ns2 hasn't been told to act on the domains?
23:39<rko>host39 just had a huge load spike
23:40<rko>30+
23:43|-|FireSlash [~FireSlash@166.217.106.113] has quit [Ping timeout: 480 seconds]
23:45<Nigel>caker, also, the IPv6 validation routine seems to be buggy.... 2001:470:1f01:ffff::19d5 with and without the extra 0:'s gets rejected...
23:46|-|SpaceHobo [~spacehobo@host-84-9-50-138.bulldogdsl.com] has joined #linode
23:57|-|dc0e [~dc0e@c-69-243-116-179.hsd1.md.comcast.net] has joined #linode
---Logclosed Fri Nov 10 00:00:12 2006