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.

/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:
    76
    Likes Received:
    0
    Trophy Points:
    6
    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:
    386
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Gods Own Country
    cPanel Access Level:
    Root Administrator
    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.
     
  3. 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
    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
     
  4. virtualreality

    virtualreality Well-Known Member

    Joined:
    Jan 18, 2008
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Thank you both for help!

    Tristan, I'll run the command you recommend and see what should be added.
     
Loading...

Share This Page