<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Sep 26, 2014 at 10:27 AM, Joseph Fry <span dir="ltr"><<a href="mailto:joe@thefrys.com" target="_blank">joe@thefrys.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><span class="">On Fri, Sep 26, 2014 at 10:08 AM, Mike Perkins <span dir="ltr"><<a href="mailto:mikep@randomtraveller.org.uk" target="_blank">mikep@randomtraveller.org.uk</a>></span> wrote:<br></span><span class=""><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span>On 26/09/14 14:09, Eric Sharkey wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span>
On Fri, Sep 26, 2014 at 5:13 AM, Simon Hobson <<a href="mailto:linux@thehobsons.co.uk" target="_blank">linux@thehobsons.co.uk</a>> wrote:<br>
<br>
</span><span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
It means that *every* write to the system filesystem has to contend with accesses to all the recording filesystems<br>
</blockquote>
<br>
The OS drive usage is dominated by reads.<br>
<br>
</span></blockquote>
Er, no. Every time that a recording is written to one of the storage directories a write is also issued to the database to update the seek table for that recording.<br>
<br>
That is why it is recommended that the mysql database is not placed on the same spindle as any storage directory, because you're automatically doubling the head movements - at least.<br>
<br>
You're right in that the OS may mostly be reads but there is always the database IO to consider. That is usually kept on the same drive as the OS.</blockquote><div><br></div></span><div>Your suggesting that every time you write to the database, the drive stops what its doing, seeks to the proper location, writes the data, seeks back, and continues where it left off.</div><div><br></div><div>In reality, both the drive itself, and mysql cache the writes... and while using a recording spindle definitely causes more head movement it's not nearly as bad as your simple model suggests.</div><div><br></div><div>Certainly on a heavy loaded system, it is optimal to put the DB on its own spindle(s)... but I can tell you from years of experience, on a moderate, 5 tuner (+9 virtual tuners) mythtv system, this is completely unnecessary. A simple mythtv system with several recordings, OS, and database all on the same spindle; I have built several such systems for friends and family. There is no reason that 3 hard drives, with a 60GB mirrored partition on each for the OS/DB, can't just as easily do the same, considering that until I exceed 3 concurrent recordings its typically only writing one recording to each drive anyway.</div></div></div></div>
</blockquote></div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Should read what I wrote before hitting send... the last paragraph should have said:</div><div class="gmail_extra"><br></div><div class="gmail_extra">Certainly on a heavy loaded system, it is optimal to put the DB on its own spindle(s)... but I can tell you from years of experience, on a moderate, 5 tuner (+9 virtual tuners) mythtv system, this is completely unnecessary. A simple mythtv system works great with several concurrent recordings, OS, and database all on the same spindle; I have built several such systems for friends and family. There is no reason that 3 hard drives, with a 60GB mirrored partition on each for the OS/DB, can't just as easily do the same, considering that until I exceed 3 concurrent recordings its typically only writing one recording to each drive anyway.<br></div></div>