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.

my.cnf on shared host

Discussion in 'Workarounds and Optimization' started by tiff2342, Oct 5, 2012.

  1. tiff2342

    tiff2342 Well-Known Member

    Joined:
    Apr 20, 2012
    Messages:
    140
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    how do you tweak your my.cnf for shared hosting? do you set high caching limits or keep small for just the main stuff?
     
  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
    Hello,

    Are you the root administrator of the machine with root SSH access to edit /etc/my.cnf file?

    If you are not, then only the hosting provider can make changes to the file.

    If you are the root administrator, you could run the following script:

    Code:
    /usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
    After running it, try implementing the suggestions it provides.

    Thanks!
     
Loading...

Share This Page