100 % cpu mysql too many connection - help

[tza]

i have server

intel xeon 2.4 ghz
2 gb ram

from yestrada
every 10 miniutes i have problem with problem : too many connection

and if i in root write "top" the mysql is 150% cpu

i chek many mysql and many users and suspend and the problem stay

what i need to do ??

thanks you

 

[LawsHosting]

If you increase the max_connections in the my.cnf file, does it still peak to 150%?

 

[tza]

how i go to his file and edit this

 

[tza]

i have no linux men he fired i alone in the war

please, what is the commands and what i need to do ?

thanks

 

[LawsHosting]

nano /etc/my.cnf

add or modify max_connections=250 under [mysqld]
save and restart mysql
Note: 100 is the default connections so 250 should do, if not keep increasing it until theres no high load, 500 should be plenty if you reach that.