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

    In Progress Configuring more than 1 IP address questions

    CrazyforLinux, Oct 13, 2017 at 11:46 PM, in forum: E-mail Discussions
    Replies:
    2
    Views:
    58
    cPWilliamL
    Oct 16, 2017 at 1:47 PM
  2. hinhthoi

    Question about autoSSL

    hinhthoi, Oct 13, 2017 at 10:25 AM, in forum: Security
    Replies:
    4
    Views:
    75
    hinhthoi
    Oct 13, 2017 at 11:20 AM
  3. Netsoft

    Enabling http/2 question

    Netsoft, Oct 12, 2017 at 5:23 AM, in forum: EasyApache
    Replies:
    2
    Views:
    82
    Netsoft
    Oct 12, 2017 at 1:06 PM
  4. sunilsaini

    Question about server security

    sunilsaini, Oct 9, 2017, in forum: Security
    Replies:
    2
    Views:
    91
    webhostuk
    Oct 10, 2017
  5. AK97127

    Viewing logs question

    AK97127, Oct 8, 2017, in forum: E-mail Discussions
    Replies:
    4
    Views:
    79
    cPanelMichael
    Oct 10, 2017

Share This Page