Date: Wed, 13 Jun 2012 15:24:28 -0400 From: "Simon" <simon@optinet.com> To: "Chuck Swiger" <cswiger@mac.com> Cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: FreeBSD 8.3 + MySQL 5.0.95 Message-ID: <20120613192424.DBA051065678@hub.freebsd.org> In-Reply-To: <6F47A2B6-C9FE-47AC-848F-FF3BC5D06373@mac.com>
next in thread | previous in thread | raw e-mail | index | archive | help
>> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20120613192424.DBA051065678>