From owner-freebsd-stable@FreeBSD.ORG Thu May 17 21:30:20 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 F266A16A401 for ; Thu, 17 May 2007 21:30:20 +0000 (UTC) (envelope-from msaad@datapipe.com) Received: from exchfe01.datapipe-corp.net (exchfe01.datapipe-corp.net [64.106.130.69]) by mx1.freebsd.org (Postfix) with ESMTP id BF6FF13C459 for ; Thu, 17 May 2007 21:30:20 +0000 (UTC) (envelope-from msaad@datapipe.com) Received: from [10.5.0.9] (192.168.81.31) by exchfe01.datapipe-corp.net (64.106.130.69) with Microsoft SMTP Server (TLS) id 8.0.700.0; Thu, 17 May 2007 17:20:12 -0400 Message-ID: <464CC70B.4090508@datapipe.com> Date: Thu, 17 May 2007 17:20:11 -0400 From: Mark Saad User-Agent: Thunderbird 1.5.0.10 (X11/20070413) MIME-Version: 1.0 To: Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: mysql frequently crash on 6.2 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: msaad@datapipe.com List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 May 2007 21:30:21 -0000 Hello In general This is what I use for my libmap.conf , it works fine for me any you may want to give it a try. [mysqld] libpthread.so libthr.so libpthread.so.2 libthr.so.2 Note nothing in MySQL 4.1 compiled on FreeBSD 6.2 should use libc_r.so . The other thing in your libmap that looks odd is the line "libthr.so.2 libthr.so.2" not sure what that will do. > > In any event, my libmap.conf settings are now [located in /etc/libmap.conf]: > > > [mysqld] > libc_r.so libthr.so > libc_r.so.6 libthr.so.2 > libthr.so.2 libthr.so.2 > libpthread.so libthr.so > libpthread.so.2 libthr.so.2 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