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.
8 freelancers are bidding on average $168 for this job
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