Re: High cpu usage

2018-10-25 Thread Machiel Richards
Hi Shawn Thank you for the response. In order to pause the slave , the stop the sql_io_thread, and to unpause they simply start the thread. I have run "show engine innodb status" yes and the threads show 90% as sleeping and then a few selects , all from the same table as it does

Re: High cpu usage

2018-10-25 Thread shawn l.green
Hello Machiel, On 10/25/2018 6:09 AM, Machiel Richards wrote: Good day all Hoping this mail finds you well. I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month. We

High cpu usage

2018-10-25 Thread Machiel Richards
Good day all Hoping this mail finds you well. I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month. We are running an opensips server on Centos 6.5 , using mysql 5.7.13 w