From owner-freebsd-questions@FreeBSD.ORG Wed Jun 13 20:17:57 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 49BA7106566C for ; Wed, 13 Jun 2012 20:17:57 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from nk11p00mm-asmtp004.mac.com (nk11p00mm-asmtp004.mac.com [17.158.161.3]) by mx1.freebsd.org (Postfix) with ESMTP id 2C0678FC18 for ; Wed, 13 Jun 2012 20:17:57 +0000 (UTC) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from cswiger1.apple.com (unknown [17.209.4.71]) by nk11p00mm-asmtp004.mac.com (Oracle Communications Messaging Server 7u4-23.01(7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTPSA id <0M5K008CSODO4Y50@nk11p00mm-asmtp004.mac.com> for freebsd-questions@freebsd.org; Wed, 13 Jun 2012 20:17:50 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.7.7855,1.0.260,0.0.0000 definitions=2012-06-13_06:2012-06-13, 2012-06-13, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=6.0.2-1012030000 definitions=main-1206130209 From: Chuck Swiger In-reply-to: <0M5K00F1HLWOQI90@st11b01mm-smtpin207.mac.com> Date: Wed, 13 Jun 2012 13:17:47 -0700 Message-id: References: <0M5K00F1HLWOQI90@st11b01mm-smtpin207.mac.com> To: Simon X-Mailer: Apple Mail (2.1084) 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 20:17:57 -0000 On Jun 13, 2012, at 12:24 PM, 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. That depends on workload. Table-level or page-level locking is fine for read-only or read-mostly; it wasn't until InnoDB storage that MySQL had row-level locking, which is kinda important when you *aren't* read-mostly. > Like I said, whenever I used MySQL > project community server built binaries, I never had it crash. But the process from these "community server built binaries" went away, right? > 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 The program termination ought to log something, at least if you enable logging or have a monitor in place which can see mysqld's error status; even mysqld_safe ought to take --log-error flag.... > 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 :\ That's likely to be a valid point; freebsd-ports would be appropriate for discussing the build problems with mysql port. freebsd-isp has a different population oriented towards hosting provider issues etc that you've mentioned. However, I can assure you that some folks here on freebsd-questions do deal with more than 10TPS. :-) Regards, -- -Chuck