From owner-freebsd-database@FreeBSD.ORG Tue Jul 19 06:21:36 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 538B716A41C for ; Tue, 19 Jul 2005 06:21:36 +0000 (GMT) (envelope-from mike@daboyz.org) Received: from jorm.daboyz.org (jorm.daboyz.org [209.67.213.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1C82A43D4C for ; Tue, 19 Jul 2005 06:21:36 +0000 (GMT) (envelope-from mike@daboyz.org) Received: by jorm.daboyz.org (Postfix, from userid 10001) id C925914A6B; Tue, 19 Jul 2005 01:33:09 -0500 (CDT) Date: Tue, 19 Jul 2005 01:33:09 -0500 From: Michael Barrett To: freebsd-database@freebsd.org Message-ID: <20050719063309.GA63017@daboyz.org> Mail-Followup-To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Subject: Big DB (100G+) w/ MySQL 4.1 and FreeBSD 4? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 19 Jul 2005 06:21:36 -0000 Does anyone here have any experience with dealing with large MySQL 4.1 databases (over 100 gigs) on FreeBSD 4.x? I'm running into performance issues with a similar setup, and I wanted to compare notes with anyone else who may have tried this. Our current setup is: Dell 2650 w/ 2CPU's (533 FSB) and 3G of RAM FreeBSD 4.11 running SMP MySQL 4.1.12 using LinuxThreads Our tables are almost completely innodb using seperate files per table. The size of our mysql datadir is around 199 Gigs. We're seeing all sorts of weird performance issues. The biggest 'issue' we're seeing is that some queries take over a minute to return, yet the system itself (CPU, disks, etc) see almost no activity while this is going on. We had the MySQL AB folks out to take a look, and even running their pre-built binary (w/ LinuxThreads) from their website we saw the same issues. They agreed that 'something was wrong', but couldn't give us any quick ideas on what exactly we could do about it. If you do have experience with a system around the size of ours with similar setup, I'd love to hear about your experiences. Also, seeing any loader.conf, sysctl.conf, my.cnf, and general tips about kernel configuration would be awesome. Thanks for any help you can provide. -- ________________________________________________________________________ Mike Barrett | "We have veggie bacon, why don't we have mike@daboyz.org | meat fruit?" www.daboyz.org | -- My ex-coworker, Ben ------------------------+----------------------------------------------- From owner-freebsd-database@FreeBSD.ORG Tue Jul 19 12:59:54 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 A3A7616A41F for ; Tue, 19 Jul 2005 12:59:54 +0000 (GMT) (envelope-from dmiller@sparks.net) Received: from search.sparks.net (search.sparks.net [207.5.180.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5679943D45 for ; Tue, 19 Jul 2005 12:59:54 +0000 (GMT) (envelope-from dmiller@sparks.net) Received: from [10.0.0.10] (dsl-66-243-211-31.pivot.net [66.243.211.31]) by search.sparks.net (Postfix) with ESMTP id 13F7CA90C; Tue, 19 Jul 2005 08:59:53 -0400 (EDT) Message-ID: <42DCF948.3020404@sparks.net> Date: Tue, 19 Jul 2005 08:59:52 -0400 From: David Miller User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.5) Gecko/20041217 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Barrett References: <20050719063309.GA63017@daboyz.org> In-Reply-To: <20050719063309.GA63017@daboyz.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: Big DB (100G+) w/ MySQL 4.1 and FreeBSD 4? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 19 Jul 2005 12:59:54 -0000 Michael Barrett wrote: > Does anyone here have any experience with dealing with large MySQL 4.1 databases (over 100 gigs) on FreeBSD 4.x? I'm running into performance issues with a similar setup, and I wanted to compare notes with anyone else who may have tried this. Our current setup is: > > Dell 2650 w/ 2CPU's (533 FSB) and 3G of RAM > FreeBSD 4.11 running SMP > MySQL 4.1.12 using LinuxThreads > > Our tables are almost completely innodb using seperate files per table. The size of our mysql datadir is around 199 Gigs. > > We're seeing all sorts of weird performance issues. The biggest 'issue' we're seeing is that some queries take over a minute to return, yet the system itself (CPU, disks, etc) see almost no activity while this is going on. We had the MySQL AB folks out to take a look, and even running their pre-built binary (w/ LinuxThreads) from their website we saw the same issues. They agreed that 'something was wrong', but couldn't give us any quick ideas on what exactly we could do about it. > > If you do have experience with a system around the size of ours with similar setup, I'd love to hear about your experiences. Also, seeing any loader.conf, sysctl.conf, my.cnf, and general tips about kernel configuration would be awesome. > > Thanks for any help you can provide. > > In testing of earlier versions of FreeBSD (4.8 or so) and MySQL (4.04) I found that running with SMP actually slowed the system down. Simple database tasks actually took longer to finish with SMP enabled than with a single CPU. That might be worth trying. If your system doesn't do that - and I'm told that 5.4 doesn't - it may be worth throwing ktrace on the running mysql process to see what it's doing. Hope this helps, --- David From owner-freebsd-database@FreeBSD.ORG Wed Jul 20 02:18:08 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 9F2AF16A41F for ; Wed, 20 Jul 2005 02:18:08 +0000 (GMT) (envelope-from jemaxwell@jaymax.com) Received: from mail24.sea5.speakeasy.net (mail24.sea5.speakeasy.net [69.17.117.26]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3481B43D46 for ; Wed, 20 Jul 2005 02:18:08 +0000 (GMT) (envelope-from jemaxwell@jaymax.com) Received: (qmail 8734 invoked from network); 20 Jul 2005 02:18:07 -0000 Received: from dsl093-045-209.sac1.dsl.speakeasy.net (HELO [192.168.2.21]) (jaymax@[66.93.45.209]) (envelope-sender ) by mail24.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 20 Jul 2005 02:18:07 -0000 Message-ID: <42DF05E0.6020304@jaymax.com> Date: Wed, 20 Jul 2005 19:18:08 -0700 From: "Joseph E. Maxwell" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-database@freebsd.org References: <20050107120059.40AD016A4DE@hub.freebsd.org> In-Reply-To: <20050107120059.40AD016A4DE@hub.freebsd.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: OS Update & Ports problem X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Jul 2005 02:18:08 -0000 Two Questions: [i] What is the best strategy for me to to update my O/S to the latest, I am currently running 4.xx, early xx's ? [ii] In the ports collection, when I attempt to run "make" I get a core dump machI # make Bus error (core dumped) machI # Suggestions welcomed Thanks -- Joe -- From owner-freebsd-database@FreeBSD.ORG Wed Jul 20 18:03:50 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 C9C7F16A41F for ; Wed, 20 Jul 2005 18:03:50 +0000 (GMT) (envelope-from fabmirha@ns.isi.ulatina.ac.cr) Received: from ns.isi.ulatina.ac.cr (ns.isi.ulatina.ac.cr [163.178.60.51]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7E5FC43D46 for ; Wed, 20 Jul 2005 18:03:49 +0000 (GMT) (envelope-from fabmirha@ns.isi.ulatina.ac.cr) Received: by ns.isi.ulatina.ac.cr (Postfix, from userid 5481) id 27F7D42D5B; Wed, 20 Jul 2005 08:27:49 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by ns.isi.ulatina.ac.cr (Postfix) with ESMTP id 243C52B447; Wed, 20 Jul 2005 08:27:49 -0600 (CST) Date: Wed, 20 Jul 2005 08:27:48 -0600 (CST) From: Fabio Miranda Hamburger To: "Joseph E. Maxwell" In-Reply-To: <42DF05E0.6020304@jaymax.com> Message-ID: References: <20050107120059.40AD016A4DE@hub.freebsd.org> <42DF05E0.6020304@jaymax.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Cc: freebsd-database@freebsd.org Subject: Re: OS Update & Ports problem X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Jul 2005 18:03:50 -0000 This is not a dabatase related questions, but: > Two Questions: > [i] What is the best strategy for me to to update my O/S to the latest, > I am currently running 4.xx, early xx's ? cvs to 4-stable > [ii] In the ports collection, when I attempt to run "make" I get a core dump > > machI # make > Bus error (core dumped) > machI # strace make ldd `which make` and more commands to see what's happening. fabio. From owner-freebsd-database@FreeBSD.ORG Wed Jul 20 19:58:03 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 12EC016A41F for ; Wed, 20 Jul 2005 19:58:03 +0000 (GMT) (envelope-from bennelson@hcc.mnscu.edu) Received: from hccgwy.mnscu.edu (hccgwy.mnscu.edu [134.29.200.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id BA8BF43D45 for ; Wed, 20 Jul 2005 19:58:02 +0000 (GMT) (envelope-from bennelson@hcc.mnscu.edu) Received: from HCC-DOMAIN-MTA by hccgwy.mnscu.edu with Novell_GroupWise; Wed, 20 Jul 2005 15:01:55 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.0.4 Date: Wed, 20 Jul 2005 15:01:36 -0500 From: "Ben Nelson" To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Subject: Oracle JDeveloper on FreeBSD X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Jul 2005 19:58:03 -0000 I don't know if the is the right list for this question, but here we go. Has anyone had any luck installing Oracle JDeveloper on FreeBSD? I am not even sure if it would work. I would like to use the php extension in JDeveloper to connect via JDBC to = a remote Oracle RDB database. Thanks, From owner-freebsd-database@FreeBSD.ORG Wed Jul 20 20:51:41 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 A23D116A41F for ; Wed, 20 Jul 2005 20:51:41 +0000 (GMT) (envelope-from cedric@virtual-globe.net) Received: from dd2030.kasserver.com (dd2030.kasserver.com [81.209.148.135]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3438B43D58 for ; Wed, 20 Jul 2005 20:51:40 +0000 (GMT) (envelope-from cedric@virtual-globe.net) Received: from ganymed.decemplex.loc (83-134-162-136.Liege.GoPlus.FastDSL.tiscali.be [83.134.162.136]) by dd2030.kasserver.com (Postfix) with ESMTP id 22A702F503 for ; Wed, 20 Jul 2005 22:51:39 +0200 (CEST) Date: Wed, 20 Jul 2005 22:51:30 +0200 From: =?ISO-8859-1?Q?C=E9dric?= Jonas To: freebsd-database@freebsd.org Message-ID: <20050720225130.069cb84e@ganymed.decemplex.loc> In-Reply-To: References: X-Mailer: Sylpheed-Claws 1.9.12 (GTK+ 2.6.8; i386-portbld-freebsd6.0) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Subject: Re: Oracle JDeveloper on FreeBSD X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Jul 2005 20:51:41 -0000 Hi, On Wed, 20 Jul 2005 15:01:36 -0500 "Ben Nelson" wrote: > Has anyone had any luck installing Oracle JDeveloper on FreeBSD? > I am not even sure if it would work. Oracle JDeveloper 10g runs here without problems. > I would like to use the php extension in JDeveloper to connect via JDBC t= o a remote Oracle RDB database. I have never tried this, but connect to an Oracle Database via JDBC runs al= so. I hope I could help. --=20 Best regards,=20 C=E9dric Jonas From owner-freebsd-database@FreeBSD.ORG Thu Jul 21 05:32:58 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 375E716A41F for ; Thu, 21 Jul 2005 05:32:58 +0000 (GMT) (envelope-from buttmanizer@yahoo.com) Received: from web50509.mail.yahoo.com (web50509.mail.yahoo.com [206.190.38.246]) by mx1.FreeBSD.org (Postfix) with SMTP id A4AF543D46 for ; Thu, 21 Jul 2005 05:32:57 +0000 (GMT) (envelope-from buttmanizer@yahoo.com) Received: (qmail 8009 invoked by uid 60001); 21 Jul 2005 05:32:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=mrUo7JfbH9tIxIZk6p6pHk0CSOMd+ue/i9TLuswQPvhUSWM8Uw75EDZwf8g4gQ9m9/1Y/0sFvGArRA+MEjjy55KFe00ghma8xS3tf/DAOw0Wf/pw4AK/ecID28JazvcGz64ysfgMacNkJClHsADAeeLrKj/HZQvcZtXVo4awzWg= ; Message-ID: <20050721053256.8007.qmail@web50509.mail.yahoo.com> Received: from [202.92.128.25] by web50509.mail.yahoo.com via HTTP; Thu, 21 Jul 2005 06:32:56 BST Date: Thu, 21 Jul 2005 06:32:56 +0100 (BST) From: buttmanizer To: freebsd-database@freebsd.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: Re: Oracle JDeveloper on FreeBSD X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 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, 21 Jul 2005 05:32:58 -0000 yeah i have succesfully installed and run jdeveloper on freebsd. here's my setup: %uname -a FreeBSD buttstation 5.4-RELEASE FreeBSD 5.4-RELEASE #6: Sun May 15 11:44:48 PHT 2005 root@buttstation:/usr/src/sys/i386/compile/BUTTSTATION i386 %java -version java version "1.4.2-p7" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2-p7-buttmanizer_08_jul_2005_09_48) Java HotSpot(TM) Client VM (build 1.4.2-p7-buttmanizer_08_jul_2005_09_48, mixed mode) --- Ben Nelson wrote: > I don't know if the is the right list for this > question, but here we go. > > Has anyone had any luck installing Oracle JDeveloper > on FreeBSD? > I am not even sure if it would work. > > I would like to use the php extension in JDeveloper > to connect via JDBC to a remote Oracle RDB database. > > > Thanks, > > > > > > > > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to > "freebsd-database-unsubscribe@freebsd.org" > Exclusively in a miraculous fashion, buttmanizer Send instant messages to your online friends http://uk.messenger.yahoo.com Exclusively in a miraculous fashion, buttmanizer Send instant messages to your online friends http://uk.messenger.yahoo.com