MySQL performance

Discussion in 'MySQL' started by Namesniper, Dec 16, 2006.

0
  1. #1
    Hi,

    Can you please tell me,considering that the database size is 600 MB,which part of the server affects the MySQL intensive website,like a forum, performance HDD (SATA/SCSI) CPU (single/dual core) or RAM (2 or 3 GB) ?
     
    Namesniper, Dec 16, 2006 IP
  2. Cypherus

    Cypherus Peon

    Messages:
    1,551
    Likes Received:
    102
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I'm not a hardware geek, but my guess is CPU since a mysql job is based on alot of calculations.. but the two other parts are important as well..
     
    Cypherus, Dec 16, 2006 IP
  3. Namesniper

    Namesniper Well-Known Member

    Messages:
    365
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    118
    #3
    I see,anymore suggestions ?
     
    Namesniper, Dec 18, 2006 IP
  4. saadahmed007

    saadahmed007 Admínistratör

    Messages:
    5,272
    Likes Received:
    869
    Best Answers:
    0
    Trophy Points:
    380
    #4
    AMD Based cpu would be best with GB Ram ;)
    Saad
     
    saadahmed007, Dec 18, 2006 IP
  5. 1EightT

    1EightT Guest

    Messages:
    2,646
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Ram is the biggest thing to consider for heavy mysql usage. Second would be cpu and third would be hard drive. You shouldn't have to worry about hard drive too much as long as you have enough ram so your queries aren't being swapped to disk.

    This comes from the software I run which is all sql based (15GB database right now)
     
    1EightT, Dec 18, 2006 IP