Results 1 to 8 of 8
-
05-12-2008, 05:05 AM #1Aspiring Evangelist
- Join Date
- Nov 2007
- Posts
- 359
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.
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
Intel Core2Quad Q6600 [4x2.4Ghz, 8MB Cache]
4GB DDR2-667 RAM
2 x Intel XEON Clovertown Quadcore E5310 [4x1.6Ghz, 8MB Cache]
4GB DDR-2 ECC FBDIMM RAM
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
-
05-12-2008, 05:18 AM #2Web 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
-
05-12-2008, 05:23 AM #3Aspiring Evangelist
- Join Date
- Nov 2007
- Posts
- 359
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
-
05-12-2008, 05:26 AM #4Web 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
-
05-12-2008, 05:34 AM #5Aspiring Evangelist
- Join Date
- Nov 2007
- Posts
- 359
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 :-)
-
05-12-2008, 09:15 AM #6Web Hosting Master
- Join Date
- Mar 2005
- Location
- Athens, Greece
- Posts
- 1,763
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!!▌ Managed.gr cloud hosting, paas, vps, dedicated, domain registration on global datacenters.
-
05-12-2008, 09:49 AM #7Web Hosting Master
- Join Date
- Apr 2005
- Location
- Bangladesh
- Posts
- 593
I suggest you go with a high speed SCSI. Thats gonna help you a lot.
-
05-12-2008, 07:05 PM #8Aspiring Evangelist
- Join Date
- Feb 2008
- Location
- Miami FL
- Posts
- 376
apache may eat up too much RAM so you can use Lighttpd or litespeed( not free but worth it)