How to improve server performance!?

Discussion in 'Site & Server Administration' started by draxima, Feb 2, 2008.

0
  1. #1
    Hi

    I have had a look at my server today for load averages, and it's a little too high which makes my sites slow and unresponsive or bad response time.

    Im running sites which gives an extra load on the mysql server (I think that's what makes it slow)


    What is the best thing to add to the server for better performance.....is it memory? or more cpu power?

    Please help out friends:)
     
    draxima, Feb 2, 2008 IP
  2. Kaizoku

    Kaizoku Well-Known Member

    Messages:
    1,261
    Likes Received:
    20
    Best Answers:
    1
    Trophy Points:
    105
    #2
    Login to the ssh server and kill the processes you don't need. BTW, what OS or distro you are using?
     
    Kaizoku, Feb 2, 2008 IP
  3. InFloW

    InFloW Peon

    Messages:
    1,488
    Likes Received:
    39
    Best Answers:
    0
    Trophy Points:
    0
    #3
    This totally depends on what your server bottleneck is. It may not be either of those and could be hard drives.

    But you said you had heavy MySQL usage so maybe this might help with some tweaks: http://www.day32.com/MySQL/ (MySQL Performance Tuning Primer Script)
     
    InFloW, Feb 4, 2008 IP
  4. mellow-h

    mellow-h Peon

    Messages:
    750
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Are you using Query Cache? Query cache is really great, it reduces the mysql load around 60-70% according to my practical experience :)
     
    mellow-h, Feb 6, 2008 IP
  5. Fedorpheux

    Fedorpheux Active Member

    Messages:
    710
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    80
    #5
    Yeah, I would guess that your bottleneck is either: (1) your connection (10 mbit vs 100 mbit vs 1 gigbit, etc) and/or (2) your ram.

    Let us know what your OS and connection it. The more specifics you provide, the easier for us.
     
    Fedorpheux, Feb 6, 2008 IP