On Wed, Nov 05, 2003 at 07:10:41PM -0600, Matt W wrote: > Hi, > > In every instance I've seen, MySQL always allocates the amount you set > for key_buffer at server startup even if it never comes close to being > *used*. (It shouldn't be doing malloc()s or whatever for that on the > fly. :-)) Same thing for query_cache_size.
Yes. > Now about join, read, and sort buffers, that's correct that they're only > allocated when doing those specific operations. Yes, as documented in the fine manual. > BUT, the thing I'm not clear on is whether the amount you have set > is allocated all at once or as needed up to the specified size. Of > course, if the whole size is needed, it would be faster to allocate > it all at once. But if not..... I'm 95% sure it's allocated all at once. But a quick scan of the source would reveal the truth. :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 1,974,935,882 queries (430/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
