From owner-freebsd-stable@FreeBSD.ORG Thu May 17 19:39:45 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 934DD16A403 for ; Thu, 17 May 2007 19:39:45 +0000 (UTC) (envelope-from ajwwong@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by mx1.freebsd.org (Postfix) with ESMTP id 4FE8113C459 for ; Thu, 17 May 2007 19:39:45 +0000 (UTC) (envelope-from ajwwong@gmail.com) Received: by an-out-0708.google.com with SMTP id d23so159630and for ; Thu, 17 May 2007 12:39:44 -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:x-mailer:x-mimeole:thread-index:message-id; b=jRpUWPChabtgcrWPTZhjDftT6z2aD2K0TtDzj+pTusJ/Xz5F4MnMGVQivYHH5m0DXfvi5ZiMkRbcVoF5AAoDvZwVJPQR7MeDhKKxu1WNQ05l1Dapu+G6cuLSdLMFgrCiq3AwShftVCGDBX4nnejpkSEp675cTdbXrYXxkcCqyIg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:mime-version:content-type:x-mailer:x-mimeole:thread-index:message-id; b=mBz2sSCqFCMcTz6ZBqSmMsFDzuusk1zAjveWrKzuXzqssFEISE5HeEOgJLX4krPiKnN6JxfNwM144eNijbd9r/Kz+mj3Z/T4MSxa0jIPHyttWzDJVML++O1C4sKnX4ZBTdTdd5oSUPmqPyt5+7hy6uXikIxuq1aicOKNMGxYqBo= Received: by 10.100.95.19 with SMTP id s19mr571332anb.1179429250428; Thu, 17 May 2007 12:14:10 -0700 (PDT) Received: from LettingGo ( [68.183.91.76]) by mx.google.com with ESMTP id d38sm3493160and.2007.05.17.12.14.08; Thu, 17 May 2007 12:14:09 -0700 (PDT) From: "Albert Wong" To: Date: Thu, 17 May 2007 12:14:13 -0700 MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AceYt45FDltDnBwXSIyyWZ3yoiQKDw== Message-ID: <464ca981.68894365.5671.6d22@mx.google.com> Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: 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: Thu, 17 May 2007 19:39:45 -0000 Greetings everyone... I am observing what appears to be a similar problem as well... I have a dedicated server with *very* light traffic. It looks like every day or so my server load slowly climbs from 0.20 to 14.00 and then stays there indefinitely.... locking down the system [until I do an "apachectl restart"] after which the server load drops back down. I'm not getting any weird Fatal Errors from PHP or any Warnings [though a lot of PHP Notices.]. The apache httpd_error.log shows the following error, usually, when the slow climb to 14.00 server load begins: httpd in free(): error: recursive call httpd in free(): error: recursive call [Usually it only shows about three or four of these repeated errors.] I am using FreeBSD 6.2 and MySQL 4.1. I am trying to use the libthr threading mechanism through the libmap.conf setting, as to earlier in this thread post, as a possible fix. [Though, I don't know if I have in fact been successful in switching to libthr or not... because I'm not sure if I need to recompile / reboot? I don't know if mysql was install from a port or not.] 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 and I also added ... WITH_LIBMAP= yes to my make.conf file. Is there something else I need to do [e.g., recompile? / reboot?] in order to activate libthr? The problem remains even with these adjustments. Blessings, Albert Wong www.ithou.org PS. The mysql_logfile is completely empty... I don't know if that is unusual or not. 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