Are all displayed messages on the database? I'd suggest building static html files for the threads of the forum, with the message contents into the database, so you only have to query the database when there is a new post/edit/delete.
All other times your server would be serving static pages, which is obviously the fastest. This is a lot of changes to fo in the forums for that.. But If you get even more hits it will get worse so it would be worth it Imo. Etienne Phudgee wrote: > > Hi, > > I have been searching for some answeres to my problem for around 2 months > now.... > > I am a longtime user of MySQL but by no means am I very proficient at it. I > have had no problems up to this point with it, so Ive not really needed to > do much with it.... > > My webiste is PHP-Nuke 5 based. If your not familiar with PHPNuke it is a > PHP based content manager. Anyhow, certain things on my system slow it to a > crawl.... for example, the forums. When you browse the forums, or post, or > reply, etc.. the system crawls... > > My site runs great for some aspects, but for others it boggs tremedously. > during these bogged times, mySQL is showing in 'top' as taking anywhere from > 40% to 90% CPU usage, and the system lags beyond belief. > > Now this problem has NOT always been happening. It started about 3 months > ago, and I have changed nothing I can think of that would have affected > it.... > > Anyways, to the point.... I have done the checks on the tables and they say > that they are fine. > > Im wondering what would be the best way to track down my problem. What > troubleshooting from the MySQL end could be done to pinpoint whats going on? > > Here is some copys of 'top' during these times - though they probably server > as nothing more than spam to you at this point: > > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND > 15091 mysql 14 0 16332 6352 1668 R 0 90.7 1.6 0:18 mysqld > 15076 root 5 0 1052 1052 824 R 0 2.3 0.2 0:01 top > 13422 nobody 0 0 63528 60M 5740 S 0 1.7 15.9 107:13 httpd > 1594 nobody 0 0 5184 4252 1600 R 0 0.7 1.0 1:13 httpd > 15114 nobody 0 0 2608 2156 1628 S 0 0.5 0.5 0:00 httpd > 14858 nobody 0 0 4124 3740 1732 S 0 0.3 0.9 0:01 httpd > 30852 nobody 0 0 4360 3416 1272 S 0 0.1 0.8 1:33 httpd > 150 > > Mem: 387504K av, 384188K used, 3316K free, 69512K shrd, 7860K buff > Swap: 208804K av, 64652K used, 144152K free 57008K cached > > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND > 15134 mysql 12 0 16320 6340 1668 R 0 43.2 1.6 0:02 mysqld > 15136 mysql 12 0 16320 6340 1668 R 0 11.4 1.6 0:00 mysqld > 13950 nobody 2 0 4308 3880 1408 S 0 4.6 1.0 0:05 httpd > 13422 nobody 2 0 63528 60M 5732 S 0 3.3 15.9 107:13 httpd > 26094 nobody 0 0 31232 29M 1884 S 0 3.1 7.7 45:47 httpd > 15076 root 5 0 1052 1052 824 R 0 2.5 0.2 0:02 top > 13433 nobody 0 0 60568 56M 12816 S 0 0.3 14.9 104:03 httpd > 5 root 0 0 0 0 0 SW 0 0.1 0.0 8:33 kswapd > 13436 root 0 0 1664 880 448 S 0 0.1 0.2 9:40 named > 30852 nobody 0 > > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND > 15134 mysql 12 0 16772 6792 1704 R 0 40.4 1.7 0:04 mysqld > 15136 mysql 12 0 16772 6792 1704 R 0 40.4 1.7 0:02 mysqld > 14626 nobody 0 0 3124 2744 1476 S 0 2.9 0.7 0:03 httpd > 15076 root 5 0 1052 1052 824 R 0 2.3 0.2 0:02 top > 15140 mysql 2 0 16772 6792 1704 R 0 1.7 1.7 0:00 mysqld > 14858 nobody 0 0 3724 3540 1956 S 0 0.9 0.9 0:01 httpd > 30852 nobody 0 0 4360 3416 1272 S 0 0.5 0.8 1:33 httpd > > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND > 15091 mysql 15 0 16312 6048 1400 R 0 86.3 1.5 0:08 mysqld > 13433 nobody 1 0 60568 56M 12816 S 0 4.0 14.9 104:03 httpd > 14528 nobody 0 0 3100 2652 1364 S 0 2.3 0.6 0:01 httpd > 15076 root 5 0 1052 1052 824 R 0 2.1 0.2 0:01 top > 31732 nobody 0 0 4356 3760 1572 S 0 1.7 0.9 1:25 httpd > 15024 root 0 0 876 876 684 R 0 0.3 0.2 0:00 > in.telnetd > > I run a PII300 with 384MB RAM. It gets worse when more people are on > obviously. My site gets about 5000 hits a day, but even at offpeak times, > certain things take way longer to process than others. > > You can visit at www.worldwidepunks.com and browse around to see what I > mean. For example, the forums ALWAYS give me a problem.......... > > Any info you need, let me know. I will provide it ASAP. > > Thanks in advance! > > CJ > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
