hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Dedicated Server : Mysql Server - Dual Xeon Quadcore or Core2Quad
Reply

Forum Jump

Mysql Server - Dual Xeon Quadcore or Core2Quad

Reply Post New Thread In Dedicated Server Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 05-12-2008, 05:05 AM
Gigaron Gigaron is offline
Aspiring Evangelist
 
Join Date: Nov 2007
Posts: 353

Mysql Server - Dual Xeon Quadcore or Core2Quad


I'm just about to buy a server for my Database.

My site does 230,000 unique visitors per day and I have MySQL and Httpd on the same server with 2gb ram and quad2core.

Quote:
top - 17:58:36 up 9 days, 18:40, 1 user, load average: 3.42, 3.48, 3.76
Tasks: 411 total, 10 running, 400 sleeping, 0 stopped, 1 zombie
Cpu(s): 41.6%us, 11.9%sy, 0.0%ni, 45.5%id, 0.1%wa, 0.1%hi, 0.9%si, 0.0%st
Mem: 2074480k total, 1883652k used, 190828k free, 139108k buffers
Swap: 1052248k total, 3408k used, 1048840k free, 963192k cached
I'm going to put MySQL on a seperate server... which one is best for me:

Quote:
Intel Core2Quad Q6600 [4x2.4Ghz, 8MB Cache]
4GB DDR2-667 RAM
or

Quote:
2 x Intel XEON Clovertown Quadcore E5310 [4x1.6Ghz, 8MB Cache]
4GB DDR-2 ECC FBDIMM RAM
Should I be getting 6gb ram? Does it make much of a difference?

from tuning-primer.sh

MEMORY USAGE
Max Memory Ever Allocated : 1 G
Configured Max Per-thread Buffers : 9 G
Configured Max Global Buffers : 32 M
Configured Max Memory Limit : 9 G
Physical Memory : 1.97 G

Max memory limit exceeds 90% of physical memory



Sponsored Links
  #2  
Old 05-12-2008, 05:18 AM
Xandrios Xandrios is offline
Web Hosting Master
 
Join Date: Jun 2004
Location: Bay Area
Posts: 1,320
It seems either one would be fine. My guess would be the 3220 since it has 50% more clockspeed. However CPU is not the most important factor for a database server so both would work.

Most important is ram and drives. How large is your database? From your tuning script it looks like you hardly go past 1GB ram so 4Gb should be more than enough for now. As long as you can upgrade to 8 or 16 later on

As for drives: SATA2 since they support NCQ, preferably a 10k drive (WD raptor). If youhave the budget a SCSI drive would be even better (But much more expensive too).

__________________
Powered by Level3, GBLX and AT&T

  #3  
Old 05-12-2008, 05:23 AM
Gigaron Gigaron is offline
Aspiring Evangelist
 
Join Date: Nov 2007
Posts: 353
Database is like 4mb. The reason why its so heavy on memory is because the script captures, sorts and checks for unique visitors.

WHere did you get the number 3220 from?

Thanks

Sponsored Links
  #4  
Old 05-12-2008, 05:26 AM
Xandrios Xandrios is offline
Web Hosting Master
 
Join Date: Jun 2004
Location: Bay Area
Posts: 1,320
Ah my apologies, I meant the Q6600 (The xeon equivalent is called X3220).

The dual quad core Xeon would end up with 8 cores of 1.6Ghz then and be fastest. It will probably be a _lot_ more expensive as well tho.

With such a small database I wonder if the database is actually the problem on your current server. It would fit into memory easily now and should not produce much load because of that. Do you know which process is causing the load currently?

__________________
Powered by Level3, GBLX and AT&T

  #5  
Old 05-12-2008, 05:34 AM
Gigaron Gigaron is offline
Aspiring Evangelist
 
Join Date: Nov 2007
Posts: 353
Hi. I just ordered the one you suggested.

Yes. I know which one causes the load. I have had many people look at it and the load is caused because of the lack of memory.

The script is a commercial script and is designed for machines with more ram. Since my server is getting more and more visitors but no upgrade on capacity, its about time I meet the minimum requirements :-)

  #6  
Old 05-12-2008, 09:15 AM
01globalnet 01globalnet is offline
Web Hosting Master
 
Join Date: Mar 2005
Location: Athens, Greece
Posts: 1,523
Seems to me a bad script... is there a need for a script to check the unique visitors in each request... They could have cached these stats for X mins or hours...

So, when your database reaches at 50mb you are going to need the power of 10 servers haha!!

__________________
Antonis Adamakos @ FuzzFree :: Fully Managed Web Hosting, Development, Online Marketing

  #7  
Old 05-12-2008, 09:49 AM
dotcomUNDERGROUND dotcomUNDERGROUND is offline
Web Hosting Master
 
Join Date: Apr 2005
Location: Bangladesh
Posts: 583
I suggest you go with a high speed SCSI. Thats gonna help you a lot.

__________________
WebHosting.com.bd - Web Hosting Bangladesh
Limited Sites Per Server | cPanel | RVSiteBuilder PRO | Rapid Support | Pay-As-You-Go Reseller
DomainDokan.com - Domain Registration Bangladesh
Real-time Registration | Online Control Panel | Rapid Support | Turn-key Reseller

  #8  
Old 05-12-2008, 07:05 PM
cheaptraffic cheaptraffic is offline
Aspiring Evangelist
 
Join Date: Feb 2008
Posts: 372
apache may eat up too much RAM so you can use Lighttpd or litespeed( not free but worth it)

Reply

Related posts from TheWhir.com
Title Type Date Posted
Web Hosting Sales and Promos - June 13, 2014 Web Hosting News 2014-06-13 18:30:39
Web Hosting Sales and Promos Roundup – July 26, 2013 Web Hosting News 2014-05-23 15:42:54
Web Hosting Sales and Promos Roundup -- January 18, 2013 Web Hosting News 2014-05-23 15:43:22
ZNet Launches New Company NodeFirst to Serve India Dedicated Server Market Web Hosting News 2013-01-02 13:16:39
Web Hosting Sales and Promos Roundup – November 16, 2012 Web Hosting News 2014-05-23 15:43:31


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?