<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><blockquote type="cite"><div><font class="Apple-style-span" color="#000000"><br></font>Actually, I'm just using the default settings for all of those from<br>the Gentoo ebuild, which I'd think is probably the same defaults you'd<br>get from the mysql source. Some of those aren't even in my cnf file,<br>so they're using built-in defaults, but here are all of those settings<br>from the running database:<br><br>show variables where variable_name in ('key_buffer_size',<br>'table_cache', 'sort_buffer_size', 'myisam_sort_buffer_size',<br>'query_cache_size', 'query_cache_limit', 'query_cache_type')<br>--------------<br><br>+-------------------------+----------+<br>| Variable_name | Value |<br>+-------------------------+----------+<br>| key_buffer_size | 16777216 |<br>| myisam_sort_buffer_size | 8388608 |<br>| query_cache_limit | 1048576 |<br>| query_cache_size | 0 |<br>| query_cache_type | ON |<br>| sort_buffer_size | 524288 |<br>| table_cache | 64 |<br>+-------------------------+----------+<br>7 rows in set (0.00 sec)<br></div></blockquote></div><br><div><br></div><div>Thanks. I'm using Gentoo as well but I've changed all the settings. Maybe I'll re-emerge it again.</div><div><br></div><div>Curtis</div><div><br></div></body></html>