Mysql "too many open connections"
I have started having some mysql problems on a mysql server. The server has 512MB ram PIII 1Gig etc, but it has now become very slow but when i run top, the cpu is 80+ idle, more than half the memory is free, so what gives....also no processes are killing any resources. I have also started to get a problem with "too many connections open" how can i :
1) increase the maximum connection from the defaul 100 ( where is the config file )
2) How can i check which db/user has the poor script thats not closing connections or can i limit the number of open connections per user?
Is there anything else that i can do, perhaps to increase the number of open files for the server ( its Redhat 6.1 ) i have increase these before but dont recall how i did it lol
Cheers
