Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Phil h Posted March 14, 2012 Posted March 14, 2012 Hi, Something has started really slowing my forum down and cannot work out what. Went ipb 3.3 last November and has bit slower since which I can understand but there is something else... Last few week after a day some time less the forum grinds to halt with high load usage but I don't know where to look to try and track down why it slows right down. At this moment in time it is ok, what do I need to grab when it fly's on the handle ?Total Members 12,453 Topics 23,263Posts 637,788 P.Board Version v3.2.3 (ID:32006) MYSQL Version MYSQL 4.1.22-standard PHP Version 5.2.5 (apache2handler) Disabled PHP Functions No Information Loaded Extensions Reflection, SPL, SQLite, SimpleXML, apache2handler, bcmath, calendar, ctype, curl, date, dom, filter, ftp, gd, hash, iconv, imap, json, libxml, mcrypt, mysql, mysqli, openssl, pcre, posix, session, sockets, standard, tokenizer, xml, xmlreader, xmlwriter, zlib Safe Mode OFF System Software Linux 2.6.18-028stab094.3 #1 SMP Thu Sep 22 12:47:37 MSD 2011 i686 Current Server Load 0.75 Total Server Memory 1600 MB Available Server Memory 1097 MB Mysql databse size = 1.1gb Always between 200 to 300 uses online. Linux. WHM installed. [mysqld] skip-bdb skip-innodb set-variable = max_connections=500 safe-show-database max_tmp_tables=1 query_cache_type=1 query_cache_limit=2M query_cache_size=64M table_cache=256 thread_cache_size=4 Installed Sphinx. top - 17:58:44 up 4:16, 1 user, load average: 0.75, 2.60, 4.03 Tasks: 95 total, 1 running, 94 sleeping, 0 stopped, 0 zombie Cpu(s): 3.0%us, 0.6%sy, 0.0%ni, 82.5%id, 13.9%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 1638400k total, 514820k used, 1123580k free, 0k buffers Swap: 0k total, 0k used, 0k free, 0k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1 root 15 0 2160 672 580 S 0.0 0.0 0:01.06 init 1135 root 15 -4 2264 568 356 S 0.0 0.0 0:00.00 udevd 1567 root 18 0 1816 572 484 S 0.0 0.0 0:00.04 syslogd 1570 root 15 0 1764 408 340 S 0.0 0.0 0:00.01 klogd 1593 named 21 0 110m 4324 2088 S 0.0 0.3 0:00.88 named 1613 root 19 0 1748 424 352 S 0.0 0.0 0:00.00 courierlogger 1614 root 18 0 2092 644 532 S 0.0 0.0 0:00.00 authdaemond 1631 root 15 0 2092 372 256 S 0.0 0.0 0:00.01 authdaemond 1632 root 15 0 2092 372 256 S 0.0 0.0 0:00.01 authdaemond 1633 root 18 0 7244 1064 656 S 0.0 0.1 0:00.00 sshd 1644 root 22 0 2552 1156 1000 S 0.0 0.1 0:00.00 mysqld_safe 1665 mysql 15 0 106m 36m 2744 S 0.0 2.3 3:08.15 mysqld 1676 root 25 0 1748 336 280 S 0.0 0.0 0:00.02 courierlogger 1677 root 18 0 1860 548 452 S 0.0 0.0 0:00.00 couriertcpd 1683 root 25 0 1748 340 280 S 0.0 0.0 0:00.00 courierlogger 1684 root 18 0 1860 548 452 S 0.0 0.0 0:00.00 couriertcpd 1689 root 18 0 1748 420 352 S 0.0 0.0 0:00.00 courierlogger 1690 root 15 0 1860 572 472 S 0.0 0.0 0:00.00 couriertcpd 1695 root 24 0 1748 336 280 S 0.0 0.0 0:00.00 courierlogger 1696 root 18 0 1860 552 452 S 0.0 0.0 0:00.00 couriertcpd 3217 mailnull 16 0 10364 1168 680 S 0.0 0.1 0:00.06 exim 3245 root 15 0 34068 30m 2300 S 0.0 1.9 0:02.76 spamd 3246 root 18 0 15748 13m 1388 S 0.0 0.8 0:05.59 lfd 3288 root 18 0 34068 28m 1044 S 0.0 1.8 0:00.00 spamd 3297 root 15 0 20940 10m 4740 S 0.0 0.6 0:04.02 httpd 3304 root 18 0 5388 1460 1112 S 0.0 0.1 0:00.00 pure-ftpd 3306 root 18 0 5084 1160 912 S 0.0 0.1 0:00.01 pure-authd 3327 root 15 0 3336 1128 576 S 0.0 0.1 0:00.08 crond 3442 root 18 0 15360 9268 1800 S 0.0 0.6 0:00.04 cpdavd 3466 root 18 0 14280 7300 1220 S 0.0 0.4 0:00.51 cpsrvd-ssl 3470 root 18 0 6096 4320 1328 S 0.0 0.3 0:00.15 queueprocd 3479 root 33 18 4196 1880 668 S 0.0 0.1 0:00.46 cpanellogd 3488 root 18 0 7960 5332 1824 S 0.0 0.3 0:02.21 tailwatchd 3498 root 18 0 5688 712 432 S 0.0 0.0 0:00.00 saslauthd 3499 root 18 0 5688 448 168 S 0.0 0.0 0:00.00 saslauthd 3586 root 18 0 1772 424 344 S 0.0 0.0 0:00.00 portsentry 5140 root 18 0 89644 1408 824 S 0.0 0.1 0:00.35 searchd 5226 root 19 0 7956 5360 1908 S 0.0 0.3 0:00.08 leechprotect 5232 root 18 0 20940 7080 1372 S 0.0 0.4 0:00.00 httpd 9669 root 15 0 4668 2852 1540 S 0.0 0.2 0:00.01 authProg 10227 root 15 0 4668 2848 1540 S 0.0 0.2 0:00.00 authProg 16248 nobody 15 0 25600 13m 3536 S 0.0 0.9 0:18.50 httpd 17466 nobody 15 0 25216 12m 2956 S 0.0 0.8 0:07.00 httpd 17525 nobody 15 0 26124 13m 2956 S 0.0 0.9 0:02.67 httpd 17546 nobody 16 0 28404 15m 2956 S 0.0 1.0 0:08.28 httpd 17562 nobody 15 0 26520 14m 2956 S 0.0 0.9 0:02.51 httpd 17575 nobody 16 0 28496 16m 3532 S 0.0 1.0 0:01.85 httpd 17577 nobody 15 0 23976 11m 2956 S 0.0 0.7 0:00.51 httpd 17581 nobody 15 0 25956 13m 2952 S 0.0 0.8 0:01.86 httpd 17582 nobody 15 0 23972 11m 2952 S 0.0 0.7 0:00.68 httpd 17600 nobody 15 0 24824 12m 2952 S 0.0 0.8 0:00.83 httpd 17602 nobody 15 0 25072 12m 2952 S 0.0 0.8 0:00.83 httpd 17604 nobody 15 0 26900 15m 3540 S 0.0 0.9 0:18.83 httpd 17946 nobody 16 0 25604 13m 2952 S 0.0 0.8 0:00.72 httpd 17952 nobody 18 0 24580 12m 2960 S 0.0 0.8 0:02.00 httpd 17963 nobody 15 0 23736 11m 2952 S 0.0 0.7 0:00.93 httpd 17981 nobody 16 0 26924 14m 2956 S 0.0 0.9 0:03.60 httpd 18002 nobody 15 0 26684 14m 2964 S 0.0 0.9 0:02.78 httpd 18040 nobody 15 0 25420 13m 3024 S 0.0 0.8 0:12.90 httpd 18052 root 16 0 10108 2988 2424 S 0.0 0.2 0:00.11 sshd 18057 nobody 15 0 26948 14m 2956 S 0.0 0.9 0:05.42 httpd 18058 nobody 15 0 24316 11m 2952 S 0.0 0.7 0:02.25 httpd 18060 nobody 15 0 27044 14m 2956 S 0.0 0.9 0:01.29 httpd 18062 nobody 15 0 24548 12m 2952 S 0.0 0.8 0:00.45 httpd 18065 nobody 15 0 28856 16m 2956 S 0.0 1.0 0:01.49 httpd 18070 root 16 0 3096 1392 1088 S 0.0 0.1 0:00.01 login 18071 nobody 15 0 23732 11m 2952 S 0.0 0.7 0:00.35 httpd 18072 nobody 15 0 24692 13m 3720 S 0.0 0.8 0:00.97 httpd 18075 root 17 0 2688 1412 1136 S 0.0 0.1 0:00.03 bash 18191 nobody 15 0 25096 12m 2956 S 0.0 0.8 0:01.88 httpd 18209 nobody 15 0 26772 14m 2952 S 0.0 0.9 0:01.09 httpd 18211 nobody 15 0 23736 11m 2956 S 0.0 0.7 0:08.88 httpd 18212 nobody 16 0 28144 15m 2952 S 0.0 1.0 0:01.21 httpd 18213 nobody 15 0 25056 12m 2956 S 0.0 0.8 0:00.52 httpd 18214 nobody 15 0 24580 12m 2956 S 0.0 0.8 0:02.46 httpd 18227 nobody 15 0 28348 15m 3016 S 0.0 1.0 0:13.91 httpd 18229 nobody 15 0 23956 11m 2956 S 0.0 0.7 0:00.83 httpd 18230 nobody 15 0 28076 15m 2952 S 0.0 1.0 0:00.53 httpd 18231 nobody 15 0 26908 14m 2952 S 0.0 0.9 0:00.64 httpd 18234 nobody 15 0 28332 15m 2952 S 0.0 1.0 0:00.64 httpd 18235 nobody 15 0 27768 15m 2956 S 0.0 1.0 0:01.77 httpd 18236 nobody 15 0 23992 11m 2956 S 0.0 0.7 0:00.25 httpd 18240 nobody 15 0 24552 12m 2956 S 0.0 0.8 0:00.69 httpd 18242 nobody 15 0 26904 14m 2984 S 0.0 0.9 0:16.42 httpd 18247 nobody 15 0 26640 14m 2952 S 0.0 0.9 0:00.87 httpd 18249 nobody 15 0 24580 12m 2956 S 0.0 0.8 0:00.94 httpd 18253 nobody 15 0 26236 13m 2960 S 0.0 0.9 0:10.91 httpd 18255 nobody 15 0 25096 12m 2956 S 0.0 0.8 0:01.24 httpd 18422 root 16 0 2292 1072 832 S 0.0 0.1 0:00.26 top 19459 nobody 15 0 26940 14m 2956 S 0.0 0.9 0:01.40 httpd 19466 nobody 15 0 23992 11m 2944 S 0.0 0.7 0:00.28 httpd 19469 nobody 15 0 24832 12m 3236 S 0.0 0.8 0:01.05 httpd 19470 nobody 15 0 20940 8332 2480 S 0.0 0.5 0:00.00 httpd 19471 nobody 15 0 23680 11m 2864 S 0.0 0.7 0:00.10 httpd 19477 nobody 18 0 2420 980 744 R 0.0 0.1 0:00.01 top Current Disk Usage Filesystem Size Used Avail Use% Mounted on /dev/vzfs 60G 31G 30G 52% / /dev/simfs 60G 31G 30G 52% /tmp
Rhett Posted March 14, 2012 Posted March 14, 2012 I would start first with getting your server updated, you are using very very old versions of mysql, php, and I'm guessing apache as well. Once you get those updated, then run mysqltuner as well to get your mysql setup properly.
Codehusker Posted March 14, 2012 Posted March 14, 2012 Your top output shows that 13.9% of your processes are waiting on disk, which is too high. Since top is an instant readout, you should watch top for a while during peak times and see what this value does:Cpu(s): 3.0%us, 0.6%sy, 0.0%ni, 82.5%id, 13.9%wa, 0.0%hi, 0.0%si, 0.0%sTwo ways to alleviate disk wait:1) Get a faster disk (10k rpm, RAID, etc.), which is usually expensive.2) Load more data into memory. You're currently using 515MB out of 1.6 GB. After you upgrade mySQL, play around with caching your DB in memory. It's substantially faster than disk, and you have plenty to spare.
Aussie Cable Posted March 14, 2012 Posted March 14, 2012 Board Version v3.2.3 (ID:32006) I think that settles it - yes?
Phil h Posted March 14, 2012 Author Posted March 14, 2012 Thanks, Upgrading the services tomorrow but cannot find what versions the forum supports ?
Aussie Cable Posted March 14, 2012 Posted March 14, 2012 Upgrading the services tomorrow but cannot find what versions the forum supports ? This section may help you, there is a script you can upload to the server to check after you have updated it.
Rhett Posted March 14, 2012 Posted March 14, 2012 Thanks, Upgrading the services tomorrow but cannot find what versions the forum supports ? Thanks, Upgrading the services tomorrow but cannot find what versions the forum supports ? The limitation you will have is what cpanel supports, you can update to the latest versions that are supported by cpanel and the board will work just fine... I would suggest at least mysql 5.1.x, php 5.3.x and apache 2.2.x
raindog308 Posted March 16, 2012 Posted March 16, 2012 [font=helvetica, arial, sans-serif][color=#282828]Two ways to alleviate disk wait:[/color][/font] [font=helvetica, arial, sans-serif][color=#282828]1) Get a faster disk (10k rpm, RAID, etc.), which is usually expensive.[/color][/font] [color=#282828][font=helvetica, arial, sans-serif]2) Load more data into memory. You're currently using 515MB out of 1.6 GB. After you upgrade mySQL, play around with caching your DB in memory. It's substantially faster than disk, and you have plenty to spare.[/font][/color] Yes, MySQL loves memory. Look at tuning your MySQL to use more memory. Also, add a PHP cache APC or xcache.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.