<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;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</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=Section1>
<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"'>
mythtv-users-bounces@mythtv.org [mailto:mythtv-users-bounces@mythtv.org] <b>On
Behalf Of </b>Kevin Kuphal<br>
<b>Sent:</b> Wednesday, October 08, 2008 7:49 AM<br>
<b>To:</b> Discussion about mythtv<br>
<b>Subject:</b> Re: [mythtv-users] Storage groups: How to set
'SGweightLocalStarting' to 0?<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p>
<div>
<p class=MsoNormal>On Wed, Oct 8, 2008 at 9:27 AM, Jonathan Larson <<a
href="mailto:jtlarson@u.washington.edu">jtlarson@u.washington.edu</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p>I've got 3 BE's each with 2 storage drives. They are all connected to a nice
gigabit switch and use NFS and mount points so that all the BE's have access to
all recording dirs. All the storage drives are added to the default SG. <o:p></o:p></p>
<p> <o:p></o:p></p>
<p>I would like myth to balance the recordings across all the drives based on
free space rather than 'local' vs. 'remote' storage, so I tried stopping
mythBE, opening SQL as root, and executing the following command:<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>INSERT settings (value, data, hostname) VALUES ("SGweightLocalStarting
", 0, "");<o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><br>
Per the instructions on the wiki, you need to set a hostname when using this
setting<br>
<br>
<a href="http://www.mythtv.org/wiki/index.php/Storage_Groups_Weighting">http://www.mythtv.org/wiki/index.php/Storage_Groups_Weighting</a><br>
<br>
Kevin<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><span style='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'>So do I need to put in 3 entries—one for each BE, or 6—one for
each storage dir? <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 guess the problem for me is that the post you linked to addresses
‘SGweightPerDir’ not ‘SGweightLocalStarting’, and I’m just trying to figure out
which parts translate from one to the other…<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'>Jon<o:p></o:p></span></p>
</div>
</div>
</body>
</html>