Rewrite/Optimize Mysql queries on Youtube type site (Rayzz)

Avg Bid (USD)
Project Budget (USD)
$100 - $300

Project Description:
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.

Skills required:
Data Processing, Linux, Perl, PHP, System Admin
About the employer:
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.