From users-return-18280-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org  Thu Oct 27 20:22:34 2011
Return-Path: <users-return-18280-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 676219A61
	for <apmail-jackrabbit-users-archive@minotaur.apache.org>; Thu, 27 Oct 2011 20:22:34 +0000 (UTC)
Received: (qmail 94996 invoked by uid 500); 27 Oct 2011 20:22:33 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 94861 invoked by uid 500); 27 Oct 2011 20:22:33 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 94852 invoked by uid 99); 27 Oct 2011 20:22:33 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2011 20:22:33 +0000
X-ASF-Spam-Status: No, hits=-1.0 required=5.0
	tests=RCVD_IN_DNSWL_MED,SPF_PASS,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of j.reijn@1hippo.com designates 64.18.2.206 as permitted sender)
Received: from [64.18.2.206] (HELO exprod7og126.obsmtp.com) (64.18.2.206)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 27 Oct 2011 20:22:27 +0000
Received: from mail-wy0-f176.google.com ([74.125.82.176]) (using TLSv1) by exprod7ob126.postini.com ([64.18.6.12]) with SMTP;
	Thu, 27 Oct 2011 13:22:06 PDT
Received: by wyf19 with SMTP id 19so3498547wyf.7
        for <users@jackrabbit.apache.org>; Thu, 27 Oct 2011 13:22:03 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.227.59.207 with SMTP id m15mr18861627wbh.12.1319746923075;
 Thu, 27 Oct 2011 13:22:03 -0700 (PDT)
Received: by 10.180.104.98 with HTTP; Thu, 27 Oct 2011 13:22:03 -0700 (PDT)
In-Reply-To: <BCD1AD7BDB7A2843BBE2D7036A5BB5D40348EA24@pwl-exmbx01>
References: <BCD1AD7BDB7A2843BBE2D7036A5BB5D40348EA24@pwl-exmbx01>
Date: Thu, 27 Oct 2011 22:22:03 +0200
Message-ID: <CAA6qe-LJbE5MFP23C8UEt1F5WV7xg7qeBjo1VzxaM0hfE+CbJg@mail.gmail.com>
Subject: Re: DbFileSystem in repository.xml
From: Jeroen Reijn <j.reijn@onehippo.com>
To: users@jackrabbit.apache.org
Cc: hippo-cms7-user@lists.onehippo.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,

this is probably due to the fact the your database journal is getting
quite large.
Do you cleanup the journal regularly?

On the jackrabbit wiki there is some documentation about it.

http://wiki.apache.org/jackrabbit/Clustering?highlight=3D%28journal%29%7C%2=
8janitor%29#Removing_Old_Revisions

You might also take a look at this thread. It's about the same thing.

http://hippo.2275632.n2.nabble.com/Lazy-loading-during-startup-td6788047.ht=
ml#a6788276

Cheers,

Jeroen

On Thu, Oct 27, 2011 at 9:38 PM, Rama Kesara <RKesara@art.com> wrote:
> I am seeing that everytime I restart my server, it is taking close to
> 3-4 minutes for initiation if I configure my fileSystem as DbFileSystem.
>
>
>
> 1) =A0 =A0 =A0 Is there something that can be configured to skip scanning=
 of
> existing tables or probably recreation of tables everytime I start the
> server?
>
> 2) =A0 =A0 =A0Is there something that we can configure to speedup this
> process? From the configuration below, anyone see outstanding issues
> that might create a performance overhead during server startup.
>
>
>
> I am using following combinations:
>
>
>
> <Repository>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<FileSystem
> class=3D"org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"url"
> value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"user" value=3D"user1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"password" value=3D"pass1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"schemaObjectPrefix"
> value=3D"repository_" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"schema" value=3D"mssql" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</FileSystem>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<Security appName=3D"Jackrabbit">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<SecurityM=
anager
> class=3D"org.hippoecm.repository.security.SecurityManager" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<AccessMan=
ager
> class=3D"org.hippoecm.repository.security.HippoAccessManager" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<LoginModu=
le
> class=3D"org.hippoecm.repository.security.HippoLoginModule" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</Security>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<Workspaces rootPath=3D"${rep.home}/worksp=
aces"
> defaultWorkspace=3D"default" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<Workspace name=3D"${wsp.name}">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<FileSyste=
m
> class=3D"org.apache.jackrabbit.core.fs.db.MSSqlFileSystem">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"url"
> value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"user"
> value=3D"user1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"password"
> value=3D"pass1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param
> name=3D"schemaObjectPrefix" value=3D"${wsp.name}_" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"schema"
> value=3D"mssql" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</FileSyst=
em>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<Persisten=
ceManager
> class=3D"org.apache.jackrabbit.core.persistence.pool.MSSqlPersistenceMana=
g
> er">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"driver"
> value=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver" />
>
> <param name=3D"url"
> value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"user"
> value=3D"user1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param name=3D"password"
> value=3D"pass1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param
> name=3D"schemaObjectPrefix" value=3D"${wsp.name}_" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param
> name=3D"externalBLOBs" value=3D"true" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param
> name=3D"consistencyCheck" value=3D"true" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0<param
> name=3D"consistencyFix" value=3D"true" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</Persiste=
nceManager>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0...
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</Workspace>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0... SAME CONFIG FOR VERSION..
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<DataStore
> class=3D"org.apache.jackrabbit.core.data.db.DbDataStore">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"driver"
> value=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"url"
> value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"user" value=3D"user1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"password" value=3D"pass1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"databaseType"
> value=3D"sqlserver" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"minRecordLength"
> value=3D"1024" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"maxConnections" value=3D"5"
> />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"copyWhenReading"
> value=3D"true" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"tablePrefix" value=3D"" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"schemaObjectPrefix"
> value=3D"" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</DataStore>
>
>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<Cluster id=3D"node1" syncDelay=3D"2000">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<Journal
> class=3D"org.apache.jackrabbit.core.journal.MSSqlDatabaseJournal">
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"revision"
> value=3D"${rep.home}/revision.log" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"driver"
> value=3D"com.microsoft.sqlserver.jdbc.SQLServerDriver" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"url"
> value=3D"jdbc:sqlserver://localhost:1433;databaseName=3DdHippoCMS " />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"user" value=3D"user1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0<param nam=
e=3D"password" value=3D"pass1" />
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</Journal>
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0</Cluster>
>
> </Repository>
>
>
>
> Thanks for any help in advance.
>
>
>
> Thanks,
>
> Rama Kesara
>
> Software Engineer
>
> Art.com
>
> Phone: (510) 879-4831
>
>
>
>



--=20
Amsterdam - Oosteinde 11, 1017 WT Amsterdam
Boston - 1 Broadway, Cambridge, MA 02142

US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com