Linux admin expert to debug/optimize Godaddy Dedicated Server & MYSQL Database

This project was awarded to Nick1 for $65 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I'm in immediate need of a Linux/Database Admin Expert to review/optimize my Godaddy Linux Dedicated Server and MYSQL databases.

The problem that I am experiencing is that Plesk shows my server load many times hovers around 8.0 to 9.0. At times it goes up as far as 62.0. This occurs even immediately after a reboot.

During these times my websites crawl, and my busy website (6000-8000 uniques/day) really crawls. Many times that website will error out with the message "too many connections". I assume that is a MYSQL database error, but I'm not sure. Even the Plesk Admin console will error out with the message:

ERROR: PleskFatalException

Unable to connect to database: Too many connections

0: /usr/local/psa/admin/plib/[url removed, login to view]

psaerror(string 'Unable to connect to database: Too many connections')

1: /usr/local/psa/admin/auto_prepend/[url removed, login to view]

My busy website is a Wordpress Video Blog where people can come and view streaming videos. The videos are all embedded from other websites (ie; youtube) so my server is not serving up the videos itself. Wordpress runs on MYSQL.

I don't know how many concurrent users I have on that website or on the entire server.

Specifically what I am looking for is an expert to:

1. Get into the server (ssh?) during these high load times (pretty much all the time) and see what is going on (memory problems, swapping, cpu, concurrent users, etc).

2. Determine what the server problem is (lack of memory, underpowered cpu, mysql optimization, etc). Also explain/show how you reached your conclusions.

3. Show me how to find out how many concurrent users I have.

4. Optimize the MYSQL database in the busy website. By this I mean configure it to best handle the amount of visitors that I get. I'm trying to get rid of those "too many connection" errors.

5. Optimize the overall server. I don't know enough to be more specific .. just that I want to get the server load numbers down to an acceptable level, and the server to respond quickly.

6. Let me know if I need more memory or a faster server (please be able to show me how you reached that conclusion)

I currently have 10 websites running on this server. As I mentioned prevously one gets 6000-8000 unique visitors a day. The other 9 get less than 500 visitors/day combined.


*NOTE* - Godaddy made me upgrade the Linux Kernal about a week ago for "security" reasons. It may just be coincidence, but I noticed these problems with my server afterwards.

Please, I'm interested only in those people that have done this type of work before. This is costng me money and I need this handled yesterday. This could be a long term collaboration available for the right person. My budget is $100.

Thank you


Preconfigured Server Specs:

Operating System:

Linux Fedora Core 7

OS Kernel:

Linux kernel 2.6

Remote Access Services:

OpenSSH [url removed, login to view]

Email Services:

Sendmail 8.14.1

Development Languages/Environments:

GCC (C, C++, Objc, GCJ) 4.1.2

Perl 5.8.8

PHP 5.2.4

Database and Directory Services:

MySQL [url removed, login to view]

DNS Services

BIND 9.4.2:

Web Servers and Components:

Apache 2.0

Mod_ssl 2.2.6

Mod_perl 2.0.3

Mod_python 3.1

Awarded to:

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