Limit user connections to mysql ?
Anyone know if its possible to limit the number of connections a user can make at the same time ? I'm having a problem that one of the databases on the server suddenly eating all free mysql process / all memory and server gets stuck,
when i check , i see that there is a raise of maybe 200 process in that time , i want to limit for example 25 processes max per user , so it wont happen again .
i already limited total number of connections to 400 , but it doesnt help .
thanks
Ben
