mysql config file

[MaRiOs]

Any one knows where the config file of mysql is located?

 

[Whistler]

Originally posted by MaRiOs
Any one knows where the config file of mysql is located?

locate is your friend:
locate my.cnf

or have a look at the MySQL variables it might also tell you where the my.cnf is located.

 

[MaRiOs]

I did that before posting but the info inside that file looked to me so small..that I was curious..

Someone asked me what is the number for the CurrectConnections in mysql and I was looking for it.I couldnt find this anywhere so I asume now that its unlimited.

 

[Whistler]

Originally posted by MaRiOs
I did that before posting but the info inside that file looked to me so small..that I was curious..

Someone asked me what is the number for the CurrectConnections in mysql and I was looking for it.I couldnt find this anywhere so I asume now that its unlimited.

CurrectConnections???

But look in a phpMyAdmin - the server Variables page will show you what settings is currently being used. Or you can always do it in the mysql console: SHOW VARIABLES;

 

[MaRiOs]

Current connection..i dont know..something like that :/

 

[Whistler]

max connections?

 

[MaRiOs]

he askes how many users/connection it can take in the same time....

 

[Whistler]

You need to have a look at

max connections and
max user connections

I think.

 

[jamesyeeoc]

Marios,

The /etc/my.cnf which is installed with Plesk is rather small, they leave all the other possible options to be defaulted by mySQL and pretty much only specify the few items which they want to make sure are set a certain way.

Full mySQL docs can be found at www.mysql.org, or if you are running 4.1x
http://dev.mysql.com/doc/refman/4.1/en/index.html