914club.com BBS is slow, anyone else notice this? |
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
914club.com BBS is slow, anyone else notice this? |
siverson |
Aug 17 2004, 12:46 AM
Post
#81
|
Advanced Member Group: Benefactors Posts: 2,448 Joined: 5-May 03 From: San Diego, CA Member No.: 654 Region Association: Southern California |
I know this came up a few weeks ago, but was it ever resolved? The page load times seem to be getting slower and slower.
I can't imagine that you need a super high horsepower server or connection to run this site... Just playing armchair system admininstrator from the sidelines it seems some database tuning may be needed. I'd be happy to contribute to a fund for a faster server or some DB consultants time or... ? -Steve |
lapuwali |
Sep 4 2004, 01:04 PM
Post
#82
|
Not another one! Group: Benefactors Posts: 4,526 Joined: 1-March 04 From: San Mateo, CA Member No.: 1,743 |
Interesting. Good data. Note that disk I/O (bi bo) is up substantially (over 600 regularly), and the CPU is, indeed, pegged. Not swapping as much as in earlier dumps.
This is probably entirely moot, since Andy is talking about moving the whole thing to a much better box, but... My guess is the bottleneck is split between the DB server and Apache competing for CPU time, and a small amount of thrashing on RAM. I'd guess now that just adding RAM wouldn't make a huge difference. The disks are starting to get a bit busy. If sticking with the existing machine was a limitation, I'd next investigate the following: What's the avg. query rate for MySQL (mysqladmin stat; sleep 5; mysqladmin stat. Subtract the two "Questions" numbers, divide by 5, there's your queries per second.)? What percentage of the HTTP queries are image serving (would require a quick Perl script to parse some access logs)? What's the split between MySQL and Apache in CPU usage (top will tell you this)? After answering these questions, there are various configuration changes that could be made, most of them "free". However, throwing hardware at the problem is easier, and sounds like it's going to happen, anyway. If I had the luxury, what I'd probably do first is move the MySQL DB to a different box, and leave the site where it is. |
Lo-Fi Version | Time is now: 10th June 2024 - 08:40 AM |
All rights reserved 914World.com © since 2002 |
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |