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