Which my.cnf file?

[devGOD]

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]

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]

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

 

[krava]

I advise you to visit:
http://forums.mysql.com/

probably all your MySQL related questions will be answered there.

 

[devGOD]

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]

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