Re: Re: MySQL eating all memory

2002-08-14 Thread Jocelyn Fournier
MAIL 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 = 1 join_buffer = 524288 record_buffer =1M sort_buffer = 8M tmp_table_size = 24M key_buffer =

Re: Re: MySQL eating all memory

2002-08-14 Thread m.reineke
Hi, all settings in my.cnf: max_connections = 512 max_connect_errors = 1 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 aft

Re: MySQL eating all memory

2002-08-13 Thread Thomas Seifert
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