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!

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 ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 cyanide, Apr 19, 2005
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cyanide, Apr 24, 2005
(You must log in or sign up to post here.)
Loading...
Similar Threads - question
  1. MattGarner

    DNS Clustering questions

    MattGarner, Nov 14, 2018 at 4:07 AM, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    43
    cPanelLauren
    Nov 15, 2018 at 8:28 AM
  2. blipper

    Removal of SSL Sharing Question

    blipper, Nov 9, 2018, in forum: Security
    Replies:
    3
    Views:
    86
    cPanelMichael
    Nov 13, 2018 at 12:29 PM
  3. dont_panic

    Question about Perl header files when using cPanel's Perl

    dont_panic, Nov 9, 2018, in forum: cPanel Developers
    Replies:
    6
    Views:
    136
    dont_panic
    Nov 16, 2018 at 5:59 AM
  4. mtindor

    Questions about Squirrelmail deprecation

    mtindor, Nov 8, 2018, in forum: E-mail Discussion
    Replies:
    2
    Views:
    84
    mtindor
    Nov 12, 2018 at 9:59 AM
  5. Jose Rivero

    View Sent Summary Totals Question

    Jose Rivero, Nov 7, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    70
    cPanelLauren
    Nov 8, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice