The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    16
    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:
    36
  3. meeti

    meeti Well-Known Member

    Joined:
    Dec 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    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:
    36
    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