Project Detail

MySql Expert Needed  

MySql Expert Needed is project number 263487
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Selected Service Provider)

Selected Providers: rshyethmusthafa

Budget: $30-250

Created: 05/24/2008 at 9:46 EDT

Bid Count: 1

Average Bid: N/A

05/31/2008 at 9:46 EDT

Project Creator: Showme View PM Post PM
Employer Rating: 9.96/109.96/109.96/109.96/109.96/109.96/109.96/109.96/109.96/109.96/10 (25 reviews)

Bid On This Project
 

Description

Needed someone with EXTENSIVE EXPERIENCE in Mysql, I have used several other people who claim alot and delivered less results then they claimed.

Currently we are running (Rayzz)on an Adult YouTube Type site. The script load averages over 2-10 with only 1 instance of Apache and MySQL running, and with mysql enabled to log slow queries, we are seeing queries taking over 15 seconds, and up to 90 seconds and sometimes locks up.

The SQL queries with Rayzz are EXTREMELY inefficient, we need the database to be "debugged" and re-written to make it more efficient,optimized and deal with the issue of closing every sql connection, after a script execution.

Also need to make server secure against hackers and suggest tips to improve performance. Server is a dedicated linux server (Cpanel/WHM/ CentOs) running some MySQL & perl scripts. Check to see why the load is high and take steps to lower the load, securing and optimizing the performance of the servers & harden against attacks.
Also need to make sure server hasn't already been comprimised.


Messages Posted: 0 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options
Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. 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.

    Bid on this Project