From owner-freebsd-questions@FreeBSD.ORG Wed Jun 13 19:24:24 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (unknown [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id DBA051065678 for ; Wed, 13 Jun 2012 19:24:24 +0000 (UTC) (envelope-from simon@optinet.com) Received: from cobra.acceleratedweb.net (cobra-gw.acceleratedweb.net [207.99.79.37]) by mx1.freebsd.org (Postfix) with SMTP id 6C7C38FC0A for ; Wed, 13 Jun 2012 19:24:24 +0000 (UTC) Received: (qmail 19706 invoked by uid 110); 13 Jun 2012 19:24:23 -0000 Received: from ool-4571afe7.dyn.optonline.net (HELO desktop1) (simon@optinet.com@69.113.175.231) by cobra.acceleratedweb.net with SMTP; 13 Jun 2012 19:24:23 -0000 From: "Simon" To: "Chuck Swiger" Date: Wed, 13 Jun 2012 15:24:28 -0400 Priority: Normal X-Mailer: PMMail 2000 Professional (2.20.2717) For Windows 2000 (5.1.2600;3) In-Reply-To: <6F47A2B6-C9FE-47AC-848F-FF3BC5D06373@mac.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <20120613192424.DBA051065678@hub.freebsd.org> Cc: "freebsd-questions@freebsd.org" Subject: Re: FreeBSD 8.3 + MySQL 5.0.95 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 Jun 2012 19:24:25 -0000 >> I wish I could get some input from someone running MySQL server with 300+ >> queries a second and what MySQL version/build they are running. >By all means-- while I'm quite familiar with busy databases, folks aren't running >MySQL for that kind of TPS load. Why not? it is designed precisely for this. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ -Simon