Wordpress Database Help

CLOSED
Bids
32
Avg Bid (USD)
$489
Project Budget (USD)
$250 - $750

Project Description:
I am having performance issues and the server tech guys sent me the message below, at this point i need a developer to help me fix this issue. Please reach the message below and if you can help let me know. I need help ASAP!

"We can certainly see the 404 error page, although that generally is not an error that is server specific, but would require your developer to look into this as wordpress is an unsupported 3rd party script.

I also noticed the server is dragging alot.

root@web [~]# iostat
Linux 2.6.18-308.20.1.el5 (web.bigxgh.com) 05/19/2013

avg-cpu: %user %nice %system %iowait %steal %idle
34.68 0.53 4.87 6.17 0.00 53.75

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 115.70 3073.34 4541.00 49336461280 72897008644
sda1 0.00 0.00 0.00 28998 172
sda2 0.08 0.99 1.96 15874384 31408888
sda3 115.62 3072.35 4539.05 49320557218 72865599584

root@web [~]# uptime
13:23:27 up 185 days, 19:12, 1 user, load average: 45.69, 49.48, 50.27

root@web [~]#
root@web [~]# free -m
total used free shared buffers cached
Mem: 24097 18550 5546 0 239 10567
-/+ buffers/cache: 7744 16353
Swap: 1952 505 1447

The user account on bigxgh appears to be causing load issues.

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26727 bigxgh 16 0 324m 122m 53m R 99.0 0.5 1:37.45 php
32039 omgghana 16 0 358m 152m 50m R 99.0 0.6 0:06.42 php
27913 bigxgh 16 0 324m 124m 53m R 97.1 0.5 1:17.10 php
27973 bigxgh 16 0 324m 116m 46m R 83.5 0.5 0:38.64 php
25773 bigxgh 16 0 324m 124m 53m R 68.0 0.5 1:27.17 php
32075 omgghana 17 0 311m 108m 49m R 62.1 0.4 0:05.25 php
26647 bigxgh 16 0 324m 123m 53m S 50.5 0.5 1:31.69 php
2488 bigxgh 16 0 325m 126m 55m S 44.7 0.5 6:39.02 php
18991 bigxgh 16 0 325m 124m 53m S 40.8 0.5 3:42.40 php
29062 bigxgh 16 0 324m 124m 53m S 34.9 0.5 0:42.42 php
29166 bigxgh 16 0 324m 116m 46m R 27.2 0.5 0:24.76 php
27900 bigxgh 16 0 324m 123m 53m R 21.4 0.5 0:36.74 php

This appears to be from the amount of slow queries coming from that user account.

root@web [~]# mysqladmin status
Uptime: 120379 Threads: 38 Questions: 28740359 Slow queries: 1437 Opens: 1698 Flush tables: 1 Open tables: 1679 Queries per second avg: 238.748

As you can see, this is coming from the database bigxgh_wrdp2

+--------+---------------+-----------+----------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+---------------+-----------+----------------+---------+------+-------+------------------+
| 671995 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 78 | | |
| 672018 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 73 | | |
| 672141 | ghkings_wrdp1 | localhost | ghkings_wrdp1 | Sleep | 57 | | |
| 672377 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 14 | | |
| 672396 | omgghana | localhost | omgghana_wrdp1 | Sleep | 0 | | |
| 672414 | omgghana | localhost | omgghana_wrdp1 | Sleep | 7 | | |
| 672437 | omgghana | localhost | omgghana_wrdp1 | Sleep | 6 | | |
| 672441 | omgghana | localhost | omgghana_wrdp1 | Sleep | 0 | | |
| 672444 | omgghana | localhost | omgghana_wrdp1 | Sleep | 5 | | |
| 672453 | omgghana | localhost | omgghana_wrdp1 | Sleep | 3 | | |
| 672463 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 0 | | |
| 672466 | ghkings_wrdp1 | localhost | ghkings_wrdp1 | Sleep | 2 | | |
| 672468 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 3 | | |
| 672469 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 0 | | |
| 672470 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 0 | | |
| 672471 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 0 | | |
| 672472 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 1 | | |
| 672473 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 1 | | |
| 672474 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 1 | | |
| 672475 | ghkings_wrdp1 | localhost | ghkings_wrdp1 | Sleep | 1 | | |
| 672476 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 1 | | |
| 672477 | bigxgh_wrdp2 | localhost | bigxgh_wrdp2 | Sleep | 0 | | |
| 67247"

Skills required:
MySQL, PHP, Website Design, Wordpress
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1030
in 8 days
$ 706
in 12 days
$ 608
in 18 days
$ 473
in 12 days
$ 515
in 3 days
$ 412
in 10 days
$ 400
in 3 days
$ 309
in 1 days
$ 515
in 3 days
$ 750
in 15 days