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

[Gigaron]

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

I'm going to put MySQL on a seperate server... which one is best for me:

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

or

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

[Xandrios]

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).

[Gigaron]

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

[Xandrios]

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?

[Gigaron]

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 :-)

[01globalnet]

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!!

[dotcomUNDERGROUND]

I suggest you go with a high speed SCSI. Thats gonna help you a lot.

[cheaptraffic]

apache may eat up too much RAM so you can use Lighttpd or litespeed( not free but worth it)