Results 1 to 8 of 8
  1. #1

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

  2. #2
    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. #3
    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

  4. #4
    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. #5
    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. #6
    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.

  7. #7
    Join Date
    Apr 2005
    Location
    Bangladesh
    Posts
    593
    I suggest you go with a high speed SCSI. Thats gonna help you a lot.
    WebHosting.com.bd - Web Hosting Bangladesh
    DomainDokan.com - Domain Registration Bangladesh

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •