From owner-freebsd-questions Sat Jan 8 1:45: 0 2000 Delivered-To: freebsd-questions@freebsd.org Received: from mail.enteract.com (mail.enteract.com [207.229.143.33]) by hub.freebsd.org (Postfix) with ESMTP id 45FE214ECA for ; Sat, 8 Jan 2000 01:44:58 -0800 (PST) (envelope-from jim@nasby.net) Received: from nasby.net (2.nasby.dsl.enteract.com [216.80.51.18]) by mail.enteract.com (8.9.3/8.9.3) with ESMTP id DAA78847; Sat, 8 Jan 2000 03:44:56 -0600 (CST) (envelope-from jim@nasby.net) Message-ID: <38770718.254E5F7D@nasby.net> Date: Sat, 08 Jan 2000 03:44:56 -0600 From: "Jim C. Nasby" Organization: distributed.net X-Mailer: Mozilla 4.7 [en] (WinNT; U) X-Accept-Language: en-US,en MIME-Version: 1.0 To: Sean Heber Cc: freebsd-questions@freebsd.org Subject: Re: FreeBSD and MySQL don't seem to like each other References: <000b01bf59ba$4dd11380$0a04cfd1@mwci.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Sean Heber wrote: > Why is mySQL misbehaving so badly? Will I be forced to change to Linux in > order to get around this? I sure hope not as I've gotten to like > FreeBSD--and I imagine there are others doing something like this. What's > the secret? I've never played with mysql, but I do work in Sybase, and I can tell you that there is a ton of settings that you can adjust to optimize the performance of the server. I'm assuming that the two servers are running exact duplicates of the database. Does mysql require that you occasionally rebuilt statistics on the indexes? Will mysql let you view the plan it's using for a query? If so, have you verified that the query plan makes sense? Are the two boxes running the same version of mysql? If you're hammering the box with the same set of queries, or hitting the same tables, do you have enough locks configured? Lock contention can be a very ugly thing when it gets out of control. Hope this helps a bit... dB! -- Jim C. Nasby (aka Decibel!) /^\ jim@nasby.net /___\ Freelance lighting designer and database developer / | \ Member: Triangle Fraternity, Sports Car Club of America /___|___\ Give your computer some brain candy! www.distributed.net Team #1828 Get paid to surf!! http://www.enteract.com/~nasby/alladvantage.html To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message