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!
  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:
    166
    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 ?
     
    #1 cyanide, Apr 19, 2005
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    193
    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.
     
    #2 AndyReed, Apr 19, 2005
  3. cyanide

    cyanide Well-Known Member

    Joined:
    Aug 11, 2003
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    166
    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
     
    #3 cyanide, Apr 19, 2005
  4. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    166
    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.
     
    #4 BenThomas, Apr 20, 2005
  5. cyanide

    cyanide Well-Known Member

    Joined:
    Aug 11, 2003
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Toronto, Canada
    awesome, thanks... that's what I was looking for
     
    #5 cyanide, Apr 24, 2005
(You must log in or sign up to post here.)
Loading...
Similar Threads - question
  1. ronaldst

    New Thread DNSCluster with DNSOnly Questions

    ronaldst, Apr 26, 2018 at 6:23 PM, in forum: Bind / DNS / Nameserver Issues
    Replies:
    0
    Views:
    8
    ronaldst
    Apr 26, 2018 at 6:23 PM
  2. inteldigital

    New Thread DNS questions

    inteldigital, Apr 26, 2018 at 5:42 PM, in forum: Bind / DNS / Nameserver Issues
    Replies:
    0
    Views:
    9
    inteldigital
    Apr 26, 2018 at 5:42 PM
  3. FreeTimers

    Encrypted email storage question

    FreeTimers, Apr 25, 2018 at 8:30 AM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    41
    cPanelMichael
    Apr 25, 2018 at 10:54 AM
  4. polo49

    Transfer domain name to new registrar question

    polo49, Apr 23, 2018 at 6:32 AM, in forum: General Discussion
    Replies:
    7
    Views:
    53
    polo49
    Apr 24, 2018 at 2:16 AM
  5. mohammadreza

    Service status shows services down question

    mohammadreza, Apr 21, 2018 at 2:23 PM, in forum: General Discussion
    Replies:
    12
    Views:
    118
    cPanelLauren
    Apr 25, 2018 at 7:01 AM

Share This Page