Hi, If you have 512 simultaneous connection MySQL could eat up to 128 + (8 + 1) * 512 = 4736 MB of memory What is your max_used_connections (displayed with SHOW STATUS;) ?
Regards, Jocelyn ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "ThomasSeifert" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 12:37 PM Subject: Re: Re: MySQL eating all memory Hi, all settings in my.cnf: max_connections = 512 max_connect_errors = 10000 join_buffer = 524288 record_buffer =1M sort_buffer = 8M tmp_table_size = 24M key_buffer = 128M max_allowed_packet = 1M thread_stack = 128k wait_timeout = 60 table_cache = 512 But i think sort_buffer etc. are free´d after use. Regards, Matt Thomas Seifert <[EMAIL PROTECTED]> schrieb am 13.08.02 23:47:30: > maybe too high sort-buffers and so on (in my.cnf) ? > > Thomas > > On Tue, 13 Aug 2002 22:02:42 +0200 <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > mysql 3.23.51 is running on a Linux 2.4.18 box (4cpu, 2GB) with Apache 1.3.39. > > The server is under load (~160 mysqld processes; 80-120 queries/second > > shown by "mysqladmin status"). > > The problem is that mysqld´s memory usage is growing all the time from > > 17MB after start up to 500MB 5 hours later. System load grows from > > 0.4 to 3. We have the same problem for earlier versions of mysql (ex. 3.23.49). > > > > Does anyone know this problem? Any solutions? > > > > Sincerely, > > Matt > > > > > > --------------------------------------------------------------------- > > 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 > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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