Annulleret

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] - [url removed, login to view]% CPU load

[url removed, login to view] 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.

Færdigheder: AJAX, Javascript, Linux, MySQL, PHP

Se mere: sql programmer expert, sql database programmer, programmer sql, premium javascript, php sql programmer, need javascript programmer website, sql databases, make sequence, make ads, improve website traffic, details space, sql server programmer, transfer data one site, sql reports, sql database improve, server manage, server load, reports sql server, raid 5, network sec, need programmer idea, manage server, ip sec, intel, idle

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

Projekt-ID: #932534

8 freelancere byder i gennemsnit $168 for dette job

stels88

I can do this.

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

please check pm

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

Hello,we can start now.Please check PM.

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

Please check PMB for details.

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

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)
2.4
salam786

please check PMB

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

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

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