MySQL: Too many connections
hopefully someone in here knows mysqlGot a server running mysql, running into instablity issues with it, about 300 customers on it, server gets "too many connections" daily, to the point, even root cant even login to mysql to see who the offending user is, even though plain jane on MySQL, sql is suppose to leave 1 connection avail for root
Any way to track down why mysql is dying and/or reaching this point of connections issue? (i already got logging enabled, edited the my.cnf as much as i think i can, no help)...
atm im stuck (3 other servers had this problem in the past and i seemd to fix this in the past by running corruption check / fix but so far no go on this server) any way i can configure mysql to say...be in safe mode or something so i can find out where / how / what to fix??
Today SQL crashed to the point where, it wasnt getting too many connections error, rather you couldnt even get INTO mysql, its like it was overloaded, I couldnt even kill -8 or skill it, i had to reboot the machine