Page 1 of 1

Mysql getting more than 90% CPU usages

PostPosted: Fri Dec 12, 2008 2:11 am
by amirshr
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

PostPosted: Fri Dec 12, 2008 2:35 am
by mflorell
Looks like you need to run "myisamchk -f" on all tables to clean up the tables and indexes.

PostPosted: Fri Dec 12, 2008 7:09 am
by amirshr
Thanx mflorell
That worked for me.
:)