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!

Which my.cnf file?

Discussion in 'General Discussion' started by devGOD, Nov 21, 2006.

  1. devGOD

    devGOD Well-Known Member

    Joined:
    Oct 18, 2003
    Messages:
    122
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Atlanta, GA
    does anyone know which my.cnf file i should make changes in? i have about 5 of them.... i'm assuming its /etc/my.cnf but after adding a log slow query entry and nothing was outputed I'm wondering if that was the wrong my.cnf file.

    also is there a site that you can input your server spec like how much ram and then it outputs the settings you need for the my.cnf file?
     
    #1 devGOD, Nov 21, 2006
  2. krava

    krava Well-Known Member

    Joined:
    Sep 23, 2003
    Messages:
    149
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    the file /etc/my.cnf is the main MySQL config file. When the file is updated you need to restart MySQL in order to apply the changes.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 krava, Nov 21, 2006
  3. devGOD

    devGOD Well-Known Member

    Joined:
    Oct 18, 2003
    Messages:
    122
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Atlanta, GA
    thanks. do you know of a site that tells you how to configure the my.cnf ... i have 3 gigs of ram on my server so I need an online configure script or help manual that tells how much memory each setting should have for 3gigs of ram systems
     
    #3 devGOD, Nov 21, 2006
  4. krava

    krava Well-Known Member

    Joined:
    Sep 23, 2003
    Messages:
    149
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 krava, Nov 21, 2006
  5. devGOD

    devGOD Well-Known Member

    Joined:
    Oct 18, 2003
    Messages:
    122
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Atlanta, GA
    mysql.com is not all that helpful... they don't explain what each feature does and how to calculate the proper memory needed. i've been searching google all day. and i'm surprised that no one has created a simple program that reads your mysql processes and outputs recommended Options... I just need a listing of all the options and a diagram that says if you have 1gig ram then 32MB should be used for ever gig...
     
    #5 devGOD, Nov 21, 2006
  6. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    782
    Likes Received:
    5
    Trophy Points:
    318
    Location:
    N.W. Iowa
    if you look in the folder:
    /usr/share/doc/MySQL-server-<VERSION_NUMBER>

    replace the <VERSION_NUMBER> with your MySQL version, IE: 4.1.21
    there some very good examples of my.cnf files that you can use or modify as needed.

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 mickalo, Nov 21, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - file
  1. sjackson_Bluehost

    New Thread what file contains Default Webmail client

    sjackson_Bluehost, Mar 21, 2019 at 3:41 PM, in forum: E-mail Discussion
    Replies:
    0
    Views:
    29
    sjackson_Bluehost
    Mar 21, 2019 at 3:41 PM
  2. TechBill

    New Thread php scripts cannot see or access binary files

    TechBill, Mar 21, 2019 at 11:31 AM, in forum: General Discussion
    Replies:
    2
    Views:
    49
    TechBill
    Mar 21, 2019 at 12:37 PM
  3. phil99

    File and Directory Restoration - mail dir not visible

    phil99, Mar 20, 2019 at 6:42 AM, in forum: Data Protection
    Replies:
    2
    Views:
    47
    Infopro
    Mar 21, 2019 at 5:53 PM
  4. Robert K

    SOLVED Open a directory in File Manager using iPad?

    Robert K, Mar 19, 2019 at 2:31 PM, in forum: General Discussion
    Replies:
    3
    Views:
    139
    Infopro
    Mar 19, 2019 at 3:59 PM
  5. basketmen

    New Thread Execute a php file in /home/file.php to exclude from php limit

    basketmen, Mar 19, 2019 at 1:21 PM, in forum: General Discussion
    Replies:
    1
    Views:
    151
    raysolomon
    Mar 19, 2019 at 6:23 PM

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