My last chance....

Anon

My site was recently yanked from my host (2nd one in a month) for monopolizing resources. My site has been up for about 3 years but my only competition folded about 8 weeks ago and we have had problems coping with the tremendous amount of new users porting over. It seems my db usage is running the server up to 50% resources at times with about 100 concurrent users accessing my site.

I moved almost all my sql statements to cron jobs that run at different times twice an hour and spit the results to a text file so my content pages are never polling the db directly with every page load.

Didn't help.

Tried adding a footer with mysql_close($server) statement written a few times to try and close open links.

Didn't help.

I have one last option I can think of (although anyone of you that has a better idea I would love to hear it please) but I don't know if it would work.

Here it is : I have one big database with 21 tables. BUT I could easily seperate my users into, say,12 seperate databases with 21 much smaller tables. Say 100 users per database. WOULD that ease the load on the server or would it have the same end result but just instead of 1db at 50% resources it would be 12dbs at 4.5% resources (50%ish resources again).

Thanks all, for any ideas or help.

junebug

well, i think that first you might want to look at the queries you are making to the database and how you can optimize them.

Anon

I spent a few weeks optimizing all my queries (as best I could) AND then instead of accessing the db directly for every page, I just run a cron job to do my query once every half hour and spit the results to a text file. That text file is what gets loaded in the page so the db is only making the connections every half hour (well there is about 6 crons jobs, a different one every ten minutes apart) but each cron runs at a half hour intervals.

Not sure what else to do.....

Anon

I'm completely new to PHP - I'm looking for a quick snippet of code to paste into a page to see if my server is sorted for PHP files!!!

But, if your site is as successful as it sounds, why not buy decent web hosting services? You may even be able to buy a dedicated server for your own purposes - you can then run whatever you want and not worry about too many users or whatever.

Yes it may be pricey but in the long run it'll pay off - if you have to keep pulling your site you must be loosing users...pay the extra to start with and start to do some marketing and advertising to generate more revenue...

Just a thought - I don't even know what your site is about so I may be talking absolute mince...