From owner-freebsd-database@FreeBSD.ORG Mon Mar 12 15:32:20 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 17DB016A417 for ; Mon, 12 Mar 2007 15:32:20 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by mx1.freebsd.org (Postfix) with ESMTP id D9E8D13C469 for ; Mon, 12 Mar 2007 15:32:19 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HQmVX-00034N-03 for freebsd-database@freebsd.org; Mon, 12 Mar 2007 08:32:19 -0700 Message-ID: <9436795.post@talk.nabble.com> Date: Mon, 12 Mar 2007 08:32:18 -0700 (PDT) From: drewshen To: freebsd-database@freebsd.org In-Reply-To: <9397995.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: drewsheneman@gmail.com References: <9273118.post@talk.nabble.com> <200703041906.59868.idiotbg@gmail.com> <9315636.post@talk.nabble.com> <106801c75fd3$7d6d9420$2401010a@zone3000.net> <9397995.post@talk.nabble.com> Subject: Re: mysql.sock 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: Mon, 12 Mar 2007 15:32:20 -0000 drewshen wrote: >=20 >=20 >=20 > Vitali Malicky wrote: >>=20 >>=20 >> ----- Original Message ----- >> From: "drewshen" >> To: >> Sent: Monday, March 05, 2007 7:04 PM >> Subject: Re: mysql.sock >>=20 >>=20 >>=20 >>=20 >>=20 >> Momchil Ivanov wrote: >>> >>> =D0=9D=D0=B0 2.3.2007 17:55 drewshen =D0=BF=D0=B8=D1=88=D0=B5: >>>> I installed mysql through ports on freebsd 6.1. i started the daemon= , >>>> and >>>> mysql starts. however when i try "mysql" i get >>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket >>>> '/tmp/mysql.sock' >>>> >>>> i looked this up on the mysql page and did find much help. first i >>>> tried >>>> >>>> shell> chmod +t /tmp >>>> >>>> to protect tmp. that didnt solve it, so i tried to point my sock file >>>> to >>>> another directory in /etc/my.cnf. i got the same error message, even >>>> with >>>> the new directory. does anyone know where my problem lies? thanks! >>> >>> "What do you see in your mysql error log file?" >>> >>> my error log shows no record of the "mysql.sock" error message. my >>> latest >>> record in it was when i restarted mysql. i tried "ps -ef | grep mysql" >>> and the only result was my search. however when i started mysql it said >>> it >>> was starting. >>> >>=20 >> "weird... >> will you please send your my.cnf here? >> also I wouldn't mind to see your build options." >>=20 >>=20 >> "I created my.cnf in order to try to redirect where mysql.sock was >> created. When this did not work I deleted it. I did not use any >> customized build options either, I just used the updated ports collectio= n >> in freebsd 6.1. and did a "make install clean." Is there any way I can >> allow mysql to create this socket file so it will work properly?" >>=20 >> I tried mysqld_safe: >>=20 >> # mysqld_safe >> Starting mysqld daemon with databases from /var/db/mysql >> STOPPING server from pid file /var/db/mysql/hostname.com.pid >> 070312 10:29:29 mysqld ended >>=20 >> i was running as root when i tried this >>=20 >> i also tried again to set up a different location to create mysql.sock: >>=20 >> i put these lines in my.cnf: >>=20 >> [mysqld]=20 >> socket=3D/usr/local/etc =20 >> =20 >> [client] >> socket=3D/usr/local/etc=20 >>=20 >> and tried to start mysql: >>=20 >> # mysql >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket >> '/usr/local/etc' (38) >> #=20 >>=20 >> i tried mysqld_safe again: >>=20 >> # mysqld_safe >> Starting mysqld daemon with databases from /var/db/mysql >> rm: /usr/local/etc: is a directory >> STOPPING server from pid file /var/db/mysql/hostname.com.pid >> 070312 10:39:46 mysqld ended >>=20 >>=20 >>> -- >>> This correspondence is strictly confidential. Any screening, filtering >>> and/or production for the purpose of public or otherwise disclosure is >>> forbidden without written permission by the author signed above. If you >>> are >>> not the intended recipient, please immediately notify the sender and >>> permanently delete any copies >>> >>> PGP KeyID: 0x3118168B >>> Keyserver: pgp.mit.edu >>> Key fingerprint BB50 2983 0714 36DC D02E 158A E03D 56DA 3118 168B >>> >>> >>> >>=20 >> -- >> View this message in context: >> http://www.nabble.com/mysql.sock-tf3334648.html#a9315636 >> Sent from the freebsd-database mailing list archive at Nabble.com. >>=20 >> _______________________________________________ >> 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" >>=20 >>=20 >>=20 >> _______________________________________________ >> 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" >>=20 >>=20 >=20 >=20 --=20 View this message in context: http://www.nabble.com/mysql.sock-tf3334648.ht= ml#a9436795 Sent from the freebsd-database mailing list archive at Nabble.com. From owner-freebsd-database@FreeBSD.ORG Mon Mar 12 17:31:40 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 64EA516A400 for ; Mon, 12 Mar 2007 17:31:40 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.177]) by mx1.freebsd.org (Postfix) with ESMTP id E180A13C448 for ; Mon, 12 Mar 2007 17:31:39 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: by ik-out-1112.google.com with SMTP id c21so1737982ika for ; Mon, 12 Mar 2007 10:31:38 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:mime-version:content-type; b=Wx1BcIh+cUAY64Mb5uG56px901rUo5m1P/TZvtLl842ZK2vq8MxHGliKMpV/oClFaaH4t4/WwPcXZoDc8+5WyjGHVNCAKtkDDZO7NFL9Xc1IoevypRa57jpEApkqSCbmmZlZWtDQbGp9E1vN+OMEiDwmvvrkw6H22CnhVnWVI1U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:mime-version:content-type; b=e2CSIZHKNOkukeLy4VJN5I0h8v3UCx0PzI+cPX1n9Msc54/TBOp2BAadQ+Tc2nh3ztZOEsw51BmLvHh0SUx2H2UXHKdmtAC6FnnuEYYOFbAmjWOkYny+EALHgsMXu3UAzIigIJnu6XdgCULxlrQjX5FKWWkQmqH/piG+8yMNGHE= Received: by 10.70.29.14 with SMTP id c14mr11049499wxc.1173720695855; Mon, 12 Mar 2007 10:31:35 -0700 (PDT) Received: by 10.100.57.12 with HTTP; Mon, 12 Mar 2007 10:31:35 -0700 (PDT) Message-ID: Date: Mon, 12 Mar 2007 19:31:35 +0200 From: "Dan Cojocar" To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_4840_16677930.1173720695793" Cc: fjoe@freebsd.org Subject: oracle8-client 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: Mon, 12 Mar 2007 17:31:40 -0000 ------=_Part_4840_16677930.1173720695793 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello Max and all, I have tried oci02 on -current, 6.2-stable and 6.1-stable and I receive the same error: ./oci02 1 Number of tables is 1 -- ORACLE error ORA-12545: Connect failed because target host or object does not exist I have attached the sqlnet.log file. How can I debug this problem? TIA, Dan ------=_Part_4840_16677930.1173720695793 Content-Type: application/octet-stream; name=sqlnet.log Content-Transfer-Encoding: base64 X-Attachment-Id: f_ez77494z Content-Disposition: attachment; filename="sqlnet.log" CgoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKgpGYXRhbCBOSSBjb25uZWN0IGVycm9yIDEyNTQ1LCBjb25uZWN0aW5n IHRvOgogKERFU0NSSVBUSU9OPShBRERSRVNTPShQUk9UT0NPTD1iZXEpKFBST0dSQU09L3Vzci9s b2NhbC9vcmFjbGU4LWNsaWVudC9iaW4vb3JhY2xlKShBUkdWMD1vcmFjbGUpKEFSR1M9JyhERVND UklQVElPTj0oTE9DQUw9WUVTKShBRERSRVNTPShQUk9UT0NPTD1iZXEpKSknKShERVRBQ0g9Tk8p KShDT05ORUNUX0RBVEE9KENJRD0oUFJPR1JBTT0pKEhPU1Q9LjAtQ1VSUkVOVCkoVVNFUj1yb290 KSkpKQoKICBWRVJTSU9OIElORk9STUFUSU9OOgoJVE5TIGZvciBMaW51eDogVmVyc2lvbiA4LjEu Ny4wLjAgLSBEZXZlbG9wbWVudAoJT3JhY2xlIEJlcXVlYXRoIE5UIFByb3RvY29sIEFkYXB0ZXIg Zm9yIExpbnV4OiBWZXJzaW9uIDguMS43LjAuMCAtIERldmVsb3BtZW50CiAgVGltZTogMTItTUFS LTIwMDcgMTk6MzA6MzEKICBUcmFjaW5nIG5vdCB0dXJuZWQgb24uCiAgVG5zIGVycm9yIHN0cnVj dDoKICAgIG5yIGVyciBjb2RlOiAwCiAgICBucyBtYWluIGVyciBjb2RlOiAxMjU0NQogICAgVE5T LTEyNTQ1OiBNZXNzYWdlIDEyNTQ1IG5vdCBmb3VuZDsgTm8gbWVzc2FnZSBmaWxlIGZvciBwcm9k dWN0PW5ldHdvcmssIGZhY2lsaXR5PVROUwogICAgbnMgc2Vjb25kYXJ5IGVyciBjb2RlOiAxMjU2 MAogICAgbnQgbWFpbiBlcnIgY29kZTogNTE1CiAgICBUTlMtMDA1MTU6IE1lc3NhZ2UgNTE1IG5v dCBmb3VuZDsgTm8gbWVzc2FnZSBmaWxlIGZvciBwcm9kdWN0PW5ldHdvcmssIGZhY2lsaXR5PVRO UwogICAgbnQgc2Vjb25kYXJ5IGVyciBjb2RlOiAyCiAgICBudCBPUyBlcnIgY29kZTogMAoKCioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqCkZhdGFsIE5JIGNvbm5lY3QgZXJyb3IgMTI1NDUsIGNvbm5lY3RpbmcgdG86 CiAoREVTQ1JJUFRJT049KEFERFJFU1M9KFBST1RPQ09MPWJlcSkoUFJPR1JBTT0vdXNyL2xvY2Fs L29yYWNsZTgtY2xpZW50L2Jpbi9vcmFjbGUpKEFSR1YwPW9yYWNsZSkoQVJHUz0nKERFU0NSSVBU SU9OPShMT0NBTD1ZRVMpKEFERFJFU1M9KFBST1RPQ09MPWJlcSkpKScpKERFVEFDSD1OTykpKENP Tk5FQ1RfREFUQT0oQ0lEPShQUk9HUkFNPSkoSE9TVD0uMC1DVVJSRU5UKShVU0VSPXJvb3QpKSkp CgogIFZFUlNJT04gSU5GT1JNQVRJT046CglUTlMgZm9yIExpbnV4OiBWZXJzaW9uIDguMS43LjAu MCAtIERldmVsb3BtZW50CglPcmFjbGUgQmVxdWVhdGggTlQgUHJvdG9jb2wgQWRhcHRlciBmb3Ig TGludXg6IFZlcnNpb24gOC4xLjcuMC4wIC0gRGV2ZWxvcG1lbnQKICBUaW1lOiAxMi1NQVItMjAw NyAxOTozMDozMQogIFRyYWNpbmcgbm90IHR1cm5lZCBvbi4KICBUbnMgZXJyb3Igc3RydWN0Ogog ICAgbnIgZXJyIGNvZGU6IDAKICAgIG5zIG1haW4gZXJyIGNvZGU6IDEyNTQ1CiAgICBUTlMtMTI1 NDU6IE1lc3NhZ2UgMTI1NDUgbm90IGZvdW5kOyBObyBtZXNzYWdlIGZpbGUgZm9yIHByb2R1Y3Q9 bmV0d29yaywgZmFjaWxpdHk9VE5TCiAgICBucyBzZWNvbmRhcnkgZXJyIGNvZGU6IDEyNTYwCiAg ICBudCBtYWluIGVyciBjb2RlOiA1MTUKICAgIFROUy0wMDUxNTogTWVzc2FnZSA1MTUgbm90IGZv dW5kOyBObyBtZXNzYWdlIGZpbGUgZm9yIHByb2R1Y3Q9bmV0d29yaywgZmFjaWxpdHk9VE5TCiAg ICBudCBzZWNvbmRhcnkgZXJyIGNvZGU6IDIKICAgIG50IE9TIGVyciBjb2RlOiAwCg== ------=_Part_4840_16677930.1173720695793-- From owner-freebsd-database@FreeBSD.ORG Tue Mar 13 08:55:28 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0703516A403 for ; Tue, 13 Mar 2007 08:55:28 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.242]) by mx1.freebsd.org (Postfix) with ESMTP id C1AB113C44B for ; Tue, 13 Mar 2007 08:55:27 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: by an-out-0708.google.com with SMTP id c24so1645762ana for ; Tue, 13 Mar 2007 01:55:27 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qq8w3zZmlCMua6ocZ7mR2Dvaoh26coobFu9iueaBNVkzac0MrHVJXfXlqkCXcsdZ6F2o9GGk+w9v4HXOZKsDOy9vhltoAmjZWPB0Xvf90jYmDSmST1O3d7qKwkvumS691GAYV5uMiWoAY9EhFSjXdiZzTs7xDWgDJrrqoTnO25I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Owa9HSlZNFhO5TQh2U8NT0rxSAqsadb6eB04yL2Mo6uJX0TGzHvWVBTKEZT3cZzPt6ByJaPAMAwvYRqK9PSAzWABj7gODNupw7F6BB+K9E1O2T6fZGDHLuI4aaD2arMFrsOc0JipUp4lPwaB2120CJzLkFE4+Bjl0h+VgMrVUf0= Received: by 10.100.152.9 with SMTP id z9mr502257and.1173776126964; Tue, 13 Mar 2007 01:55:26 -0700 (PDT) Received: by 10.100.57.12 with HTTP; Tue, 13 Mar 2007 01:55:26 -0700 (PDT) Message-ID: Date: Tue, 13 Mar 2007 10:55:26 +0200 From: "Dan Cojocar" To: "Max Khon" In-Reply-To: <20070313085009.GA7829@samodelkin.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070313085009.GA7829@samodelkin.net> Cc: freebsd-database@freebsd.org Subject: Re: oracle8-client 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, 13 Mar 2007 08:55:28 -0000 On 3/13/07, Max Khon wrote: > Hi! > > On Mon, Mar 12, 2007 at 07:31:35PM +0200, Dan Cojocar wrote: > > > I have tried oci02 on -current, 6.2-stable and 6.1-stable and I > > receive the same error: > > > > ./oci02 1 > > > > Number of tables is 1 > > > > -- ORACLE error > > ORA-12545: Connect failed because target host or object does not exist > > > > I have attached the sqlnet.log file. > > How can I debug this problem? > > Do you connect via tcp/ip? Only tcp/ip protocol works at the moment. > Please show your tnsnames.ora. > > /fjoe Hello Max, Here is my tnsnames.ora file: SERVER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)(PORT = 1521)) ) (CONNECT_DATA = (SID = SERVER) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = SERVER) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 192.168.100.1 is a host from my network where I have installed oracle express 10. I can access the web interface and it's working fine, so I think that XE it's working properly. Thank you, Dan From owner-freebsd-database@FreeBSD.ORG Tue Mar 13 09:18:23 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 5917E16A403 for ; Tue, 13 Mar 2007 09:18:23 +0000 (UTC) (envelope-from fjoe@neo.samodelkin.net) Received: from neo.samodelkin.net (samodelkin.net [195.62.0.66]) by mx1.freebsd.org (Postfix) with ESMTP id 1224013C4C4 for ; Tue, 13 Mar 2007 09:18:22 +0000 (UTC) (envelope-from fjoe@neo.samodelkin.net) Received: by neo.samodelkin.net (Postfix, from userid 1000) id 0F1BF17069; Tue, 13 Mar 2007 14:50:10 +0600 (NOVT) Date: Tue, 13 Mar 2007 14:50:09 +0600 From: Max Khon To: Dan Cojocar Message-ID: <20070313085009.GA7829@samodelkin.net> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2i Cc: freebsd-database@freebsd.org, fjoe@freebsd.org Subject: Re: oracle8-client 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, 13 Mar 2007 09:18:23 -0000 Hi! On Mon, Mar 12, 2007 at 07:31:35PM +0200, Dan Cojocar wrote: > I have tried oci02 on -current, 6.2-stable and 6.1-stable and I > receive the same error: > > ./oci02 1 > > Number of tables is 1 > > -- ORACLE error > ORA-12545: Connect failed because target host or object does not exist > > I have attached the sqlnet.log file. > How can I debug this problem? Do you connect via tcp/ip? Only tcp/ip protocol works at the moment. Please show your tnsnames.ora. /fjoe From owner-freebsd-database@FreeBSD.ORG Thu Mar 15 22:29:09 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 8B9CB16A402; Thu, 15 Mar 2007 22:29:09 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id 50DF213C44B; Thu, 15 Mar 2007 22:29:09 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.44) id 1HRyC3-0002cL-3n; Thu, 15 Mar 2007 23:13:07 +0100 Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: quoted-printable Message-Id: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> Content-Type: text/plain; charset=UTF-8; delsp=yes; format=flowed To: freebsd-amd64@freebsd.org, freebsd-database@freebsd.org From: Axel Rau Date: Thu, 15 Mar 2007 23:13:03 +0100 X-Mailer: Apple Mail (2.752.2) Cc: Subject: New Opteron box, dedicated to PostgreSQL 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, 15 Mar 2007 22:29:09 -0000 Hi, while configuring my 1st PostgreSQL box with dual Opterons (2212) on =20 FreeBSD, I have some questions: 1. Are there any precautions in fbsd to prevent from excessive page =20 switching between the memory nodes? E.g. what happens if file cache pages (heavily used by Pg, =20 planned 6GB) frequently not found on local node? 2. If there is no good solution for this problem, does it make sense =20 to stay with one dualcore (soon quadcore) processor? 3. What are the recommendations for tuning I/O)? - setting sysctl vfs.read_max to 16 or 32 - rebuilding the relevant filesystem with 32K blocks and 4K frags Are these reliable? 4. Can I install the system on an Areca raid? Thanks, Axel --------------------------------------------------------------------- Axel Rau, =E2=98=80Frankfurt , Germany +49 69 9514 = 18 0 From owner-freebsd-database@FreeBSD.ORG Thu Mar 15 23:38:25 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id A644416A400 for ; Thu, 15 Mar 2007 23:38:25 +0000 (UTC) (envelope-from janm@transactionware.com) Received: from mail.transactionware.com (mail.transactionware.com [203.14.245.7]) by mx1.freebsd.org (Postfix) with SMTP id E2D8013C44B for ; Thu, 15 Mar 2007 23:38:24 +0000 (UTC) (envelope-from janm@transactionware.com) Received: (qmail 37523 invoked from network); 15 Mar 2007 23:12:03 -0000 Received: from midgard.transactionware.com (192.168.1.55) by dm.transactionware.com with SMTP; 15 Mar 2007 23:12:03 -0000 Received: (qmail 59041 invoked by uid 907); 15 Mar 2007 23:11:41 -0000 Received: from midgard.transactionware.com (HELO jmlaptop) (192.168.1.55) by midgard.transactionware.com (qpsmtpd/0.32) with ESMTP; Fri, 16 Mar 2007 10:11:41 +1100 From: "Jan Mikkelsen" To: "'Axel Rau'" , , Date: Fri, 16 Mar 2007 10:11:40 +1100 Message-ID: <000801c76757$4a6cf9e0$0204a8c0@jmlaptop> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6822 In-Reply-To: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> Thread-Index: AcdnUZHUi/lpZ5i9TD6DEoK3hNnjZAABK/bg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Importance: Normal Cc: Subject: RE: New Opteron box, dedicated to PostgreSQL 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, 15 Mar 2007 23:38:25 -0000 Hi, Axel Rau wrote: > 1. Are there any precautions in fbsd to prevent from excessive page > switching between the memory nodes? > E.g. what happens if file cache pages (heavily used by Pg, > planned 6GB) frequently not found on local node? Not that I'm aware of. FreeBSD doesn't have NUMA awareness. > 2. If there is no good solution for this problem, does it make sense > to stay with one dualcore (soon quadcore) processor? Benchmark and see. > 4. Can I install the system on an Areca raid? Yes. If you are planning to use 6.2-RELEASE, make sure that you get the arcmsr driver from 6-STABLE. The arcmsr driver in 6.2-RELEASE can show I/O errors under high load. Regards, Jan Mikkelsen From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 08:46:00 2007 Return-Path: X-Original-To: freebsd-database@FreeBSD.ORG Delivered-To: freebsd-database@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 257DD16A403; Fri, 16 Mar 2007 08:46:00 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8]) by mx1.freebsd.org (Postfix) with ESMTP id 85BBD13C43E; Fri, 16 Mar 2007 08:45:59 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (bmtuhk@localhost [127.0.0.1]) by lurza.secnetix.de (8.13.4/8.13.4) with ESMTP id l2G88FTD030413; Fri, 16 Mar 2007 09:08:21 +0100 (CET) (envelope-from oliver.fromme@secnetix.de) Received: (from olli@localhost) by lurza.secnetix.de (8.13.4/8.13.1/Submit) id l2G88FBN030412; Fri, 16 Mar 2007 09:08:15 +0100 (CET) (envelope-from olli) Date: Fri, 16 Mar 2007 09:08:15 +0100 (CET) Message-Id: <200703160808.l2G88FBN030412@lurza.secnetix.de> From: Oliver Fromme To: freebsd-database@FreeBSD.ORG, Axel.Rau@chaos1.de, freebsd-amd64@FreeBSD.ORG In-Reply-To: X-Newsgroups: list.freebsd-database User-Agent: tin/1.8.2-20060425 ("Shillay") (UNIX) (FreeBSD/4.11-STABLE (i386)) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.1.2 (lurza.secnetix.de [127.0.0.1]); Fri, 16 Mar 2007 09:08:21 +0100 (CET) Cc: Subject: Re: New Opteron box, dedicated to PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd-database@FreeBSD.ORG, Axel.Rau@chaos1.de, freebsd-amd64@FreeBSD.ORG List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Mar 2007 08:46:00 -0000 Axel Rau wrote: > while configuring my 1st PostgreSQL box with dual Opterons (2212) on > FreeBSD, I have some questions: > [...] > 3. What are the recommendations for tuning I/O)? > - setting sysctl vfs.read_max to 16 or 32 > - rebuilding the relevant filesystem with 32K blocks and 4K frags > Are these reliable? Personally I would leave the FS parameters at the defaults. The bsize/fsize defaults of 16k/2k are actually quite well- suited for PostgreSQL, as far as I can tell. (If there are people who have made different experience, I'd like to hear about it.) If you expect that only few, large tables will be used, then reducing the inode density (i.e. increasing the value of the -i option to newfs) might be a good idea. Note that PostgreSQL stores each object (table, index etc.) in its own file. Be sure to disable background fsck via /etc/rc.conf. I've seen it breaking file systems under certain circumstances. Instead, you might want want to give PWD's new gjournal code a try (it's in -current, but I think there's a port to RELENG_6, too). On a related note, setting up gmirror for RAID-1 has worked very well for me, including postgres machines (the balance algorithm "load" seems to work best with pgsql databases). Of course, the usual PostgreSQL tuning advices apply, e.g. increase the SysV IPC resources (i.e. kernel parameters for semaphores and shared memory), optimize postgresql.conf etc. There's currently a known bottleneck regarding SysV IPC on FreeBSD, if a lot of processes are waiting on the same semaphore, which can affect PostgreSQL under very high load. I don't know what the status of that is, but I think nobody is currently working on a fix. Best regards Oliver -- Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing b. M. Handelsregister: Registergericht Muenchen, HRA 74606, Geschäftsfuehrung: secnetix Verwaltungsgesellsch. mbH, Handelsregister: Registergericht Mün- chen, HRB 125758, Geschäftsführer: Maik Bachmann, Olaf Erb, Ralf Gebhart FreeBSD-Dienstleistungen, -Produkte und mehr: http://www.secnetix.de/bsd PI: int f[9814],b,c=9814,g,i;long a=1e4,d,e,h; main(){for(;b=c,c-=14;i=printf("%04d",e+d/a),e=d%a) while(g=--b*2)d=h*b+a*(i?f[b]:a/5),h=d/--g,f[b]=d%g;} From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 11:45:45 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D317116A406 for ; Fri, 16 Mar 2007 11:45:45 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by mx1.freebsd.org (Postfix) with ESMTP id 6565E13C45E for ; Fri, 16 Mar 2007 11:45:44 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by ug-out-1314.google.com with SMTP id 71so654233ugh for ; Fri, 16 Mar 2007 04:45:44 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qY5q5UGIcc3yaJV9smB3GHSls5Ip/xQ53I7zh1clLX8vrryTZBPB/cLLPawKdoG+QfLhW89hipAPXUhXJZ7/bLnyFokOCh+CaAGYUNwHpv6qM7oYJX6JyUtKjtRUAmVow8U0OUjHX6etGL8MSCXFdhQbuSSjbHEA6liY7MuvMps= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hvGS0nvSlmXoz5oC44U9S6fL1e8s5Y0TDEtBK5vPCuOF4PMxQSVOrN4ji+onawTuBmn+lrspllujqtJHJUA7lnDRxSGESIdXmy7GMVTP5sTmt5SzGwCC9Us4a0viMpAAORaUkBoI5Er+WW+IDZaXlZYs1dSpnOEmGgnjgI4jCZ0= Received: by 10.115.77.1 with SMTP id e1mr667752wal.1174043836066; Fri, 16 Mar 2007 04:17:16 -0700 (PDT) Received: by 10.114.194.12 with HTTP; Fri, 16 Mar 2007 04:17:16 -0700 (PDT) Message-ID: Date: Fri, 16 Mar 2007 12:17:16 +0100 From: "Claus Guttesen" To: "Axel Rau" In-Reply-To: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> Cc: freebsd-database@freebsd.org, freebsd-amd64@freebsd.org Subject: Re: New Opteron box, dedicated to PostgreSQL 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: Fri, 16 Mar 2007 11:45:45 -0000 > while configuring my 1st PostgreSQL box with dual Opterons (2212) on > FreeBSD, I have some questions: > > 3. What are the recommendations for tuning I/O)? > - setting sysctl vfs.read_max to 16 or 32 > - rebuilding the relevant filesystem with 32K blocks and 4K frags > Are these reliable? The following were suggetions from Vivek Khera: /boot/loader.conf: kern.ipc.semmni=256 kern.ipc.semmns=2048 /etc/sysctl.conf: kern.ipc.somaxconn=2048 kern.maxfiles=65536 # Suggestions by Vivek Khera from postgresql performance kern.ipc.shm_use_phys=1 kern.ipc.shmmax=1073741824 kern.ipc.shmall=262144 kern.ipc.semmsl=512 kern.ipc.semmap=256 This is on a four-way woodcrest at 3 GHz and 16 GB ram so you may want to adjust the values. regards Claus From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 14:56:36 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4F03216A404; Fri, 16 Mar 2007 14:56:36 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id 0FCFD13C468; Fri, 16 Mar 2007 14:56:35 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.44) id 1HSDr8-0007vv-51; Fri, 16 Mar 2007 15:56:34 +0100 In-Reply-To: <000801c76757$4a6cf9e0$0204a8c0@jmlaptop> References: <000801c76757$4a6cf9e0$0204a8c0@jmlaptop> Mime-Version: 1.0 (Apple Message framework v752.2) X-Priority: 3 (Normal) Content-Type: text/plain; charset=UTF-8; delsp=yes; format=flowed Message-Id: <00E1DD54-6FED-4223-894C-A1B6CE6B9020@Chaos1.DE> Content-Transfer-Encoding: quoted-printable From: Axel Rau Date: Fri, 16 Mar 2007 15:56:32 +0100 To: Jan Mikkelsen X-Mailer: Apple Mail (2.752.2) Cc: freebsd-database@freebsd.org, freebsd-amd64@freebsd.org Subject: Re: New Opteron box, dedicated to PostgreSQL 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: Fri, 16 Mar 2007 14:56:39 -0000 Am 16.03.2007 um 00:11 schrieb Jan Mikkelsen: > > Not that I'm aware of. FreeBSD doesn't have NUMA awareness. And fbsd does not allow to tie say a process group to a cpu? > >> 2. If there is no good solution for this problem, does it make sense >> to stay with one dualcore (soon quadcore) processor? > > Benchmark and see. Would be nice to know before I order the stuff.., > >> 4. Can I install the system on an Areca raid? > > Yes. If you are planning to use 6.2-RELEASE, make sure that you =20 > get the > arcmsr driver from 6-STABLE. The arcmsr driver in 6.2-RELEASE can =20 > show > I/O errors under high load. That's valuable info. Thanks, Axel --------------------------------------------------------------------- Axel Rau, =E2=98=80Frankfurt , Germany +49 69 9514 = 18 0 From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 15:01:33 2007 Return-Path: X-Original-To: freebsd-database@FreeBSD.ORG Delivered-To: freebsd-database@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 329BE16A401; Fri, 16 Mar 2007 15:01:33 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id E7BC113C465; Fri, 16 Mar 2007 15:01:32 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.44) id 1HSDvv-000723-6A; Fri, 16 Mar 2007 16:01:31 +0100 In-Reply-To: <200703160808.l2G88FBN030412@lurza.secnetix.de> References: <200703160808.l2G88FBN030412@lurza.secnetix.de> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=UTF-8; format=flowed Message-Id: <1FDE5616-AF00-416F-B8E8-1D6A584B1126@chaos1.de> Content-Transfer-Encoding: quoted-printable From: Axel Rau Date: Fri, 16 Mar 2007 16:01:30 +0100 To: Oliver Fromme X-Mailer: Apple Mail (2.752.2) Cc: freebsd-database@FreeBSD.ORG, freebsd-amd64@FreeBSD.ORG Subject: Re: New Opteron box, dedicated to PostgreSQL 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: Fri, 16 Mar 2007 15:01:33 -0000 Am 16.03.2007 um 09:08 schrieb Oliver Fromme: > Be sure to disable background fsck via /etc/rc.conf. I've > seen it breaking file systems under certain circumstances. Good to know. What about softupdates? > Instead, you might want want to give PWD's new gjournal > code a try (it's in -current, but I think there's a port > to RELENG_6, too). I will have a look at it. Axel --------------------------------------------------------------------- Axel Rau, =E2=98=80Frankfurt , Germany +49 69 9514 = 18 0 From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 15:08:25 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0446516A401 for ; Fri, 16 Mar 2007 15:08:25 +0000 (UTC) (envelope-from astrodog@gmail.com) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.232]) by mx1.freebsd.org (Postfix) with ESMTP id 9C91713C45E for ; Fri, 16 Mar 2007 15:08:24 +0000 (UTC) (envelope-from astrodog@gmail.com) Received: by wx-out-0506.google.com with SMTP id s18so557567wxc for ; Fri, 16 Mar 2007 08:08:24 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=DaNBER+/iUAsrLb7bUp6mkyMK3EATT941r+MLg3uabpAisy/dvd2F8DiBapjIfk10980pX019yLldgTnithhsUsNs7W34sTM5qHZS8QsoOC8Za7i8hDG4g80aoStqPUkvlSAr2JFatvu6d5OHvkDrsQ846XGKEbhMB2bI7SVzcM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=dBAwe2sKgz5PW+peh/Ja/O/k+okJsd/S7IZoPkCuUUISYOxJzwW22Qc4qg1o8To6s+R9wQTJUeMQLgg4DSCzEx/hzmNldu8kNgIOaJ5J9x7M8Cbh1wbWvoD6RsmLoMqXMBwuRJDHKt2/p8YP6AAzDVKiZbhxByG0O5azcK7/BFs= Received: by 10.90.51.17 with SMTP id y17mr1795102agy.1174056043221; Fri, 16 Mar 2007 07:40:43 -0700 (PDT) Received: from ?192.168.1.2? ( [71.153.182.192]) by mx.google.com with ESMTP id 17sm8798626nzo.2007.03.16.07.40.41; Fri, 16 Mar 2007 07:40:42 -0700 (PDT) Message-ID: <45FAAC6A.90209@gmail.com> Date: Fri, 16 Mar 2007 09:40:42 -0500 From: Harrison Grundy User-Agent: Thunderbird 1.5.0.7 (X11/20061027) MIME-Version: 1.0 References: <000801c76757$4a6cf9e0$0204a8c0@jmlaptop> In-Reply-To: <000801c76757$4a6cf9e0$0204a8c0@jmlaptop> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: 'Axel Rau' , freebsd-database@freebsd.org, freebsd-amd64@freebsd.org Subject: Re: New Opteron box, dedicated to PostgreSQL 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: Fri, 16 Mar 2007 15:08:25 -0000 Jan Mikkelsen wrote: > Hi, > > Axel Rau wrote: > > >> 1. Are there any precautions in fbsd to prevent from excessive page >> switching between the memory nodes? >> E.g. what happens if file cache pages (heavily used by Pg, >> planned 6GB) frequently not found on local node? >> > > Not that I'm aware of. FreeBSD doesn't have NUMA awareness. > FreeBSD does not support this. I've been working on the scheduler side of things, but I do not understand the VM well enough to do that side of it. > >> 2. If there is no good solution for this problem, does it make sense >> to stay with one dualcore (soon quadcore) processor? >> No. 2 memory controllers beats 1, even with the remote penalty occuring. The difference either way will be fairly trivial, though. > > Benchmark and see. > > >> 4. Can I install the system on an Areca raid? >> > > Yes. If you are planning to use 6.2-RELEASE, make sure that you get the > arcmsr driver from 6-STABLE. The arcmsr driver in 6.2-RELEASE can show > I/O errors under high load. > > Regards, > > Jan Mikkelsen > > _______________________________________________ > freebsd-amd64@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-amd64 > To unsubscribe, send any mail to "freebsd-amd64-unsubscribe@freebsd.org" > > From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 18:55:43 2007 Return-Path: X-Original-To: freebsd-database@FreeBSD.ORG Delivered-To: freebsd-database@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id F3B6416A4DE; Fri, 16 Mar 2007 18:55:42 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53]) by mx1.freebsd.org (Postfix) with ESMTP id 34F9513C4F9; Fri, 16 Mar 2007 18:55:39 +0000 (UTC) (envelope-from Axel.Rau@chaos1.de) Received: from claudius6.in.chaos1.de ([192.168.220.106]) by mail1.chaos1.de with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.44) id 1HSHaS-0007LN-49; Fri, 16 Mar 2007 19:55:36 +0100 In-Reply-To: <200703160808.l2G88FBN030412@lurza.secnetix.de> References: <200703160808.l2G88FBN030412@lurza.secnetix.de> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=UTF-8; format=flowed Message-Id: <1FDE5616-AF00-416F-B8E8-1D6A584B1126@chaos1.de> Content-Transfer-Encoding: quoted-printable From: Axel Rau Date: Fri, 16 Mar 2007 16:01:30 +0100 To: Oliver Fromme X-Mailer: Apple Mail (2.752.2) Cc: freebsd-database@FreeBSD.ORG, freebsd-amd64@FreeBSD.ORG Subject: Re: New Opteron box, dedicated to PostgreSQL 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: Fri, 16 Mar 2007 18:55:43 -0000 Am 16.03.2007 um 09:08 schrieb Oliver Fromme: > Be sure to disable background fsck via /etc/rc.conf. I've > seen it breaking file systems under certain circumstances. Good to know. What about softupdates? > Instead, you might want want to give PWD's new gjournal > code a try (it's in -current, but I think there's a port > to RELENG_6, too). I will have a look at it. Axel --------------------------------------------------------------------- Axel Rau, =E2=98=80Frankfurt , Germany +49 69 9514 = 18 0 From owner-freebsd-database@FreeBSD.ORG Fri Mar 16 20:32:40 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E7B4F16A403; Fri, 16 Mar 2007 20:32:39 +0000 (UTC) (envelope-from vivek@khera.org) Received: from yertle.kcilink.com (yertle.kcilink.com [74.92.149.58]) by mx1.freebsd.org (Postfix) with ESMTP id 9710413C46A; Fri, 16 Mar 2007 20:32:39 +0000 (UTC) (envelope-from vivek@khera.org) Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103]) by yertle.kcilink.com (Postfix) with ESMTP id 7595BB820; Fri, 16 Mar 2007 16:04:10 -0400 (EDT) In-Reply-To: References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-9-347238058; protocol="application/pkcs7-signature" Message-Id: <111EFCD1-0B88-4646-BCF5-B13D1F3BBCB0@khera.org> From: Vivek Khera Date: Fri, 16 Mar 2007 16:04:09 -0400 To: FreeBSD AMD list X-Mailer: Apple Mail (2.752.2) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-database@freebsd.org Subject: Re: New Opteron box, dedicated to PostgreSQL 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: Fri, 16 Mar 2007 20:32:40 -0000 --Apple-Mail-9-347238058 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On Mar 16, 2007, at 7:17 AM, Claus Guttesen wrote: >> while configuring my 1st PostgreSQL box with dual Opterons (2212) on >> FreeBSD, I have some questions: >> >> 3. What are the recommendations for tuning I/O)? >> - setting sysctl vfs.read_max to 16 or 32 >> - rebuilding the relevant filesystem with 32K blocks and 4K frags >> Are these reliable? > > The following were suggetions from Vivek Khera: I've recently bumped the shmall and shmmax on my dual opteron with 16GB of RAM, and increased correspondingly the shared buffers. The max shmall you can set on freebsd (at least 6.1) is 2147483647, so I set shmall to 524288 to correspond. This supports 250000 shared buffers and 100 max connections. Might support more, but definitely not 260000. I'm also using vfs.read_max=32 but I haven't really tested if it makes a big difference in formal benchmarks. The other day I was having some I/O overload, so I tried setting vfs.hirunningspace to 3K but it didn't solve my immediate problem. I've left that setting for now. Doesn't seem to really make a big difference. I find that the adaptec 2230SLP RAID controllers are not able to keep up with my load, but the LSI 320-2X is. I'm currently investigating external arrays attached via fibre for some boost. --Apple-Mail-9-347238058--