<br><br><div class="gmail_quote">On Wed, Sep 1, 2010 at 10:08 AM, Gabe Rubin <span dir="ltr"><<a href="mailto:gaberubin@gmail.com">gaberubin@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
My question is, will I see a performance gain by doing this or is<br>
there a bigger performance gain by having the system and the database<br>
on SATA?<br>
<br></blockquote><div><br><br>It's not really the interface that matters, it's more about the newer drives being faster. The performance gain mentioned here is that the database needs a lot of random I/O, which means seek time. The recordings also need to seek the drive, so you get a lot of seeking built up which kills performance. Splitting this up means that each drive only has to seek for one workload. As long as we have rotating media, this is an issue. So yes, even an older PATA drive for the OS/DB will boost overall performance of a Myth system. The biggest difference will be seen while recording or commflagging, but if you have something going on while mythfilldatabase runs, for example, it will slow things down. I got a boost on my old system with a 5400RPM 40GB PATA drive from an old TiVo for the OS/DB, just to give an example. :) <br>
<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Second question, if there is a performance gain, what is the best way<br>
to transfer all the bits over to the older PATA drive without having<br>
to reinstall everything? I imagine I need to reformat the PATA and<br>
partition it similar to how the SATA drive, but don't know much more<br>
about doing this type of work on linux.<br></blockquote></div><br><br>Match up the partition layout for any OS and DB mounts. Just make a directory to mount your recordings drive to and update /etc/fstab to match up. Copy everything over, then install your bootloader with some overide to make it install on the other drive. I don't remember the command I used, but I think I did it while booted to Grub's prompt. :) I believe grub will also let you tell it to boot from another disk and such. <br>
<br>Then just swap the boot order and you should be good to go. Not sure if it's any easier then re-installing and restoring a database backup, so pick your poison. <br>