Hi Drew, ----- Original Message ----- From: "Drew Toussaint" <[EMAIL PROTECTED]>
> We have a system in place that is a LAMP application. The > system we have it running on is a FreeBSD 4.3 on a Pentium 3 > 1Ghz with 500MB of RAM. > > A mysqladmin -i5 stat returns: > Uptime: 44254 Threads: 24 Questions: 779657 Slow queries: 531 > Opens: 213 Flush tables: 1 Open tables: 207 Queries per second > avg: 17.618 > > We have a sort_buffer of 32M! Is this to big? Does anyone have any > recommendations of what size it should be? sort_buffer is allocated per thread: memory required for sort_buffer = threads * sort_buffer, so 24 * 32 = 768 MB. Already more than your RAM (and that's without any of the other memory requirements!), plus I'm guessing that 24 threads is not your peak load. Basically, the same rules would apply to sort_buffer as they would for record_buffer, and I know you've got notes for that one ;-) The setting shouldn't necessarily be exactly the same, but similar considerations apply. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- 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
