From owner-freebsd-stable@FreeBSD.ORG Wed Feb 6 09:31:08 2008 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3189916A41A for ; Wed, 6 Feb 2008 09:31:08 +0000 (UTC) (envelope-from primeroz.lists@googlemail.com) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.185]) by mx1.freebsd.org (Postfix) with ESMTP id 0618A13C45A for ; Wed, 6 Feb 2008 09:31:07 +0000 (UTC) (envelope-from primeroz.lists@googlemail.com) Received: by rv-out-0910.google.com with SMTP id g13so2086937rvb.43 for ; Wed, 06 Feb 2008 01:31:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=2pUIsVoUvMoa0wlfSmxlyYXKpNt4MfwMTD8GA/oTbgw=; b=TiSYlDAYkhROd9zalSLM94Qw3W71YwqkSqQXImcsyu0sueqiIv8ZgIR4Oqy8xiYWlqKGtNp314Pf19QXU9ncz8Bm4UjaxMur1niwXEZW3P+i6p1znccU0NAKaHraiCtGIPLz59AKbctgenDm9tPMIMnpv43dfCcnIkB0i+iGnUs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=KJvNcO8Iv8/5uYPKlA/JUSqxDNVB5wT+nr4Gccy/R8Pxj8+wxRL8gaqThVXSxtpwD/M1M2CxFGm2C8LUeOqFV6t+FInUNNtDl4/nvdvsSz+kas9FqqseJ9GbWv4BksqcbaOPyTjxJfOkiEojiBu2lFfiQ5/KRqgiiUiYWRL51ik= Received: by 10.141.141.3 with SMTP id t3mr392720rvn.213.1202290267590; Wed, 06 Feb 2008 01:31:07 -0800 (PST) Received: by 10.140.203.6 with HTTP; Wed, 6 Feb 2008 01:31:07 -0800 (PST) Message-ID: <55b8c6fe0802060131y6e0e27d8j4e7db10381c6bfab@mail.gmail.com> Date: Wed, 6 Feb 2008 09:31:07 +0000 From: "Primeroz lists" To: "Tom Samplonius" In-Reply-To: <28875927.5811202240277979.JavaMail.root@ly.sdf.com> MIME-Version: 1.0 References: <55b8c6fe0802040450r7ca3e739s931be2d38f499fc2@mail.gmail.com> <28875927.5811202240277979.JavaMail.root@ly.sdf.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-stable@freebsd.org Subject: Re: Crashing repeatedly: 6.2-RELEASE-p5 and MySQL 5.0.41 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: Wed, 06 Feb 2008 09:31:08 -0000 Yes i agree with everything. Definetly mysql need to be tuned for InnoDB and in general . As stated in the previous post my a collegue of mine i had to install a new kernel to have a consistent crash coredump. Anyway still in my mind is that even if not tuned mysql should not cause my kernel to panic, i could expect a mysql crash or very very poor performance ... but the kernel panic leave me confused. I will post on this thread my coredump as soon as the server crash again (and it will) ... surely i will tune mysql then and see if and how much this helps. thanks On Feb 5, 2008 7:37 PM, Tom Samplonius wrote: > > ----- "Primeroz lists" wrote: > > Hi all, > > > > we are experiencing repeated crash on a Dell PowerEdge 2950 (rev 1 or > > 2). > > > > FBSD release is 6.2-RELEASE-p5 , AMD64. 2xXeon QuadCore and 8G of Ram. > > > > MySQL Version is 5.0.41 with following configuration settings: > > > > set-variable = key_buffer=768M > > set-variable = table_cache=800 > > set-variable = sort_buffer=24M > > set-variable = myisam_sort_buffer_size=256M > > set-variable = record_buffer=16M > > set-variable = max_allowed_packet=10M > > set-variable = thread_stack=128K > > set-variable = join_buffer=512M > > set-variable = max_heap_table_size=256M > > set-variable = max_connections=300 > > set-variable = tmp_table_size=384M > > set-variable = query_cache_size=402653184 > > set-variable = query_cache_limit=134217728 > > set-variable = read_rnd_buffer_size=10M > > set-variable = ft_min_word_len=1 > > pid-file = /var/db/mysqld.pid > > tmpdir = /var/tmp > > ft_stopword_file = '' > > set-variable = thread_cache_size=80 > > set-variable = myisam_stats_method=nulls_equal > > Also, myslq is not really well tuned. > > The query cache is a kludge. It is helpful, if you have stupid > application that issues the same query over and over again, even though the > database has not changed. If you don't have this problem, it just adds > overhead. And quite a lot, if it is big. Generally, the query cache should > be 20 to 100M at most, if not disabled. If you have a smart web application > (anything using memcached), the query cache should just be turned off. It > will actually be faster. > > You should give us much storage as possible to the database engine, for > it cache actual data, not query results. It is weird that you are > apparently are heavily using Innodb, but you have just set various myiasam > values? > > Here is something useful: > > http://www.joyeur.com/2007/09/25/quick-wins-with-mysql > > > Tom > > >