From owner-freebsd-database@FreeBSD.ORG Thu Sep 18 04:08:53 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 36B8116A4B3 for ; Thu, 18 Sep 2003 04:08:53 -0700 (PDT) Received: from web40611.mail.yahoo.com (web40611.mail.yahoo.com [66.218.78.148]) by mx1.FreeBSD.org (Postfix) with SMTP id B42A843FB1 for ; Thu, 18 Sep 2003 04:08:51 -0700 (PDT) (envelope-from pjn0211@yahoo.com) Message-ID: <20030918110851.55151.qmail@web40611.mail.yahoo.com> Received: from [202.183.248.166] by web40611.mail.yahoo.com via HTTP; Thu, 18 Sep 2003 12:08:51 BST Date: Thu, 18 Sep 2003 12:08:51 +0100 (BST) From: =?iso-8859-1?q?Supote=20Leelasupphakorn?= To: freebsd-questions@freebsd.org, FreeBSD-Chat@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cc: freebsd-database@freebsd.org Subject: How DBA solved overload problem ? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 18 Sep 2003 11:08:53 -0000 To all, As a newly DBA, I really don't know how I deal with this problem. My problem is not so long ago, my database server seem to overloaded. It take me a time to find the cause of problem. I realize that some program don't queried wiht inappropriated SQL statement. I mean they're not efficient one. AS DBA how do you solved this problem? Thanks in advance, ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk