<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Jun 11, 2008, at 11:09 AM, Curtis Stanford wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Actually it's over 100,000 rows. Still, mysql should handle it OK. My file system has plenty of space. After looking some more at it, I think it may be swapping a little bit. What my.cnf settings do you use? I think mine are a little high for 512M. I'm using Brad's setting right now:</div><div><blockquote type="cite"><font class="Apple-style-span" color="#000000"></font></blockquote><br><font class="Apple-style-span" color="#000000">ke</font>y_buffer = 32M<br>table_cache = 256<br>sort_buffer_size = 4M<br>myisam_sort_buffer_size = 16M<br>query_cache_size = 64M<br>query_cache_limit = 8M<br>query_cache_type = 1</div></div></blockquote><br></div><div>I looked for this thread before and didn't find it until just now, but it has a GREAT explanation of how to tune your database settings based on what you have to work with:</div><div><a href="http://www.gossamer-threads.com/lists/mythtv/users/318341">http://www.gossamer-threads.com/lists/mythtv/users/318341</a></div><div>Especially:</div><div><a href="http://www.gossamer-threads.com/lists/mythtv/users/318648#318648">http://www.gossamer-threads.com/lists/mythtv/users/318648#318648</a></div><div><br></div></body></html>