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
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 even if it takes longer I won't charge more.