<br><br><div class="gmail_quote">On Thu, Feb 21, 2008 at 8:44 PM, Brad DerManouelian <<a href="mailto:myth@dermanouelian.com">myth@dermanouelian.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style=""><div><div></div><div class="Wj3C7c"><div><div>On Feb 21, 2008, at 2:10 PM, James Gutshall Jr wrote:</div><br><blockquote type="cite">On Thu, Feb 21, 2008 at 3:24 PM, Captain Krypto <<a href="mailto:captainkrypto@gmail.com" target="_blank">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></div><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></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></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></div><font color="#888888"><div>-Brad</div><div><br></div></font></div></div><br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br><br>I installed nagiosgraph on my backend system to measure and graph the amount of memory being used by programs. I notice that mysql memory use just continues to rise, the longer the system is running. In one instance, I even saw in my logs that mysql was killed by the kernel out of memory killer. I solved this problem by restarting mysql daily when there are no active recordings or transcoding going on.<br>
<h2><a id="week">Weekly</a></h2><a href="https://mymythtv/nagiosgraph/show.cgi?host=localhost&service=RSS%20Mysqld&geom=&rrdopts=&db=RSS&offset=604800#week">previous</a> / <a href="https://mymythtv/nagiosgraph/show.cgi?host=localhost&service=RSS%20Mysqld&geom=&rrdopts=&db=RSS&offset=-604800#week">next</a><br>
<div class="graphs"><img src="https://mymythtv/nagiosgraph/show.cgi?host=localhost&service=RSS%20Mysqld&db=RSS&graph=777600&geom=&rrdopts=%2Dsnow%2D777600%2D0%20%2Denow%2D0" alt="Graph"></div><div class="graph_description">
<cite><strong>RSS</strong><br></cite></div><h2><br></h2><br><br>The dips in the graph correspond to when mysql was restarted.<br><br><br>