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

IN PROGRESS
Bids
23
Avg Bid (USD)
$91
Project Budget (USD)
$30 - $250

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/common_func.php3:156
psaerror(string 'Unable to connect to database: Too many connections')
1: /usr/local/psa/admin/auto_prepend/auth.php3:90



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.

*WARNING* - MY BUSY WEBSITE IS AN ADULT PORN SITE, SO IF THIS BOTHERS YOU PLEASE DO NOT BID. I DON'T WANT TO OFFEND ANYONE.

*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 4.5p1

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 5.0.45

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

Skills required:
Linux, Project Management, System Admin, Web Security
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.


Hire nknk
$ 50
in 3 days
$ 65
in 0 days
$ 100
in 1 days
Hire linuxsupport
$ 100
in 1 days
$ 50
in 0 days
Hire codetrance
$ 60
in 0 days
$ 75
in 1 days
Hire missil3
$ 100
in 3 days
Hire sazmy
$ 90
in 1 days
$ 50
in 7 days