From owner-freebsd-database@FreeBSD.ORG Sun May 29 12:57: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 4F64016A41F for ; Sun, 29 May 2005 12:57: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 D6CFB43D48 for ; Sun, 29 May 2005 12:57:40 +0000 (GMT) (envelope-from cedric@virtual-globe.net) Received: from ganymed.decemplex.loc (83-134-164-116.Liege.GoPlus.FastDSL.tiscali.be [83.134.164.116]) by dd2030.kasserver.com (Postfix) with ESMTP id BAA23DEE80 for ; Sun, 29 May 2005 14:57:38 +0200 (CEST) Date: Sun, 29 May 2005 14:57:30 +0200 From: =?ISO-8859-1?Q?C=E9dric?= Jonas To: freebsd-database@freebsd.org Message-ID: <20050529145730.7a2cd046@ganymed.decemplex.loc> In-Reply-To: <4298DBC5.7030806@pobox.sk> References: <4298DBC5.7030806@pobox.sk> X-Mailer: Sylpheed-Claws 1.0.4 (GTK+ 1.2.10; i386-portbld-freebsd6.0) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Subject: Re: Install Oracle 10g or 9i failed with FreeBSD 5.4-RELEASE 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: Sun, 29 May 2005 12:57:41 -0000 On Sat, 28 May 2005 22:59:49 +0200 martinko wrote: > i've just tried the same -- installing oracle 10.1.0.3 on freebsd 5.4-R=20 > -- without success. > i followed daemonnews, the handbook, oracle guides for linux and some=20 > others, but: > first, runInstaller failed due to unsupported OS -- this wasn't=20 > mentioned anywhere -- i tried to patch oraparam.ini but i failed :( > second, i just tried to run 'runInstaller --help' and it crashed when=20 > initialising (see below) with java process using 100% cpu. :-( >=20 > is there nobody who have successfully installed oracle 10g on freebsd=20 > 5.[3|4] ? > or is just noone willing to share their how-to on this subject? Hi, The Oracle 10g installation fails because there are some Linux system calls= which aren't implemented in the actual Linux emulation. However, there's h= ard work in CURRENT to update the Linux emulation...=20 Oracle 9i will run (if you don't need iSQL*Plus), but if you need absolutel= y Oracle 10g now, I think the best solution is to install it on a Debian bo= x, and to keep a look on the evolution of the Linux emulation... --=20 Best regards,=20 C=E9dric Jonas From owner-freebsd-database@FreeBSD.ORG Tue May 31 11:54:07 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 8EC2B16A41C for ; Tue, 31 May 2005 11:54:07 +0000 (GMT) (envelope-from michael@roq.com) Received: from p4.roq.com (ns1.ecoms.com [207.44.130.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5105743D53 for ; Tue, 31 May 2005 11:54:05 +0000 (GMT) (envelope-from michael@roq.com) Received: from p4.roq.com (localhost.roq.com [127.0.0.1]) by p4.roq.com (Postfix) with ESMTP id EA3E54D26F for ; Tue, 31 May 2005 11:54:37 +0000 (GMT) Received: from [192.168.46.52] (ppp166-27.static.internode.on.net [150.101.166.27]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by p4.roq.com (Postfix) with ESMTP id C5C654D1B7 for ; Tue, 31 May 2005 11:54:36 +0000 (GMT) Message-ID: <429C3C00.4070208@roq.com> Date: Tue, 31 May 2005 20:27:12 +1000 From: Michael Vince User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.7.8) Gecko/20050524 X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-database@freebsd.org References: <200505261845.58035.pierre-gilles@netaktiv.com> In-Reply-To: <200505261845.58035.pierre-gilles@netaktiv.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP Subject: Re: Mysql performance 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, 31 May 2005 11:54:07 -0000 I have been doing some benchmark testing on a Dell 1850 Dual P4 server with FreeBSD 5.4 Release for MySQL I didn't write anything down just kind of did these tests while watching TV on this remote server from my laptop over ssh, but I think I remember everything quite well. There might be something useful to other people in my testing. I was testing using supersmack http://vegan.net/tony/supersmack/ I have only been about to give about 5% faster performance from complier based optimization. About 5% extra performance on top of that by my version choice of MySQL 100% performance increase in my choice of my.cnf configuration file. I don't think I checked but something remotely close to 100% performance increase by compiling SMP into my kernel :) I found no noticeable performance increase with Linux Threads compiled into MySQL By adding these to the /etc/make.conf file and recompiling the kernel I believe it helped a tiny bit, but maybe it makes things less stable that goes for MySQL compiler optimizations as well. CPUTYPE=pentium4 CFLAGS= -O2 -pipe Installing MySQL with this portupgrade command gave maybe 5% extra performance with the compiler optimization choices from 'BUILD_OPTIMIZED=yes' which uses -O3 , build without 'BUILD_OPTIMIZED=yes' to use the options from make.conf which should be safer. Building as static is suppose to improve performance according to the MySQL docs. portupgrade -RN -m 'BUILD_STATIC=yes BUILD_OPTIMIZED=yes' /usr/ports/databases/mysql41-server And I found that the mysql40-server port is about 5% faster as well over 4.1 , I have no idea why. portupgrade -RN -m 'BUILD_STATIC=yes BUILD_OPTIMIZED=yes' /usr/ports/databases/mysql40-server These are more obvious increases in default performance. I got almost exactly 100% performance increase ( doubled the amount of querys a second according to super-smack) using the my-large.cnf configuration for MySQL. This is because MySQL in default configuration is well suited to a small database / memory size or people trying it out on their 486's. cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/my.cnf Kernel compiled with SMP cd /usr/src ; make buildkernel KERNCONF=SMP Regards, Mike Mialon Pierre-Gilles wrote: > Hi, > >I run mysql on a dual-opteron with 2Go of Ram. >I don't use the linuxthread. >I use the mysql-server-4.1.10a on FreeBSD 5.3 AMD64 >I don't understand why I have only one > /usr/local/libexec/mysqld running in ps aux. >And I'm looking for a good tutorial to speed up the mysql-server on a FreeBSD >box. > >The output is the content of mysql query slow... Horrible !!! ># User@Host: ># Query_time: 837 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 >SET timestamp=1117125449; >SELECT >articles.id_article,articles.id_rubrique,articles.id_secteur,articles.surtitre,articles.titre,articles.soustitre,articles.date,articles.date_redac,articles.date_modif,articles.visites,articles.popularite,articles.statut,articles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article >* UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles AS >articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE >articles.id_article=lien_mot.id_article AND lien_mot.id_mot=mots.id_mot AND >mots.titre='Bandeau' AND articles.statut='publie' GROUP BY >articles.id_article ORDER BY alea LIMIT 0,1; ># Time: 050526 18:37:31 ># User@Host: ># Query_time: 798 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 >SET timestamp=1117125451; >SELECT >articles.id_article,articles.id_rubrique,articles.id_secteur,articles.surtitre,articles.titre,articles.soustitre,articles.date,articles.date_redac,articles.date_modif,articles.visites,articles.popularite,articles.statut,articles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article >* UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles AS >articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE >articles.id_article=lien_mot.id_article AND lien_mot.id_mot=mots.id_mot AND >mots.titre='Bandeau' AND articles.statut='publie' GROUP BY >articles.id_article ORDER BY alea LIMIT 0,1; > > > From owner-freebsd-database@FreeBSD.ORG Tue May 31 18:35:13 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 B161F16A41C for ; Tue, 31 May 2005 18:35:13 +0000 (GMT) (envelope-from steve.rieger@tbwachiat.com) Received: from tbwachiat.com (venus.tbwachiat.com [208.244.203.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6916843D53 for ; Tue, 31 May 2005 18:35:13 +0000 (GMT) (envelope-from steve.rieger@tbwachiat.com) Received: from [10.20.4.87] steve_rieger [10.20.4.87] by tbwachiat.com with NetMail SMTP Agent $Revision: 3.22.1.16 $ on Novell NetWare via secured & encrypted transport (TLS); Tue, 31 May 2005 14:35:12 -0400 Mime-Version: 1.0 (Apple Message framework v622) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <4de2e73eaff31d439d0ed97f24d46f84@tbwachiat.com> Content-Transfer-Encoding: 7bit From: Steve Rieger Date: Tue, 31 May 2005 14:35:19 -0400 To: freebsd database list X-Mailer: Apple Mail (2.622) Subject: oracle insta client on fbsd 5.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, 31 May 2005 18:35:13 -0000 hi all, am trying to get this happening for about a week now, i dont want to install all of oracle and i tried the port oracle-client, and also php4-oracle, but keep getting the call to undefined function on my httpd-error logs any pointers as to how i can properly install the oracle client for use either with adodb or drectly with php. thanx -- Steve Rieger (212) 804-1131 (Work) (646) 335-8915 (Cell) chozrim (aim)