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. Spork Schivago

    Questions about AutoSSL

    Spork Schivago, Aug 21, 2017 at 1:47 PM, in forum: Security
    Replies:
    7
    Views:
    58
    Spork Schivago
    Aug 22, 2017 at 4:46 PM
  2. lukapaunovic

    Securing server without CloudLinux question

    lukapaunovic, Aug 19, 2017 at 11:17 AM, in forum: Security
    Replies:
    6
    Views:
    90
    cPanelMichael
    Aug 22, 2017 at 8:32 AM
  3. inetbizo

    JailShell Question

    inetbizo, Aug 17, 2017 at 6:51 PM, in forum: General Discussion
    Replies:
    1
    Views:
    32
    cPanelMichael
    Aug 18, 2017 at 12:56 PM
  4. informatica rme

    Nameserver Setup Question

    informatica rme, Aug 17, 2017 at 3:18 PM, in forum: Bind / DNS / Nameserver Issues
    Replies:
    2
    Views:
    42
    informatica rme
    Aug 18, 2017 at 2:56 AM
  5. silverbytes

    SpamAssassin Subject in Whitelist question

    silverbytes, Aug 16, 2017 at 7:29 AM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    44
    cPanelMichael
    Aug 16, 2017 at 10:09 AM

Share This Page