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 From owner-freebsd-database@FreeBSD.ORG Thu Sep 18 05:46:20 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 D23B816A4B3; Thu, 18 Sep 2003 05:46:20 -0700 (PDT) Received: from mta8.adelphia.net (mta8.adelphia.net [68.168.78.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2A64343FBF; Thu, 18 Sep 2003 05:46:19 -0700 (PDT) (envelope-from wmoran@potentialtech.com) Received: from potentialtech.com ([24.53.179.151]) by mta8.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030918124620.BUCO14799.mta8.adelphia.net@potentialtech.com>; Thu, 18 Sep 2003 08:46:20 -0400 Message-ID: <3F69A91A.60100@potentialtech.com> Date: Thu, 18 Sep 2003 08:46:18 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Supote Leelasupphakorn References: <20030918110851.55151.qmail@web40611.mail.yahoo.com> In-Reply-To: <20030918110851.55151.qmail@web40611.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-database@freebsd.org cc: freebsd-questions@freebsd.org cc: FreeBSD-Chat@FreeBSD.org Subject: Re: 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 12:46:21 -0000 Supote Leelasupphakorn wrote: > 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? You're hitting up against, what I feel is one of the most common and most difficult to solve problems out there. The best solution is to fix the SQL statements. Unfortunately, it's quite possible that you won't be able to fix the application that's causing the problem, becuase it's closed-source and written by someone else. At that point, you're up against the frustrating chore of convincing the application designer to fix their lousy code, which is often impossible. In the end, it seems that most people end up buying faster, more expensive hardware to make up for lousy application design. It's a damn shame, but that's what seems to happen a lot. -- Bill Moran Potential Technologies http://www.potentialtech.com From owner-freebsd-database@FreeBSD.ORG Thu Sep 18 10:06:42 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 7E0DA16A4B3; Thu, 18 Sep 2003 10:06:42 -0700 (PDT) Received: from perrin.nxad.com (internal.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5FEF643F3F; Thu, 18 Sep 2003 10:06:41 -0700 (PDT) (envelope-from sean@nxad.com) Received: by perrin.nxad.com (Postfix, from userid 1001) id BC5F22105E; Thu, 18 Sep 2003 10:06:40 -0700 (PDT) Date: Thu, 18 Sep 2003 10:06:40 -0700 From: Sean Chittenden To: Supote Leelasupphakorn Message-ID: <20030918170640.GC34604@perrin.nxad.com> References: <20030918110851.55151.qmail@web40611.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030918110851.55151.qmail@web40611.mail.yahoo.com> X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i cc: freebsd-database@freebsd.org cc: freebsd-questions@freebsd.org cc: FreeBSD-Chat@FreeBSD.org Subject: Re: 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 17:06:42 -0000 > 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? In PostgreSQL, I flip on the following settings and then periodically scan PostgreSQL's the log file (/var/log/pgsql): log_duration = true log_pid = true log_statement = true log_timestamp = true It's tedious, but with grep on your side, it's not an impossible task or even a super hard one... just a bit tedious if you don't keep up with your developers. I've found doing this on the devel machines produces better bang for the buck than on the production DB's (though I still do it there occasionally). Once a query is found, I typically launch a big 'ole fashion egrep -r with a reasonably unique part of the query and am normally pretty successful in finding the culprit. Sometimes you'll have to use sockstat to find what machine and what PID you're dealing with, but that's something I have to do rarely. -sc PS Don't spam so many lists in the future, just -databases or just -questions would've been sufficient (the more topical the list the better). -- Sean Chittenden From owner-freebsd-database@FreeBSD.ORG Thu Sep 18 17:57:13 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 4D40816A4B3 for ; Thu, 18 Sep 2003 17:57:13 -0700 (PDT) Received: from web86005.mail.ukl.yahoo.com (web86005.mail.ukl.yahoo.com [217.12.12.36]) by mx1.FreeBSD.org (Postfix) with SMTP id 366B043FAF for ; Thu, 18 Sep 2003 17:57:12 -0700 (PDT) (envelope-from keshav_tadimeti@yahoo.co.uk) Message-ID: <20030919005711.92783.qmail@web86005.mail.ukl.yahoo.com> Received: from [147.60.1.194] by web86005.mail.ukl.yahoo.com via HTTP; Fri, 19 Sep 2003 01:57:11 BST Date: Fri, 19 Sep 2003 01:57:11 +0100 (BST) From: =?iso-8859-1?q?Tadimeti=20Keshav?= To: freebsd-database@freebsd.org In-Reply-To: <20030918190046.393DB16A4EB@hub.freebsd.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: Oracle and Sybase on FreeBSD... 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: Fri, 19 Sep 2003 00:57:13 -0000 guys, Sybase offers a free version of an old 11.0.3.3 database that runs natively on FreeBSD. I came across this by accident. linux.sybase.com/ase Why doesn't the hand book reflect this instead of focussing on an old version of Oracle that was developed for Linux? Does any one plan to write a HOW-TO to install oracle 8.1.7 (which was the last 8i) on FreeBSD? There exists a page on the internet in Russian, but so far no one has translated it. (No I don't know russian). Thanks... ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk From owner-freebsd-database@FreeBSD.ORG Thu Sep 18 19:25:35 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 687A816A4B3 for ; Thu, 18 Sep 2003 19:25:35 -0700 (PDT) Received: from post.upb.ur.ru (a240.upb.ur.ru [195.58.11.240]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2BC2A43FBD for ; Thu, 18 Sep 2003 19:25:33 -0700 (PDT) (envelope-from avm@upb.ru) Received: by post.upb.ur.ru with Internet Mail Service (5.5.2653.19) id ; Fri, 19 Sep 2003 08:25:34 +0600 Message-ID: From: =?koi8-r?Q?=ED=CF=D2=CF=DA=CF=D7_=E1=CC=C5=CB=D3=C5=CA_=F7=CC=C1=C4?= =?koi8-r?Q?=C9=CD=C9=D2=CF=D7=C9=DE?= To: "'freebsd-database@freebsd.org'" Date: Fri, 19 Sep 2003 08:25:33 +0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="koi8-r" X-Mailman-Approved-At: Thu, 18 Sep 2003 19:37:37 -0700 Subject: RE: Oracle and Sybase on FreeBSD... 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: Fri, 19 Sep 2003 02:25:35 -0000 Hi, > Does any one plan to write a HOW-TO to install oracle > 8.1.7 (which was the last 8i) on FreeBSD? There exists > a page on the internet in Russian, but so far no one > has translated it. (No I don't know russian). Please, tell me where is the page about oracle installation in russian? http://www.geocities.com/altguru/ - isn't it? Or any one else? Thanks From owner-freebsd-database@FreeBSD.ORG Thu Sep 18 23:40:15 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 469BB16A4B3 for ; Thu, 18 Sep 2003 23:40:15 -0700 (PDT) Received: from complx.LF.net (complx.LF.net [212.9.190.63]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4E79443FDD for ; Thu, 18 Sep 2003 23:40:14 -0700 (PDT) (envelope-from lists@complx.LF.net) Received: from lists by complx.LF.net with local (Exim 4.14) id 1A0Ew9-00075J-Bl; Fri, 19 Sep 2003 08:40:13 +0200 Date: Fri, 19 Sep 2003 08:40:13 +0200 From: Kurt Jaeger To: Tadimeti Keshav Message-ID: <20030919064013.GL5474@complx.LF.net> References: <20030918190046.393DB16A4EB@hub.freebsd.org> <20030919005711.92783.qmail@web86005.mail.ukl.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030919005711.92783.qmail@web86005.mail.ukl.yahoo.com> cc: freebsd-database@freebsd.org Subject: Re: Oracle and Sybase on FreeBSD... X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: pi@LF.net List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Sep 2003 06:40:15 -0000 Hi! > Does any one plan to write a HOW-TO to install oracle > 8.1.7 (which was the last 8i) on FreeBSD? There exists > a page on the internet in Russian, but so far no one > has translated it. (No I don't know russian). http://www.shadowcom.net/freebsd-oracle9i/ is about 9i and looks very promising. -- MfG/Best regards, Kurt Jaeger 17 years to go ! LF.net GmbH fon +49 711 90074-23 pi@LF.net Ruppmannstr. 27 fax +49 711 90074-33 D-70565 Stuttgart mob +49 171 3101372 From owner-freebsd-database@FreeBSD.ORG Fri Sep 19 14:47:11 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 42F5416A4BF for ; Fri, 19 Sep 2003 14:47:11 -0700 (PDT) Received: from siralan.org (12-223-227-231.client.insightbb.com [12.223.227.231]) by mx1.FreeBSD.org (Postfix) with ESMTP id 60D5C43FCB for ; Fri, 19 Sep 2003 14:47:10 -0700 (PDT) (envelope-from mikes@siralan.org) Received: from siralan.org (localhost [127.0.0.1]) by siralan.org (8.12.9/8.12.9) with ESMTP id h8JLl94s006232 for ; Fri, 19 Sep 2003 16:47:09 -0500 (EST) (envelope-from mikes@siralan.org) Received: (from mikes@localhost) by siralan.org (8.12.9/8.12.9/Submit) id h8JLl8HK006231 for freebsd-database@freebsd.org; Fri, 19 Sep 2003 16:47:08 -0500 (EST) (envelope-from mikes) From: "Michael L. Squires" Message-Id: <200309192147.h8JLl8HK006231@siralan.org> To: freebsd-database@freebsd.org (FreeBSD Database) Date: Fri, 19 Sep 2003 16:47:08 -0500 (EST) In-Reply-To: <20030919064013.GL5474@complx.LF.net> from "Kurt Jaeger" at Sep 19, 2003 08:40:13 AM X-Mailer: ELM [version 2.5 PL6] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Subject: Re: Oracle and Sybase on FreeBSD... 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: Fri, 19 Sep 2003 21:47:11 -0000 > > Does any one plan to write a HOW-TO to install oracle > > 8.1.7 (which was the last 8i) on FreeBSD? There exists > > a page on the internet in Russian, but so far no one > > has translated it. (No I don't know russian). > > http://www.shadowcom.net/freebsd-oracle9i/ > > is about 9i and looks very promising. shadowcom.net is unavailable to me, but a nearly complete copy of the web page is cached at www.google.com. I searched for "FreeBSD Oracle 9i shadowcom" and it was near the top. I haven't tried it (yet). Mike Squires From owner-freebsd-database@FreeBSD.ORG Sat Sep 20 00:05:25 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 9C9D516A4B3 for ; Sat, 20 Sep 2003 00:05:25 -0700 (PDT) Received: from complx.LF.net (complx.LF.net [212.9.190.63]) by mx1.FreeBSD.org (Postfix) with ESMTP id 034F143FE5 for ; Sat, 20 Sep 2003 00:05:25 -0700 (PDT) (envelope-from lists@complx.LF.net) Received: from lists by complx.LF.net with local (Exim 4.14) id 1A0bo3-000Caa-Ar; Sat, 20 Sep 2003 09:05:23 +0200 Date: Sat, 20 Sep 2003 09:05:23 +0200 From: Kurt Jaeger To: "Michael L. Squires" Message-ID: <20030920070523.GN5474@complx.LF.net> References: <20030919064013.GL5474@complx.LF.net> <200309192147.h8JLl8HK006231@siralan.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200309192147.h8JLl8HK006231@siralan.org> cc: FreeBSD Database Subject: Re: Oracle and Sybase on FreeBSD... 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: Sat, 20 Sep 2003 07:05:25 -0000 Hi! > > http://www.shadowcom.net/freebsd-oracle9i/ > > is about 9i and looks very promising. > shadowcom.net is unavailable to me, but a nearly complete copy of the web > page is cached at www.google.com. I searched for "FreeBSD Oracle 9i shadowcom" > and it was near the top. > > I haven't tried it (yet). shadowcom.net is back online (for now?) -- MfG/Best regards, Kurt Jaeger 17 years to go ! LF.net GmbH fon +49 711 90074-23 pi@LF.net Ruppmannstr. 27 fax +49 711 90074-33 D-70565 Stuttgart mob +49 171 3101372 From owner-freebsd-database@FreeBSD.ORG Sat Sep 20 00:08:51 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 EC98E16A4BF for ; Sat, 20 Sep 2003 00:08:51 -0700 (PDT) Received: from mx3.absolight.com (mx3.absolight.net [212.43.217.9]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7E0A543FF2 for ; Sat, 20 Sep 2003 00:08:49 -0700 (PDT) (envelope-from mat@FreeBSD.org) Received: by mx3.absolight.com (Postfix, from userid 1007) id 590872A32; Sat, 20 Sep 2003 09:08:48 +0200 (CEST) X-Original-To: freebsd-database@freebsd.org Received: from cmantatzi.in.t-online.fr (cmantatzi.in.t-online.fr [213.44.126.228]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx3.absolight.com (Postfix) with ESMTP id DF93B2A2A; Sat, 20 Sep 2003 09:08:47 +0200 (CEST) Date: Sat, 20 Sep 2003 09:08:40 +0200 From: Mathieu Arnold To: FreeBSD Database Message-ID: <4378941.1064048920@cmantatzi.in.t-online.fr> In-Reply-To: <20030920070523.GN5474@complx.LF.net> References: <20030919064013.GL5474@complx.LF.net> <200309192147.h8JLl8HK006231@siralan.org> <20030920070523.GN5474@complx.LF.net> X-Mailer: Mulberry/3.1.0b7 (Win32) MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="==========D97958354587AEE29C2C==========" cc: doc@freebsd.org Subject: Re: Oracle and Sybase on FreeBSD... 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: Sat, 20 Sep 2003 07:08:52 -0000 --==========D97958354587AEE29C2C========== Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline +-le 20/09/03 09:05 +0200, Kurt Jaeger =E9crivait : | Hi! |=20 |> > http://www.shadowcom.net/freebsd-oracle9i/ |=20 |> > is about 9i and looks very promising. |=20 |> shadowcom.net is unavailable to me, but a nearly complete copy of the web |> page is cached at www.google.com. I searched for "FreeBSD Oracle 9i |> shadowcom" and it was near the top. |>=20 |> I haven't tried it (yet). |=20 | shadowcom.net is back online (for now?) Maybe this could get it's place in the handbook ? --=20 Mathieu Arnold --==========D97958354587AEE29C2C========== Content-Type: application/pgp-signature Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (MingW32) iD8DBQE/a/z9qYYpzGz/vmcRAhm6AJ9CpAiD0pJ0UKJ6f6xVPgM0HMVRlwCglNM1 XDYE+CTZhF1AQjx+QDZEJjY= =AYhn -----END PGP SIGNATURE----- --==========D97958354587AEE29C2C==========--