Closed

Wordpress Database Help

This project received 32 bids from talented freelancers with an average bid price of $489 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250 - $750 USD
Total Bids
32
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 [url removed, login to view] ([url removed, login to view]) 05/19/2013

avg-cpu: %user %nice %system %iowait %steal %idle
[url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda [url removed, login to view] [url removed, login to view] [url removed, login to view] 49336461280 72897008644
sda1 [url removed, login to view] [url removed, login to view] [url removed, login to view] 28998 172
sda2 [url removed, login to view] [url removed, login to view] [url removed, login to view] 15874384 31408888
sda3 [url removed, login to view] [url removed, login to view] [url removed, login to view] 49320557218 72865599584

root@web [~]# uptime
13:23:27 up 185 days, 19:12, 1 user, load average: [url removed, login to view], [url removed, login to view], [url removed, login to view]

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:[url removed, login to view] php
32039 omgghana 16 0 358m 152m 50m R 99.0 0.6 0:[url removed, login to view] php
27913 bigxgh 16 0 324m 124m 53m R 97.1 0.5 1:[url removed, login to view] php
27973 bigxgh 16 0 324m 116m 46m R 83.5 0.5 0:[url removed, login to view] php
25773 bigxgh 16 0 324m 124m 53m R 68.0 0.5 1:[url removed, login to view] php
32075 omgghana 17 0 311m 108m 49m R 62.1 0.4 0:[url removed, login to view] php
26647 bigxgh 16 0 324m 123m 53m S 50.5 0.5 1:[url removed, login to view] php
2488 bigxgh 16 0 325m 126m 55m S 44.7 0.5 6:[url removed, login to view] php
18991 bigxgh 16 0 325m 124m 53m S 40.8 0.5 3:[url removed, login to view] php
29062 bigxgh 16 0 324m 124m 53m S 34.9 0.5 0:[url removed, login to view] php
29166 bigxgh 16 0 324m 116m 46m R 27.2 0.5 0:[url removed, login to view] php
27900 bigxgh 16 0 324m 123m 53m R 21.4 0.5 0:[url removed, login to view] 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: [url removed, login to view]

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"

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online