On Wednesday 11 December 2002 18:45, Benjamin Pflugmann wrote: > > These problems are causing me serious pain as whenever a large > > process starts my load avg jumps throught the roof. I run radius > > off of this database, and when the load jumps users fail to authenticate. > > Any help/sugestions with this matter would be great. > > 256MB for the key_cache on a 860MB system looks completely sane to me, > maybe even small, depending what else runs on the machine. But if that > memory usage makes problems, you should decrease it, of course. But > remember that the price you pay is a performance loss for MySQL. How > much, that depends on how efficient the key cache is with the new > size.
Well, my rough guess is that these 256m somehow gets swapped out. When large process that needs MySQL starts, MySQL gets loaded from swap and that, of course, makes loadavg go up alot. In rare cases some combination of these environment conditions makes system unusable. I've seen such. > On the other hand, I wonder what claims the other 590MB of your system? Well :) What can I suggest - try to lower the requirements for MySQL significantly OR try to raise it. Of course, you can also run mysqld with --memlock. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
