Where is my my.cnf (it's not where it should be)

[chrissysdaddy]

I am very interested in all the helpfull information about server tune-ups and see that one of the main things is tweaking the my.cnf file. I am unable to find one. When I run "locate my.cnf" from the root, allI get is this:

[xxxx@xxxx /]# locate my.cnf
/etc/my.cnf.admin_appl
/etc/my.cnf.rpmsave

Which one should I be looking at and adjusting? They both only have about 8 - 10 lines in each one.

Thanks

[Dave#]

Um Locate might not work correctly for a number of reasons . . . find will though

find / -name *.cnf

You probably don't have one yet. Check your MYSQL startup script usually in /etc/init.d or /etc/rc3.d/init.d or similar and check if the config file paramater is set . . . if not then create a new file /etc/my.cnf and restart mysql

[chrissysdaddy]

Originally posted by Dave#
Um Locate might not work correctly for a number of reasons . . . find will though

find / -name *.cnf

You probably don't have one yet. Check your MYSQL startup script usually in /etc/init.d or /etc/rc3.d/init.d or similar and check if the config file paramater is set . . . if not then create a new file /etc/my.cnf and restart mysql

Thanks Dave!

I didn't find one. In /etc/init.d I found these files: mysql and mysqld. In mysql there is these lines:


# Try to find basedir in /etc/my.cnf
conf=/etc/my.cnf


I beleive what this (and you) are telling me is that it is looking for a file there but there is none there. Doesn't that mean mysql is running in a VERY basic mode with no configurations at all? If so, that could be why my server is crashing hu?

[Dave#]

I beleive what this (and you) are telling me is that it is looking for a file there but there is none there. Doesn't that mean mysql is running in a VERY basic mode with no configurations at all? If so, that could be why my server is crashing hu?

Yes most likely - I suggest putting at least something in there to 'tune' mysql

The sample configs in the php distribution are a good place to start - they are called things like my-huge.cnf my-small.cnf etc - simply copy one of those to /etc/my.cnf and restart the server

[eva2000]

you can create one at /etc/my.cnf and it will work :)

[chrissysdaddy]

Thanks for your help guys!

eva200, I am going to start with the suggested my.cnf you posted here:

http://www.vbulletin.com/forum/showthread.php?threadid=62913

Thanks again.