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. Shadowrider

    Deferred due to greylisting question

    Shadowrider, Jun 24, 2017 at 3:42 AM, in forum: E-mail Discussions
    Replies:
    3
    Views:
    72
    cPanelMichael
    Jun 26, 2017 at 11:19 AM
  2. ajay.mindiii

    cPanel Trial Expired Question

    ajay.mindiii, Jun 23, 2017 at 6:24 AM, in forum: General Discussion
    Replies:
    2
    Views:
    37
    cPanelMichael
    Jun 23, 2017 at 7:39 AM
  3. tibbitts

    IP Migration Tool questions

    tibbitts, Jun 20, 2017, in forum: General Discussion
    Replies:
    4
    Views:
    58
    tibbitts
    Jun 20, 2017
  4. alios24

    Domain Using Gsuite Question

    alios24, Jun 20, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    57
    cPanelMichael
    Jun 21, 2017
  5. PeteS

    FirewallD setup questions

    PeteS, Jun 19, 2017, in forum: Security
    Replies:
    15
    Views:
    133
    Infopro
    Jun 29, 2017 at 4:19 AM

Share This Page