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.

MySQL optimization Core I5

Discussion in 'Workarounds and Optimization' started by ednilson, Jun 3, 2011.

  1. ednilson

    ednilson Member

    Joined:
    Jun 3, 2011
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Can someone help me optimize MySQL on a dedicated server Core I5 - 2400 with 8GB of RAM? My site currently has 400 to 500 users online and sometimes the server load is a bit high. My my.cnf is empty.
     
    #1 ednilson, Jun 3, 2011
    Last edited: Jun 3, 2011
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    So, you really do not have anything in /etc/my.cnf at all not even [mysqld] in it?

    Also, there are numerous threads suggesting running mysqltuner.pl, so I would suggest starting there:

    Code:
    /usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
     
  3. ednilson

    ednilson Member

    Joined:
    Jun 3, 2011
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I installed yesterday on my new cPanel dedicated server and not appeared my.cnf then created only with a [mysqld] bind-address = 127.0.0.1 to block remote connections (we can say that it is empty). mysqltuner.pl what does?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    It provides recommendations on settings to optimize. It doesn't do anything beyond check MySQL history since the last restart of MySQL and provide recommendations based on your settings and environment.
     
  5. ednilson

    ednilson Member

    Joined:
    Jun 3, 2011
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for the help, I'll do that.
     
  6. ednilson

    ednilson Member

    Joined:
    Jun 3, 2011
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I have a doubt appears "join_buffer_size <> 1.0M, or always use indexes with joins" what I put in join_buffer_size? I tried several values ​​and it always appears.
     
  7. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    I would skip adding anything for join_buffer_size at all. That is one value that the script recommends which I do not agree with the recommendation to change it from the default.
     
Loading...

Share This Page