From owner-freebsd-questions@FreeBSD.ORG  Fri Apr 24 13:15:10 2015
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTPS id 9F76ADDD
 for <freebsd-questions@freebsd.org>; Fri, 24 Apr 2015 13:15:10 +0000 (UTC)
Received: from mxout01.bytecamp.net (mxout01.bytecamp.net [212.204.60.217])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client did not present a certificate)
 by mx1.freebsd.org (Postfix) with ESMTPS id 5C77718B1
 for <freebsd-questions@freebsd.org>; Fri, 24 Apr 2015 13:15:09 +0000 (UTC)
Received: by mxout01.bytecamp.net (Postfix, from userid 1001)
 id 1D61930FDA9; Fri, 24 Apr 2015 15:05:11 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=bytecamp.net;
 h=message-id:date:from:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
 s=20140709; bh=cV0tOR95mivBuBJuSXZUDTiklEw=;
 b=hgc0Dc4uzSlxevEjQNxcoUHOHS6Jd1Jv/M/9ZQDb3h3jc1661+RsRE2qQna6hldEYVmq841Iew9op8HGjmrXZlNGI08PWNnsBemuUxIWyNJeW+Ha7MWGY65+oPxtAEQC58uHIGfmU+7u6mWVjoH3dZzf4X5jndLJFjHmUBrMI9A=
Received: from mail.bytecamp.net (mailstore.bytecamp.net [212.204.60.20])
 by mxout01.bytecamp.net (Postfix) with ESMTP id BEF2430FD9C
 for <freebsd-questions@freebsd.org>; Fri, 24 Apr 2015 15:05:10 +0200 (CEST)
Received: (qmail 7420 invoked by uid 89); 24 Apr 2015 15:05:10 +0200
Received: from stella.bytecamp.net (HELO ?212.204.60.37?)
 (rs%bytecamp.net@212.204.60.37)
 by mail.bytecamp.net with AES128-SHA encrypted SMTP; 24 Apr 2015 15:05:10 +0200
Message-ID: <553A3F86.3030904@bytecamp.net>
Date: Fri, 24 Apr 2015 15:05:10 +0200
From: Robert Schulze <rs@bytecamp.net>
Organization: bytecamp GmbH
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.6.0
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
Subject: Re: mysql keeping running but stops serving
References: <20150423222819.GA17139@skytracker.ca>
In-Reply-To: <20150423222819.GA17139@skytracker.ca>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.20
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 24 Apr 2015 13:15:10 -0000

Hi,

Am 24.04.2015 um 00:28 schrieb David Banning:
> After years of great service mysql stops working every 24 hours or so.
> Consulting the error log 3s1.com.err (my domain is 3s1.com) 
> 
> The log shows the server starting,  then without logging anything, it stops
> working after maybe 18 hours - it keeps running, but stops serving. 
> 
> The shutdown is my command, but you can see mysql does not want to shutdown.
> The "Forcing close of thead.." continues indefinitely.
> 
> Any pointers toward resolution would be helpful. Can I get more elaborate 
> logging?

whats the output of

# mysqladmin processlist

when it stops serving requests?

regards,
Robert Schulze