Need Sql Expert to optimize server.

We have a ongoing project that requires a lot of sql and cpu usage. I am seeking a programmer or sql expert to make some tweak the server and make some recommendations to improve growing databases over time.

The site is a ad network and it stores traffic data for each website our ads are located on. When its not storing this data in the database table which is not about 10 million records, its also fetching ads from another table which is about 500,000+.

when the site gets too many request the cpu loads up and everything starts to crash. I am seeking a fixable solution to manage this growing problem and still maintain stability in add fetches, storing and updating a large database.

The other issue is the table with 10million, we have to updating all the click traffic so that its update other tables to show reports for users. I think now that its so big, its not getting to all the clicks and therefore not updating everything.

is there a limit to how many records can be updating in one sequence.

here are my server details.

* Intel Dual Xeon SuperMicro Server

* 1 Xeon CPU Core

* 2048MB Guaranteed Memory

* 100GB RAID-10 Disk Space

* 3000GB Premium Transfer

* R1Soft CDP Daily Backups

* 8 Dedicated IP Addresses

Also Here is my current load via apache status

Current Time: Monday, 31-Jan-2011 11:30:10 CST

Restart Time: Sunday, 30-Jan-2011 22:23:10 CST

Parent Server Generation: 10

Server uptime: 13 hours 7 minutes

Total accesses: 137882 - Total Traffic: 393.5 MB

CPU Usage: [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] - 4.99% CPU load

2.92 requests/sec - 8.5 kB/second - 2992 B/request

72 requests currently being processed, 4 idle servers

This project is to optimize or tweak the server and provide me a simple solution or idea to manage its growth.

Evner: AJAX, Javascript, Linux, MySQL, PHP

Se mere: when to manage,, sql programmer expert, sql database programmer, programmer sql, premium javascript, php sql programmer, php and sql programmer, need a javascript programmer for my website, my sql databases, how to make sequence, how to make ads, how to improve website traffic, how to improve site traffic, how to improve my website traffic, details about space, 48 hours in minutes, 1.5 hours in minutes, sql server programmer, transfer data from one site to the other, Sql reports, sql database improve, sql and c, server manage, server load

Om arbejdsgiveren:
( 110 bedømmelser ) hayneville, United States

Projekt ID: #932534

8 freelancere byder i gennemsnit $168 på dette job


I can do this.

$250 USD in 3 dage
(201 bedømmelser)
$250 USD på 1 dag
(62 bedømmelser)

please check pm

$50 USD in 0 dage
(74 bedømmelser)

Hello,we can start [login to view URL] check PM.

$120 USD in 0 dage
(42 bedømmelser)

Please check PMB for details.

$225 USD in 3 dage
(6 bedømmelser)

Hi, I have more then 8 years of experience in sql server. I already did this type of project for few companies. Now their database server is running smoothly. Want to know more, please PM me. Sadeque Sharif

$100 USD på 1 dag
(1 bedømmelse)

please check PMB

$250 USD in 5 dage
(3 bedømmelser)

I'm experienced in MySQL/PosgreSQL optimization. Check PM.

$100 USD in 3 dage
(0 bedømmelser)