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 question

Discussion in 'General Discussion' started by cyanide, Apr 19, 2005.

  1. cyanide

    cyanide Well-Known Member

    Joined:
    Aug 11, 2003
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Toronto, Canada
    I'm looking at the my.cnf of a server and only see the following:
    What would be the purpose of only these 2 lines ?
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    max_connections means the maximum simultaneous connections to mysql server and is a server wide variable. simultaneous as in the exact same second.

    The default value for max_connections is 100. 500 is still acceptable.
     
  3. cyanide

    cyanide Well-Known Member

    Joined:
    Aug 11, 2003
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Toronto, Canada
    Thanks for the response, Andy - I actually knew what they meant :)

    I should clarify... those are the only 2 lines in this file.
    There is no wait_timeout, table_cache, thread_cache_size, nothing... just those 2 lines.
    So, I'm just wondering why might the other directives be missing ?
    What's the purpose ? and can it do any harm ?

    I'm seeing this on a physical dedicated LIux Enterprise and also a vps Fedora Core1
     
  4. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    The defaults are generally acceptable for most installations. Configuration directives would only need to be present if they are modified.

    mysqladmin variables

    Will show you your current settings.
     
  5. cyanide

    cyanide Well-Known Member

    Joined:
    Aug 11, 2003
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Toronto, Canada
    awesome, thanks... that's what I was looking for
     
Loading...

Share This Page