I have this script [url removed, login to view] I want you to tweak the database setting to not overload the server. The Hosting Technicians told me ======== The following db is killing your server. root x6 [~]# top top - 09:51:36 up 21:05, 2 users, load average: 32.04, 25.93, 19.85 Tasks: 252 total, 3 running, 248 sleeping, 1 stopped, 0 zombie Cpu(s): 4.0% us, 1.6% sy, 0.7% ni, 84.5% id, 9.1% wa, 0.0% hi, 0.0% si Mem: 1034076k total, 1016648k used, 17428k free, 6412k buffers Swap: 2040212k total, 1120396k used, 919816k free, 88376k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3054 mysql 15 0 265m 68m 2304 D 18 6.8 87:30.18 mysqld | 231144 | wwwx6ro_jocuri | localhost | wwwx6ro_jocuri | Query | 0 | Sending data | SELECT COUNT(*) as Num FROM ava_games WHERE catergory_id=11 | | 231147 | wwwx6ro_jocuri | localhost | wwwx6ro_jocuri | Query | 0 | cleaning up | SELECT COUNT(*) as Num FROM ava_games WHERE catergory_id=10 | | 231146 | wwwx6ro_jocuri | localhost | wwwx6ro_jocuri | Query | 0 | Sending data | SELECT COUNT(*) as Num FROM ava_games WHERE catergory_id=11 | ================ You need to tweak your db queries on that site. It is running very heavy queries and not closing them properly. ================= If you can help me please bid
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).