Em Andamento

auction website timer fix

I have an auction website that works, but the timers are going crazy. I have been unable to check the canned e-mail for errors because of this problem. Here's what I have that may help:

top process command clearly reveals mysql is going crazy.

Cause: Wrong /un responsive queries with left joins.

Its taking 97% of cpu causing site to be sluggish.

26676 mysql 15 0 31892 10m 4200 S 97.3 2.1 1065:02 mysqld

1 root 15 0 2076 524 496 S 0.0 0.1 0:00.39 init

2 root RT 0 0 0 0 S 0.0 0.0 0:07.71 migration/0

3 root 34 19 0 0 0 S 0.0 0.0 0:00.44 ksoftirqd/0

4 root RT 0 0 0 0 S 0.0 0.0 0:08.40 migration/1

________________________________________________

I have more data if you are interested.

Thanks

Habilidades: PHP, SQL

Ver mais: website errors fix, fix help, website migration, timers, rt, mail fix, fix responsive, e fix, crazy, auction website, fix mail, website responsive php, fix root, mysql php migration, auction data, fix cpu, joins, sql php website, mysql sql migration, migration mysql sql, mysql migration website, migration website, fix sql errors, fix responsive website, crazy website

Acerca do Empregador:
( 3 comentários ) Miami, United States

ID do Projeto: #592864

Premiar a:

phpSQLexpert

Hi. I have done all the SQL optimizing and fixing all the while. Please check PM for possible solutions on your problem.

$80 USD em 1 dia
(18 Avaliações)
4.6

5 freelancers are bidding on average $128 for this job

sat12345

Plz check PMB...

$150 USD in 2 dias
(51 Comentários)
3.9
gmStudios

I'd need to take a closer look at your site to know for sure how long it'd take. My bid is for 2 eight-hour days at $10/hour. If I can get it done faster, the cost would decrease; on the other hand, my bid it 160, so e Mais

$160 USD in 2 dias
(0 Comentários)
0.0
az4software

i can fix it!

$100 USD em 1 dia
(0 Comentários)
0.0
hranka

Please check pm for details.

$150 USD in 2 dias
(0 Comentários)
0.0