How to Optimize the the mysql

Discussion in 'Security' started by LENOVOhost, Aug 3, 2009.

0
  1. #1
    Hi

    Any one can assist me in Optimizing mysql Why because i am facing the high server load because of the mysql often
     
    LENOVOhost, Aug 3, 2009 IP
  2. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #2
    There are many tools out there that will help you. You can also increase your RAM to help. Take a look at my blog post regarding a couple of different scripts that will help you along:

    http://solidservers.ca/2009/07/tuning-tweaking-mysql/

    One thing to note, changes that are made need at least a day or more running to truly see if the results are what you are trying to achieve.
     
    RHS-Chris, Aug 3, 2009 IP
  3. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Log the slow queries (search google on how to do this), then use EXPLAIN to see what's causing them to be slow, then add indices or optimize your SQL statements.
     
    premiumscripts, Aug 4, 2009 IP