Em Andamento

Tweak DATABASE settings to not overload the SERVER

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

## Deliverables

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).

## Platform

php

Habilidades: CRM, Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Artes Visuais, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: work wa, where to hire a coder to help you, free web hosting php mysql, average time to hire, user settings, need technicians, wa, sleeping, shr, ni, database queries, php zombie, queries database, hosting cpu, load average, data cleaning software, zombie run, database technicians, mysql overload server, mysql database query form, project cleaning, database desktop project, mysql database project source code, tweak php code, cleaning php code

Acerca do Empregador:
( 23 comentários ) Craiova, Romania

ID do Projeto: #3057329

Premiar a:

oba

See private message.

$12 USD em 3 dias
(89 Avaliações)
5.3

4 freelancers estão ofertando em média $12 para este trabalho

macFR

See private message.

$8.5 USD in 3 dias
(37 Comentários)
5.5
telosMed

See private message.

$12.75 USD in 3 dias
(125 Comentários)
5.3
SeemaSystems

See private message.

$12.75 USD in 3 dias
(4 Comentários)
0.0