On Tue, Oct 29, 2002 at 08:25:00PM -0800, heath boutwell wrote: > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > Can you post the output of SHOW VARIABLES? > | > | key_buffer_size | 402649088
Hm. That's a 384MB key buffer. And you have 2GB of RAM. If the sum of your *.MYI files is more than 384MB, try increasing that to match. What's mytop say about your key efficiency? > | max_join_size | 4294967295 Wow. You doing really big joins? > thanks for taking a look at these... Other than that, I don't see anything terribly odd (unless I missed something). The only thing left to look at is SHOW STATUS. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,770,166,363 queries (241/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php