Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

how can i optimize my mysql ?

Discussion in 'General Discussion' started by meeti, Feb 23, 2008.

  1. meeti

    meeti Well-Known Member

    Joined:
    Dec 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    66
    Hi,

    my server has some forums on it,

    and it need mysql with php to run,

    i want to optimize the mysql to get better performance,



    can anyone teach how can i check it my setting is ok and how can i do?



    thanks
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    166
  3. meeti

    meeti Well-Known Member

    Joined:
    Dec 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    66
    Hi,


    as usual,

    when i edit the file /etc/my.cnf,

    all the mysql setting will run as it write with?



    after editing,should i restart the mysql?



    thanks
     
  4. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    166
    After editing my.cnf, yes you will need to restart mysql for the configuration to load. Providing your settings are correct, mysql should restart just fine. If not, then obviously you have invalid settings.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice