From owner-freebsd-database@FreeBSD.ORG Thu May 26 16:46:06 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 1F47A16A41C for ; Thu, 26 May 2005 16:46:06 +0000 (GMT) (envelope-from pierre-gilles@netaktiv.com) Received: from aragon.netaktiv.com (ns3.netaktiv.com [62.212.103.139]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5695643D53 for ; Thu, 26 May 2005 16:46:04 +0000 (GMT) (envelope-from pierre-gilles@netaktiv.com) Received: from localhost (localhost [127.0.0.1]) by aragon.netaktiv.com (Postfix) with ESMTP id 3A3CF426F3 for ; Thu, 26 May 2005 18:46:02 +0200 (CEST) Received: from aragon.netaktiv.com ([127.0.0.1]) by localhost (aragon [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24026-24 for ; Thu, 26 May 2005 18:45:59 +0200 (CEST) Received: from laika (laika [172.21.0.3]) by aragon.netaktiv.com (Postfix) with ESMTP id 39111426ED for ; Thu, 26 May 2005 18:45:59 +0200 (CEST) From: Mialon Pierre-Gilles Organization: NetAktiv To: freebsd-database@freebsd.org Date: Thu, 26 May 2005 18:45:57 +0200 User-Agent: KMail/1.8 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200505261845.58035.pierre-gilles@netaktiv.com> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at aragon.netaktiv.com Subject: 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: Thu, 26 May 2005 16:46:06 -0000 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; -- Pierre-Gilles Mialon mialon@netaktiv.com From owner-freebsd-database@FreeBSD.ORG Thu May 26 16:51:49 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 A4E0716A41C for ; Thu, 26 May 2005 16:51:49 +0000 (GMT) (envelope-from anthony@shaolin.wccnet.org) Received: from shaolin.wccnet.org (shaolin.wccnet.org [198.111.176.53]) by mx1.FreeBSD.org (Postfix) with ESMTP id 56F5143D53 for ; Thu, 26 May 2005 16:51:49 +0000 (GMT) (envelope-from anthony@shaolin.wccnet.org) Received: from shaolin.wccnet.org (localhost.wccnet.org [127.0.0.1]) by shaolin.wccnet.org (8.12.11/8.12.2) with ESMTP id j4QGttSt030676; Thu, 26 May 2005 12:55:55 -0400 (EDT) Received: (from anthony@localhost) by shaolin.wccnet.org (8.12.11/8.12.3/Submit) id j4QGttCM030675; Thu, 26 May 2005 12:55:55 -0400 (EDT) Date: Thu, 26 May 2005 12:55:55 -0400 From: Anthony Schneider To: Mialon Pierre-Gilles Message-ID: <20050526165555.GA30296@x-anthony.com> References: <200505261845.58035.pierre-gilles@netaktiv.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="rwEMma7ioTxnRzrJ" Content-Disposition: inline In-Reply-To: <200505261845.58035.pierre-gilles@netaktiv.com> User-Agent: Mutt/1.4i Cc: freebsd-database@freebsd.org 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: Thu, 26 May 2005 16:51:50 -0000 --rwEMma7ioTxnRzrJ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable are you maybe missing some inndexes? and, though i haven't used mysql in a while, i don't think that they have out-of-the-box smp parallelization. -Anthony. On Thu, May 26, 2005 at 06:45:57PM +0200, Mialon Pierre-Gilles wrote: >=20 > Hi, >=20 > 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=20 > /usr/local/libexec/mysqld running in ps aux. > And I'm looking for a good tutorial to speed up the mysql-server on a Fre= eBSD=20 > box.=20 >=20 > The output is the content of mysql query slow... Horrible !!!=20 > # User@Host:=20 > # Query_time: 837 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 > SET timestamp=3D1117125449; > SELECT=20 > articles.id_article,articles.id_rubrique,articles.id_secteur,articles.sur= titre,articles.titre,articles.soustitre,articles.date,articles.date_redac,a= rticles.date_modif,articles.visites,articles.popularite,articles.statut,art= icles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article= =20 > * UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles = AS=20 > articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE=20 > articles.id_article=3Dlien_mot.id_article AND lien_mot.id_mot=3Dmots.id_m= ot AND=20 > mots.titre=3D'Bandeau' AND articles.statut=3D'publie' GROUP BY=20 > articles.id_article ORDER BY alea LIMIT 0,1; > # Time: 050526 18:37:31 > # User@Host:=20 > # Query_time: 798 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 > SET timestamp=3D1117125451; > SELECT=20 > articles.id_article,articles.id_rubrique,articles.id_secteur,articles.sur= titre,articles.titre,articles.soustitre,articles.date,articles.date_redac,a= rticles.date_modif,articles.visites,articles.popularite,articles.statut,art= icles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article= =20 > * UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles = AS=20 > articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE=20 > articles.id_article=3Dlien_mot.id_article AND lien_mot.id_mot=3Dmots.id_m= ot AND=20 > mots.titre=3D'Bandeau' AND articles.statut=3D'publie' GROUP BY=20 > articles.id_article ORDER BY alea LIMIT 0,1; >=20 > --=20 > Pierre-Gilles Mialon > mialon@netaktiv.com > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.or= g" --rwEMma7ioTxnRzrJ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFClf+aKUeW47UGY2kRAlzwAJwLQe/4oOIpGaF1sPVpe+4K3IZIZwCdHWeP qX4Dhe+uxywdFnOE05Y6+os= =6QKP -----END PGP SIGNATURE----- --rwEMma7ioTxnRzrJ-- From owner-freebsd-database@FreeBSD.ORG Sat May 28 20:59:52 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 91F4A16A41C for ; Sat, 28 May 2005 20:59:52 +0000 (GMT) (envelope-from martinkov@pobox.sk) Received: from smtp.dkm.cz (smtp.dkm.cz [62.24.64.34]) by mx1.FreeBSD.org (Postfix) with SMTP id C082843D1D for ; Sat, 28 May 2005 20:59:51 +0000 (GMT) (envelope-from martinkov@pobox.sk) Received: (qmail 5885 invoked by uid 0); 28 May 2005 20:59:49 -0000 Received: from r4aq194.chello.upc.cz (HELO ?84.42.170.194?) (84.42.170.194) by smtp.dkm.cz with SMTP; 28 May 2005 20:59:49 -0000 Message-ID: <4298DBC5.7030806@pobox.sk> Date: Sat, 28 May 2005 22:59:49 +0200 From: martinko User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.8) Gecko/20050520 X-Accept-Language: sk, cs, en-gb, en-us, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: 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: Sat, 28 May 2005 20:59:52 -0000 hi, i've just tried the same -- installing oracle 10.1.0.3 on freebsd 5.4-R -- without success. i followed daemonnews, the handbook, oracle guides for linux and some others, but: first, runInstaller failed due to unsupported OS -- this wasn't mentioned anywhere -- i tried to patch oraparam.ini but i failed :( second, i just tried to run 'runInstaller --help' and it crashed when initialising (see below) with java process using 100% cpu. :-( is there nobody who have successfully installed oracle 10g on freebsd 5.[3|4] ? or is just noone willing to share their how-to on this subject? cheers, martin -- the following was run from linux bash under oracle user : -su-2.05b$ ./runInstaller --help Preparing to launch Oracle Universal Installer from /home/oracle/tmp/OraInstall2005-05-28_10-51-36PM. Please wait ...-su-2.05b$ # # HotSpot Virtual Machine Error, Internal Error # Please report this error at # http://java.sun.com/cgi-bin/bugreport.cgi # # Java VM: Java HotSpot(TM) Client VM (1.4.2_02-b03 mixed mode) # # Error ID: 4F533F4C494E55580E43505001C9 # Heap at VM Abort: Heap