my.cnf for 4.1 - where is it?

[SupermanInNY]

Hi all,

I've installed CentOS 4.3 with DA install.
Where is the file: my.cnf located at?

I have too many connections errors and I need to increase it up.

Any pointers?

I've cp my-large.cnf to: /etc/my.cnf but I'm not sure that is what I need to do.

Please advise.

Thanks,

-Alon.

 

[toml]

The my.cnf does not install a my.cnf by default. MySQL just uses default values, unless you create one or copy a default one to /etc/my.cnf as you did.

 

[Pascal]

/etc/my.cnf

[mysqld]
max_connections=500

Restart MySQL and it will overrule the max_connections

 

[SupermanInNY]

/etc/my.cnf

[mysqld]
max_connections=500

Restart MySQL and it will overrule the max_connections

I was close
I just missed the max_connection string. I have it in my other servers, just forgot about this one.
Is the my.cnf for version 4.0 and version 4.1 the same?

 

[Pascal]

I was close
I just missed the max_connection string. I have it in my other servers, just forgot about this one.
Is the my.cnf for version 4.0 and version 4.1 the same?

Just, try it. You'll see if MySQL does start or not... I thought the file which is posted here in the KB didnt work on 4.1.