I think this is the correct forum...

[jimbo]

I have noticed (today especially) that whenever there are many people using my boards, it slows down to an absolute crawl. The header comes across, but everything else just grinds to a halt. I've eliminated as many of the MySQL calls as possible, thinking there was a bottleneck with the SQL server, but haven't noticed any big changes. It is kind of annoying.

There isn't much I can do, I don't think, because I'm on a shared server. Anybody have any suggestions?

My boss offered to host my site for free on our servers at work, we have a 1.1M SDSL line, has anyone ever hosted a site on that size pipe? The machine is an old Linux box a 400P-2 I believe. Would that be a good move or a bad move?

Financially it'd be great. I'd save $50 + per month. As long as it would be beneficial from the speed aspect.

Any advice for a know-it-all newbie? ;)

[wandrer]

Not sure if this would help, but what does the mysql/mysqladmin 'status' show (when you are under a high load) ?

[Edited by wandrer on 05-08-2000 at 10:21 PM]

[jimbo]

How do I find that?

[werehere]

I believe I experience some of what you mention as well. I believe in my case that it is the php/mysql settings, and I think I still have not optimized it properly yet.

The board flies most of the time, but when a certain amount of users are on at the same time then it does lag, but the rest of the site is flying.

[jimbo]

Well, since I'm on a shared server, I don't think there is much I can do by way of changing settings. Maybe I should move to the servers at work...

[John]

Once you start getting bits of the page on your browser, it shows that PHP has finished outputting the page. None of the page is outputted until PHP has finished formatting it - it's just the way the templates work.

Therefore, if you are just getting the header, check with your host about bandwidth - I guess that is where the problem lies.

John

[jimbo]

But the rest of the site works fine...

I was thinking it was more of a MySQL server issue, and the machine that their running it on. There are a ton of sites on each server, and there are about 6 or 7 servers I think, therefore there are potentially 1,000 sites all accessing the one MySQL server. I think that is where my bottlenecks are. Regardless, I'm getting sick of paying $25 every time I want to add a sub-domain, or IRO, etc... so I think it would be better if I hosted it myself, anyway.