[Spce-user] kamailio-proxy.log error - mysql lost connection

[Martin Wong]

Yup. Thanks for the advice and I agree.

When there's a high dialing subscriber and I "accidentally" access the CDRs
on the web page, the CPU spikes and everything dies.

The MYSQL seems to be the one which has the highest CPU usage at all times.

I'll be putting in a physical machine + SAS drives asap.

Thanks and appreciate your quick help.

On Tue, May 28, 2013 at 11:22 AM, Jeremie Chism <jchism2 at gmail.com> wrote:

> CPU and ram usage stay low. If you see the load spiking high or staying
> high get ready for a crash. I/O wait is the biggest issue to watch on
> sipwise. I think Stephen and Kevin would back me up on that. 15K sas drives
> have fixed any problems we were having.
>
>
> On Monday, May 27, 2013, Martin Wong wrote:
>
>> Hi Jeremie, thanks for the info.
>>
>> What RAID config do you have on the SASes?
>>
>> Would probably take your advice on the drives. Considering it's on a VM
>> on a cloud provider...
>>
>> Anything else like CPU / RAM which I need to be concerned with?
>>
>> Thanks
>>
>> On Tue, May 28, 2013 at 10:32 AM, Jeremie Chism <jchism2 at gmail.com>wrote:
>>
>>> I/O wait kills sipwise. Just speaking from experience. If you have dial
>>> traffic and you are using sata drives or slow drives its just a matter if
>>> time before it breaks. We aren't using a dialer and we use sas 15K drives
>>> only b
>>>
>>> Sent from my iPhone
>>>
>>> On May 27, 2013, at 8:31 AM, Andrew Pogrebennyk <
>>> apogrebennyk at sipwise.com> wrote:
>>>
>>> > On 05/27/2013 03:28 PM, Martin Wong wrote:
>>> >> Nothing in the mysqld.err that stands out. After a reboot, the issue
>>> >> goes away.
>>> >>
>>> >> Not sure why.
>>> >>
>>> >> There's dialer traffic which makes lots of calls which probably is the
>>> >> cause. Not to say that the server load is very high... the CPU is
>>> quite low.
>>> >>
>>> >> Do you think it's because it's a virtual machine?
>>> >
>>> > That could be possible, but can't say for sure without knowing the
>>> > underlying hardware. What kind of HDD/RAID does that machine have?
>>> > Do you see high %wa percentage (IO wait) in 'top'? What is the disk
>>> > utilization reported in 'iostat -dx1' when that customer is dialing?
>>> >
>>> > HTH.
>>> > Andrew
>>> >
>>> >
>>> > _______________________________________________
>>> > Spce-user mailing list
>>> > Spce-user at lists.sipwise.com
>>> > http://lists.sipwise.com/listinfo/spce-user
>>>
>>
>>
>
> --
> Jeremie Chism
> Triton Communications
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130528/3459a839/attachment-0001.html>