FreeBSD 8.3 + MySQL 5.0.95

[doug at safeport.com]

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 at lists.mysql.com - when I was an utter newbie they were quite helpful 
and tolerant.