Massive Bandwidth Usage and SQL/Httpd Resources

We currently have a client on a shared server that is consuming large amounts of bandwidth daily. So far this month, in 16 days he has transfered over 200 gigs of >100k images and such. His site is a custom gallery script that constantly accesses a SQL DB. At any given time, mytop shows an average 20-30 connections to the database that runs his site. Server load increases and at times causes the server to go to a crawl. HTTP processes are being spawned constantly (over and over) probably from his site.

Unfortunatly his site needs to remain on this server. What kind of restrictions should be put into place?

I appreciate any reccomendations,
Acompw

 

 

 

 

Top