In Progress

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

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: Data Processing, Linux, Perl, PHP, System Admin

See more: rayzz database, php mysql connection, rayzz script slow, rewrite optimize difference, rewrite style youtube, utube optimize mysql, youtube rewrite etmek, mysql youtube rating, optimize mysql queries script, query youtube database linux, optimize mysql queries, youtube rewrite without, youtube slow load, youtube script, sql queries, sql mysql, rewrite script, re type, queries, optimize mysql, mysql 4, locks, execution, database queries, optimize sql queries

About the Employer:
( 37 reviews ) mckinney, United States

Project ID: #181210