UBB.Developers Forums UBB.threads 6 Bug Reports Server Load Probs . .

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

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.

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.