From owner-freebsd-stable@FreeBSD.ORG Fri May 18 00:24:51 2007 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id EB8EC16A403 for ; Fri, 18 May 2007 00:24:50 +0000 (UTC) (envelope-from ajwwong@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by mx1.freebsd.org (Postfix) with ESMTP id A9F9513C455 for ; Fri, 18 May 2007 00:24:50 +0000 (UTC) (envelope-from ajwwong@gmail.com) Received: by an-out-0708.google.com with SMTP id d23so179153and for ; Thu, 17 May 2007 17:24:50 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole:in-reply-to:message-id; b=lh0ZtCnTH+NIwuNRX+rJuvnKz+zUFTnhHfCEuVZgQKHbp+uY2AtQR3SglaMv/3N7jCd+J3Ghlb0ehGjxv1COU80U2FtE1c7IhUk5VzilNy3B7MBWeyRYHJBlvz8fN2q0pT+PZZ30Uuvkb+I8mX8LEiibhwyBHXtUMwBRS3/ItPo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole:in-reply-to:message-id; b=g5BpS7vEYlZyCMqXl5zfIX4dp0c1snDDROvZsWiZzBZBlhfEL39nZ0UyG+Z3BdeVGHCdah4yqLb4OLmYB/u0nTa8Pr+zKjBGs/BAfIScL82zZUWQqLtpIemNlSh2fNswOZ/GZLv2waG9BbjRQMIV2zYy29UKMRB9SEpI6F/qaD8= Received: by 10.100.125.5 with SMTP id x5mr724183anc.1179447889696; Thu, 17 May 2007 17:24:49 -0700 (PDT) Received: from LettingGo ( [68.183.91.76]) by mx.google.com with ESMTP id b29sm5319818ana.2007.05.17.17.24.48; Thu, 17 May 2007 17:24:49 -0700 (PDT) From: "Albert Wong" To: , Date: Thu, 17 May 2007 17:24:54 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 thread-index: AceYytInJ9hvlGq9Tliky6R2CXHqOwAFzBwg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 In-reply-to: <464CC70B.4090508@datapipe.com> Message-ID: <464cf251.017c7baf.440b.5f70@mx.google.com> Cc: Subject: RE: mysql frequently crash on 6.2 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 18 May 2007 00:24:51 -0000 Mark: Thanks for the tips about the placement of the log into [mysqld] -- maybe it will start to show some error messages if I put it up into the mysqld section. :-) I will also take a look at table_cache and query_cache and read_rnd_buffer_size. [I've got some reading / figuring out to do!] Michael: And thanks also for the suggestion at looking into extensions.ini for the order of the modules. I'm not quite sure what do to there, but I'll definitely research this. Blessings, Albert > > One thing I normally turn off in MySQL is the query_cache . If your DB > is constantly receiving updates the query_cache is flushed to with each > update. This creates alot of useless overhead, in fact if set it very > high like to 1G or so you will see some nasty side effects of how MySQL > tries to flush the cache. > > As for you log you may want to move that in to the "[mysqld]" section of > the config. In this setup I beleive that mysqlhotcopy would be the only > mysql* command using that directive. > > table_cache should not be greater the amount of tables your databases > have . > > read_rnd_buffer_size = 524288 looks way to high your key_buffer_size is > only 32M Maybe you want to lower this to 64M of even leave it undefined > to see what the default does for you. > > > > PPS. Here's the my.cnf settings for this machine: > > > > [mysqld] > > safe-show-database > > skip-innodb > > max_connections = 500 > > key_buffer = 32M > > myisam_sort_buffer_size = 64M > > join_buffer_size = 1M > > read_buffer_size = 1M > > sort_buffer_size = 2M > > table_cache = 1800 > > thread_cache_size = 384 > > wait_timeout = 90 > > connect_timeout = 10 > > tmp_table_size = 64M > > max_heap_table_size = 64M > > max_allowed_packet = 16M > > max_connect_errors = 10 > > read_rnd_buffer_size = 524288 > > bulk_insert_buffer_size = 8M > > query_cache_limit = 3M > > query_cache_size = 80M > > query_cache_type = 1 > > query_prealloc_size = 163840 > > query_alloc_block_size = 32768 > > skip-name-resolve > > > > [mysqld_safe] > > open_files_limit = 8192 > > > > [mysqldump] > > quick > > max_allowed_packet = 16M > > > > [myisamchk] > > key_buffer = 16M > > sort_buffer = 16M > > read_buffer = 16M > > write_buffer = 16M > > > > [mysqlhotcopy] > > interactive-timeout > > > > log = /var/log/mysql/mysql_logfile > > > > > > > -- > Mark Saad > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"