<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On 11-Jun-08, at 10:25 AM, Tom Dexter wrote:</div><blockquote type="cite"><div>I'm not trying to be evangelical about starving your machine for ram<br>or anything :D...just pointing out that I've had no need to upgrade<br>from 526MB.<br><br>My program table has about 28000 records at any one time, but I have<br>to tell you 10000 rows in a mysql table is nothing. That shouldn't be<br>a big issue even if something was doing a fair amount of non-indexed<br>table scans. I occasionally use an old IBM thinkpad for web<br>development with apache and mysql etc installed under Gentoo. Believe<br>it or not, that machine is a lowly 700 Mhz P-III with 256MB of ram and<br>it handled one project I was working on with a 3 million row table<br>without much trouble at all.<br><br>I have very little compiled into my Gentoo kernels that I don't<br>need...maybe that's a help, though I can't believe it's a big factor.<br>A modular kernel with only the modules you need loaded should be about<br>as good I'd think.<br><br>I don't know if it was discussed anywhere in this thread before, but<br>is the file system that your database files reside on possibly getting<br>close to full or anything?<br></div></blockquote></div><br><div><br></div><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><br></div><div>Curtis</div><div><br></div></body></html>