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 =
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
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