<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Good morning, SSD’s would not work well in this environment. SSD’s are fast but the number of rewrites IO’s and other issues do not make it a fit. The burnout rate on the SSD’s is much higher than even the SATA. The true answer here is SAS drives at 15K RPM. They have the longevity and the speed to avoid issues.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>As mentioned earlier with Jeremie, we have learned the hard way about hardware choices. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Your best choice for configuration would be, SAS drives, in RAID5 with 1 hot spare/swap and 16GB ram or better. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I hope this helps.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Kevin<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> spce-user-bounces@lists.sipwise.com [mailto:spce-user-bounces@lists.sipwise.com] <b>On Behalf Of </b>Martin Wong<br><b>Sent:</b> Monday, May 27, 2013 11:20 PM<br><b>To:</b> Jeremie Chism<br><b>Cc:</b> <Unnamed><br><b>Subject:</b> Re: [Spce-user] kamailio-proxy.log error - mysql lost connection<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi guys,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>do you think SSD would cut it here? I would like your views on the write speeds for SSD vs SAS 15K<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Thanks<o:p></o:p></p><div><p class=MsoNormal>On Tue, May 28, 2013 at 11:36 AM, Martin Wong <<a href="mailto:martin.wong@binaryelements.com.au" target="_blank">martin.wong@binaryelements.com.au</a>> wrote:<o:p></o:p></p><div><p class=MsoNormal>Yup. Thanks for the advice and I agree.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>When there's a high dialing subscriber and I "accidentally" access the CDRs on the web page, the CPU spikes and everything dies.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>The MYSQL seems to be the one which has the highest CPU usage at all times.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I'll be putting in a physical machine + SAS drives asap.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks and appreciate your quick help.<o:p></o:p></p></div><div><div><div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Tue, May 28, 2013 at 11:22 AM, Jeremie Chism <<a href="mailto:jchism2@gmail.com" target="_blank">jchism2@gmail.com</a>> wrote:<o:p></o:p></p><p class=MsoNormal>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. <o:p></o:p></p><div><div><p class=MsoNormal><br><br>On Monday, May 27, 2013, Martin Wong wrote:<o:p></o:p></p><div><p class=MsoNormal>Hi Jeremie, thanks for the info.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>What RAID config do you have on the SASes?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Would probably take your advice on the drives. Considering it's on a VM on a cloud provider...<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Anything else like CPU / RAM which I need to be concerned with?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Thanks<o:p></o:p></p><div><p class=MsoNormal>On Tue, May 28, 2013 at 10:32 AM, Jeremie Chism <<a href="mailto:jchism2@gmail.com">jchism2@gmail.com</a>> wrote:<o:p></o:p></p><p class=MsoNormal>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<br><br>Sent from my iPhone<o:p></o:p></p><div><div><p class=MsoNormal><br>On May 27, 2013, at 8:31 AM, Andrew Pogrebennyk <<a href="mailto:apogrebennyk@sipwise.com">apogrebennyk@sipwise.com</a>> wrote:<br><br>> On 05/27/2013 03:28 PM, Martin Wong wrote:<br>>> Nothing in the mysqld.err that stands out. After a reboot, the issue<br>>> goes away.<br>>><br>>> Not sure why.<br>>><br>>> There's dialer traffic which makes lots of calls which probably is the<br>>> cause. Not to say that the server load is very high... the CPU is quite low.<br>>><br>>> Do you think it's because it's a virtual machine?<br>><br>> That could be possible, but can't say for sure without knowing the<br>> underlying hardware. What kind of HDD/RAID does that machine have?<br>> Do you see high %wa percentage (IO wait) in 'top'? What is the disk<br>> utilization reported in 'iostat -dx1' when that customer is dialing?<br>><br>> HTH.<br>> Andrew<br>><br>><o:p></o:p></p></div></div><div><div><p class=MsoNormal>> _______________________________________________<br>> Spce-user mailing list<br>> <a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>> <a href="http://lists.sipwise.com/listinfo/spce-user" target="_blank">http://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></p></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p></div></div><p class=MsoNormal><span style='color:#888888'>-- <br>Jeremie Chism<br>Triton Communications</span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></body></html>