<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Feb 21, 2008, at 2:10 PM, James Gutshall Jr wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">On Thu, Feb 21, 2008 at 3:24 PM, Captain Krypto <<a href="mailto:captainkrypto@gmail.com">captainkrypto@gmail.com</a>> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> ...Besides the usual mythtv functions...</blockquote><div><br>Another thought is depending on usage, size, etc, mysql loves memory. you can tweak your my.cnf file to have extra caching, extra allocated memory, etc to speed up database queries, etc. Also, given enough memory, mysql will try to run everything from ram. that is in addition to disk caching linux will provide. however, most of the memory will sit unused on the machine, most people tend to use 1-2GB of ram for their higher end machines... unless they are not "myth-only" boxes.<br> --James<br></div></div></blockquote></div><br><div>I just upgraded my master backend from 512MB (constantly using 200+ MB swap) to 2GB RAM which is a bit overkill, but I'd love to make MySQL happier. Whenever I am running a mythfilldatabase, my backend refuses to make any connections to a frontend until it's done and I believe it's due to high MySQL usage. Anyway, my current my.cnf looks like this:</div><div><br class="webkit-block-placeholder"></div><div><div>old_passwords=1</div><div>key_buffer = 16M</div><div>table_cache = 128</div><div>sort_buffer_size = 2M</div><div>myisam_sort_buffer_size = 8M</div><div>query_cache_size = 16M</div><div><br class="webkit-block-placeholder"></div><div>Anyone have recommendations as to what I can set these to or is it more of a "raise it, see how it goes, raise it again, see how it goes" type of thing?</div><div>The machine runs MySQL, backend (with a PVR-150) and a frontend that's only used with a Slingbox when I'm away from home.</div><div><br class="webkit-block-placeholder"></div><div>-Brad</div><div><br class="webkit-block-placeholder"></div></div></body></html>