From owner-freebsd-questions@FreeBSD.ORG Wed Jun 13 19:32:10 2012 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D2B53106566B for ; Wed, 13 Jun 2012 19:32:10 +0000 (UTC) (envelope-from doug@safeport.com) Received: from fledge.watson.org (fledge.watson.org [65.122.17.41]) by mx1.freebsd.org (Postfix) with ESMTP id 8CDA48FC18 for ; Wed, 13 Jun 2012 19:32:10 +0000 (UTC) Received: from fledge.watson.org (localhost.watson.org [127.0.0.1]) by fledge.watson.org (8.14.4/8.14.4) with ESMTP id q5DJW9ah077552; Wed, 13 Jun 2012 15:32:09 -0400 (EDT) (envelope-from doug@safeport.com) Received: from localhost (doug@localhost) by fledge.watson.org (8.14.4/8.14.4/Submit) with ESMTP id q5DJW9B3077548; Wed, 13 Jun 2012 15:32:09 -0400 (EDT) (envelope-from doug@safeport.com) X-Authentication-Warning: fledge.watson.org: doug owned process doing -bs Date: Wed, 13 Jun 2012 15:32:09 -0400 (EDT) From: doug@safeport.com X-X-Sender: doug@fledge.watson.org To: Simon In-Reply-To: <20120613192424.DBA051065678@hub.freebsd.org> Message-ID: References: <20120613192424.DBA051065678@hub.freebsd.org> User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.2.3 (fledge.watson.org [127.0.0.1]); Wed, 13 Jun 2012 15:32:10 -0400 (EDT) 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 Reply-To: doug@fledge.watson.org List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 Jun 2012 19:32:10 -0000 On Wed, 13 Jun 2012, Simon wrote: >>> 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 :\ try mysql@lists.mysql.com - when I was an utter newbie they were quite helpful and tolerant.