Mysql getting more than 90% CPU usages
Posted: Fri Dec 12, 2008 2:11 am
Hi all,
We are using vicidialnow 1.1 and it was working great. Suddenly yesterday the electricity got down and vicidial system got rebooted while in production. After that we are unable to use it because of mysql using very high memory.
when i do mysqladmin processlist, it shows it has been locked on the query that is selecting live_sip_channels. Please help
Thanx in advance
amir
We are using vicidialnow 1.1 and it was working great. Suddenly yesterday the electricity got down and vicidial system got rebooted while in production. After that we are unable to use it because of mysql using very high memory.
when i do mysqladmin processlist, it shows it has been locked on the query that is selecting live_sip_channels. Please help
Thanx in advance
amir