|
|
Joined: Aug 2000
Posts: 3,590
Moderator
|
Moderator
Joined: Aug 2000
Posts: 3,590 |
Scream,
My team and I were excited about the php version and decided last night that we would experiment with the php version of wwwthreads on our high traffic site, and we experienced a huge server load.
Mysql was running at 60-70% cpu, and our box (Sun 220R, 2GB ram) was taking a beating at 80+ load. We waited about 12 hours with sluggish performance before reverting back to the old version we are running. (WWT PERL v4.1.1 < Old eh?)
I took a look at the script (mysql.inc.php) and noticed you were NOT doing a mysql_pconnect. I would recommend changing the code to use a persistant connection or apache will spawn out of control. (Like it did for us heheh!)
I don't know if you have some sort of CVS for wwwthreads; I am a PHP programmer by trade and would really like to help if it would accellerate a production version of wwwthreads php.
Let me know!
P.S. I built a migration script to the latest stable version (5.1.1) from version 4.11 if you know of anybody stuck that far back in the revisions, send them my way!
-- Matt
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
You are correct. On high traffic sites persistant connections should be used. I forgot to put in an option for that. Can't make it default because alot of people cannot do persistant connections. Will get that option put in. Thanks for the info.
Have never had the chance to get cvs installed on my server.
UBB.threads Developer
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
Just went to your forums. You have the myshoppingboards. One thing is that version 4.1.1 that you are currently running there didn't have as many features so the number of sql queries is much less then what goes into 5.1.2. Plus I think 4.1.1 was still single language which was a bit quicker than the multiple language support.
It's true that persistant connections will help, but I don't think it's a matter of just the PHP version causing the load I think it's just jumping from 4.1.1 to the latest version adds a ton of new features and along with those features comes some extra queries. Which is why you were seeing such a high process useage from mysql. You guys get a ton of traffic. What type of server config do you have? I mean do you have a seperate box for the mysql server or is it on the same box as the web server? Most of our high traffic customers end up splitting the load by running mysql on a dedicated server while the webserver is on another one.
UBB.threads Developer
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|