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!

/etc/my.cnf missing or what?

Discussion in 'General Discussion' started by virtualreality, Apr 24, 2012.

  1. virtualreality

    virtualreality Well-Known Member

    Joined:
    Jan 18, 2008
    Messages:
    78
    Likes Received:
    1
    Trophy Points:
    58
    Now the File: /etc/my.cnf shows just two lines in the below:

    [mysqld]
    skip-bdb
    skip-innodb

    My server is with CentOS, the /etc/my.cnf file should have the complete content there. Why the file content can not show? Or was it moved to some other location? It cannot be in this location, /etc/mysql/my.cnf (empty as always) since my server does not run Debian distribution, and also can not be in this place, /usr/local/mysql/etc/my.cnf (empty as always).

    Any help is highly expected and appreciated!


    VR
     
  2. NixTree

    NixTree Well-Known Member

    Joined:
    Aug 19, 2010
    Messages:
    407
    Likes Received:
    3
    Trophy Points:
    143
    Location:
    Gods Own Country
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    By default, there should be limited entries in my.cnf, on a cpanel server as the OPTIMIZED variable values vary based on servers based on its requirements. The rest of the values will be the default values. You can check the rest of the variable values using the following "mysqladmin variable" from shell.

    Thank you,
    Nibin.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If you want to see what variables might be useful to add, you can try running mysqltuner.pl for recommendations:

    Code:
    /usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. virtualreality

    virtualreality Well-Known Member

    Joined:
    Jan 18, 2008
    Messages:
    78
    Likes Received:
    1
    Trophy Points:
    58
    Thank you both for help!

    Tristan, I'll run the command you recommend and see what should be added.
     
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