devGOD

Well-Known Member
Oct 18, 2003
122
0
166
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?
 

krava

Well-Known Member
Sep 23, 2003
149
0
166
cPanel Access Level
Root Administrator
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.
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.
 

devGOD

Well-Known Member
Oct 18, 2003
122
0
166
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
 

devGOD

Well-Known Member
Oct 18, 2003
122
0
166
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...
 

mickalo

Well-Known Member
Apr 16, 2002
782
5
318
N.W. Iowa
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...
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