Wordpress Database Help

Closed

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"

Skills: MySQL, PHP, Website Design, WordPress

See more: linux server performance, info system, wordpress developer free, up design 99, threads of design web page, root info, require wordpress developer, need a help from wordpress developer, id tech, help website fix, help me fix this, fix 404 error website, avg com, 99 design web design, 99 9 design, 7.62 design, 1&1 wordpress design, iostat command, wordpress slow, WordPress performance, shr, sda, pr tech, need help from web developer, free wordpress developer

Project ID: #4538451

26 freelancers are bidding on average $504 for this job

USAGraphicPR0

**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and More

$1030 USD in 8 days
(120 Reviews)
8.0
buraqtech

Check your PMB for details!!!

$706 USD in 12 days
(78 Reviews)
7.8
p4provider

We have all the required designer and developer you are looking for and can allocate dedicated resources for your project. You will be very happy and satisfied of our services.

$608 USD in 18 days
(73 Reviews)
7.3
alinawaz88

Lets do it

$473 USD in 12 days
(135 Reviews)
7.0
TheExertion

We will assist you with the website. We are highly experienced with Wordpress. Please show us the website. Thank you

$515 USD in 3 days
(123 Reviews)
7.0
adityalivelife

hi,please find the attached private message of the work done ...Thanks!!!

$412 USD in 10 days
(129 Reviews)
6.4
jthoma

I am expert in this kind of things

$400 USD in 3 days
(174 Reviews)
6.2
mdltechnology

I have review project details and have gone through your requirements and would like to discuss further regarding the project with you.

$309 USD in 1 day
(84 Reviews)
6.2
tiabrains

Dear Sir, Please check PM. Thanks.

$515 USD in 3 days
(51 Reviews)
6.2
bdweb

Thanks for giving me the opportunity to place a bid on your project. I would very much happy to work with you on your project and I think all your requirement meet with my skill and expertise level. First I woul More

$750 USD in 15 days
(99 Reviews)
6.0
universesys

We are a team of developers and designers who are in this field from more than 6 years. Please check our PMB for details.Universe Technology is committed to provide best quality of work within the time frame. Also we More

$515 USD in 17 days
(17 Reviews)
6.0
theinspiredart

Hello Sir, Interested in working on this project with responsibility to complete it successfully. Regards Aryan

$526 USD in 10 days
(94 Reviews)
5.6
Codoc1010

Hi, my team has many expert programmers on Html, CSS, PHP, MySQL, WordPress, Drupal. I sure, we can do your job on time with high quality. Please view my message for detail. Thanks!

$257 USD in 6 days
(28 Reviews)
5.5
itsoftwarelab

Our main focus is to deliver the quality work with full support to our clients at very competitive rates. We will be happy to work with you on long term basis. So please consider us for your project. Hoping for the More

$736 USD in 15 days
(30 Reviews)
5.3
trkr

Hi, check pmb please.

$578 USD in 5 days
(39 Reviews)
5.1
codeware1

Hello, Hope you are well and doing well!!! We are eager to work with you. We are ready to start the project right away. CODEWARE is a web & Mobile application development company providing professional design, developm More

$257 USD in 7 days
(31 Reviews)
5.3
spalshmedia

Redy for Start work! I've 5 Years experience in WordPress Template Design, Plugin development, WordPress eCommerce Site with Mysql, CSS, Jquery, Javascript. Please look my portfolio and award this job to me.

$618 USD in 10 days
(15 Reviews)
5.0
miniric3

Hi, We can give you the best and quick output. We have a professional team in your required area, they work sincerely. You will get your desired output from us. We are very much concerned about quality and customer sa More

$701 USD in 7 days
(5 Reviews)
4.9
bearjob

Hello sir, I am ready . Please check PMB .

$368 USD in 3 days
(31 Reviews)
4.8
truongngocthanh

Hello, I can fix your issue and optimize your database server too, Please consider me. Thank you

$277 USD in 2 days
(9 Reviews)
4.5