Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: softfail (nike.apache.org: transitioning domain of
 deepak.agarwal@paxcel.net does not designate 209.85.160.172 as permitted
 sender)
MIME-Version: 1.0
Sender: deepak.agarwal@paxcel.net
In-Reply-To: 
 <CAEHUMyeno=b5Zp-E3abe1mJSc3JsAHo9kMkcAn_026pF9uhTTA@mail.gmail.com>
References: 
 <CAEHUMyda82RhcownO+U0hVrs_DifYdYhro1PeR8SwJaeaZo=xg@mail.gmail.com>
 <CANEMTSL-45tJ5HuH4YR-JVE0BNgzkMMBtadjJw0-3R3TRvoGig@mail.gmail.com>
 <CAEHUMyfhQ9umYUstgihYoZOWsXFQrtWwAzJ9NAKNZoa8gv7g=Q@mail.gmail.com>
 <CANEMTS+mhug=vkZqn2rBwAjD3nHKcT8Gw4VseUA+cJ+LEz6PkQ@mail.gmail.com>
 <CAEHUMydRwgAMyN05C5RU69j2F3rf8V1PU9UDT==yfZUr1roOxQ@mail.gmail.com>
 <CANEMTSLGDBbS5X-H84k0rOZx_=ffUob2jTQkzGPYAFcST64Ysw@mail.gmail.com>
 <CAEHUMydaFZEH+jctpZf+5Cdb+Z9D8x+OGs9nJy7bTvKy8O7dmw@mail.gmail.com>
 <CANEMTSLv-WvBC_nX4vVNreXWkSNXyht8VnEwavokwV8w0cu7Eg@mail.gmail.com>
 <CAEHUMycwk2TFUCuGfWsHeyPA1FxE6MnUrw-cMQA7xacp_zBnvg@mail.gmail.com>
 <CANEMTSJf0=2-97PjF9w=K3AsKVFnXiSeHRztWFf80uN1Hb=Dsg@mail.gmail.com>
 <CAEHUMyf1APAQc0YB54SgEOrfucPTpbGvgTq=iUBPnj2zpd6ojA@mail.gmail.com>
 <CANEMTSJfX76gJn2OZPBfZpVXB6_pAQ=r8qE=189DMk-Yj2C3TA@mail.gmail.com>
 <CAEHUMyeno=b5Zp-E3abe1mJSc3JsAHo9kMkcAn_026pF9uhTTA@mail.gmail.com>
From: Deepak Agarwal <dagarwal82@gmail.com>
Date: Fri, 22 Jun 2012 01:36:37 +0530
Message-ID: 
 <CAEHUMycLkrrVaNFYtXAcDnE8nwN_oxBruBoKtftzhtjW4Wskrw@mail.gmail.com>
Subject: Re: Tables getting locked even for 3-4 users
To: user@ofbiz.apache.org
Content-Type: multipart/alternative; boundary=e89a8f923baad16fae04c3010ea3

--e89a8f923baad16fae04c3010ea3
Content-Type: text/plain; charset=ISO-8859-1

Latest mysql with timestamp truncation problem.

On Fri, Jun 22, 2012 at 1:31 AM, Deepak Agarwal <dagarwal82@gmail.com>wrote:

> mysql latest version.
>
>
> On Fri, Jun 22, 2012 at 1:18 AM, Mike <mz4wheeler@gmail.com> wrote:
>
>> Postgresql/mysql?
>>
>> On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal <dagarwal82@gmail.com
>> >wrote:
>>
>> > I actually did that. But, now I am facing issue while quickly
>> > removing/adding items from/to shopping cart. May be I need to look
>> database
>> > closely.
>> >
>> > On Thu, Jun 21, 2012 at 11:32 PM, Mike <mz4wheeler@gmail.com> wrote:
>> >
>> > > Here is what I would do:
>> > >
>> > > Update framework/webapp/config/serverstats.properties
>> > >
>> > > stats.persist.visit=false
>> > > stats.persist.visitor=false
>> > >
>> > > I have ALL of the 'stats' set to 'false'.
>> > >
>> > > Restart ofbiz, and blow away the contents of server_hit and optionally
>> > > visit:
>> > >
>> > > delete from server_hit;
>> > > delete from visit;
>> > >
>> > > The 'server_hit' is probably your problem.  And, if needed, rebuild
>> the
>> > > indexes of the database.
>> > >
>> > > There is probably another way, or maybe even a service (unknown to me)
>> > that
>> > > may keep these tables tightly trimmed.
>> > >
>> > > On Thu, Jun 21, 2012 at 10:48 AM, Deepak Agarwal <
>> dagarwal82@gmail.com
>> > > >wrote:
>> > >
>> > > > visit: 7400
>> > > > server_hit: 94000
>> > > > communication_event: 51
>> > > >
>> > > > On Thu, Jun 21, 2012 at 10:44 PM, Mike <mz4wheeler@gmail.com>
>> wrote:
>> > > >
>> > > > > Take a look at visit, server_hit, and communication_event tables.
>> > > > >
>> > > > > select count(*) from visit;
>> > > > > select count(*) from server_hit;
>> > > > > select count(*) from communication_event;
>> > > > >
>> > > > > What do yo get?
>> > > > >
>> > > > > On Thu, Jun 21, 2012 at 9:02 AM, Deepak Agarwal <
>> > dagarwal82@gmail.com
>> > > > > >wrote:
>> > > > >
>> > > > > > Alright. I will try this. However, Basically database queries
>> are
>> > > > timing
>> > > > > > out. I checked from 'Show processlist' command and I can see the
>> > > > queries
>> > > > > > are stuck.
>> > > > > >
>> > > > > > On Thu, Jun 21, 2012 at 9:22 PM, Mike <mz4wheeler@gmail.com>
>> > wrote:
>> > > > > >
>> > > > > > > Sounds like classic garbage collection.  Java freezes while it
>> > > sifts
>> > > > > > > through memory looking for stuff to delete.  The larger the
>> > memory,
>> > > > the
>> > > > > > > longer it takes.
>> > > > > > >
>> > > > > > > -Xms2048M -Xmx2048M -server -Xincgc
>> > > > > > >
>> > > > > > > Try the above.  The -Xincgc will continuously GC on a
>> separate,
>> > > slow
>> > > > > > > running thread.  Also, run a separate instance of OFBiz for
>> > > > > > > frontend/back-end, connected to same DB.
>> > > > > > >
>> > > > > > > On Thu, Jun 21, 2012 at 8:47 AM, Deepak Agarwal <
>> > > > dagarwal82@gmail.com
>> > > > > > > >wrote:
>> > > > > > >
>> > > > > > > > Memory and CPU remain good. memory hardly reaches 1 GB and
>> cpu
>> > > few
>> > > > > > > > percentage.
>> > > > > > > >
>> > > > > > > > On Thu, Jun 21, 2012 at 9:14 PM, Mike <mz4wheeler@gmail.com
>> >
>> > > > wrote:
>> > > > > > > >
>> > > > > > > > > What does the "Memory Total" line say on the
>> "WebToosl/Cache
>> > > > > > > Maintenance"
>> > > > > > > > > menu?
>> > > > > > > > >
>> > > > > > > > > On Thu, Jun 21, 2012 at 8:38 AM, Deepak Agarwal <
>> > > > > > dagarwal82@gmail.com
>> > > > > > > > > >wrote:
>> > > > > > > > >
>> > > > > > > > > > -Xms2048M -Xmx2048M -XX:MaxPermSize=1024m -server
>> > > > > > > > > >
>> > > > > > > > > > On Thu, Jun 21, 2012 at 9:03 PM, Mike <
>> > mz4wheeler@gmail.com>
>> > > > > > wrote:
>> > > > > > > > > >
>> > > > > > > > > > > What are the java memory settings for starting OFBiz?
>> > >  Mine:
>> > > > > > > > > > >
>> > > > > > > > > > > JAVA_VMOPTIONS="-Xms1280M -Xmx1524M -server -Xincgc"
>> > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > > > On Thu, Jun 21, 2012 at 8:14 AM, Deepak Agarwal <
>> > > > > > > > dagarwal82@gmail.com
>> > > > > > > > > > > >wrote:
>> > > > > > > > > > >
>> > > > > > > > > > > > We are expereicing frequent table locks for Shipping
>> > > table
>> > > > ,
>> > > > > > > visit
>> > > > > > > > > and
>> > > > > > > > > > > > server_hit table. Even with 3-4 users working we are
>> > > > getting
>> > > > > > > > gateway
>> > > > > > > > > > > > timeout because queries doesn't return . At db
>> level it
>> > > > shows
>> > > > > > > > locked
>> > > > > > > > > > the
>> > > > > > > > > > > > table (and takes 40-50 sec to execute the update
>> > query).
>> > > > > > > > > > > > Servers are multi core, 8GB RAM, 10k RPM harddrive.
>> I
>> > > guess
>> > > > > it
>> > > > > > > is a
>> > > > > > > > > > good
>> > > > > > > > > > > > configuration. All the optimization has been done
>> (like
>> > > > table
>> > > > > > > cache
>> > > > > > > > > > > > increase, cache disable for ofbiz...etc).
>> > > > > > > > > > > >
>> > > > > > > > > > > > Any suggestions? Any body having the same problem ?
>> > > > > > > > > > > >
>> > > > > > > > > > > > --
>> > > > > > > > > > > > Thanks,
>> > > > > > > > > > > > Deepak Agarwal,
>> > > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > > > --
>> > > > > > > > > > > Thanks,
>> > > > > > > > > > > Deepak Agarwal,
>> > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > >
>> > > > > > > > > --
>> > > > > > > > > Thanks,
>> > > > > > > > > Deepak Agarwal,
>> > > > > > > > >
>> > > > > > > > > Paxcel Technologies Pvt Ltd.
>> > > > > > > > > Hartron Complex, Sector 18, Gurgaon, India.
>> > > > > > > > > E-Mail: deepak.agarwal@paxcel.net
>> > > > > > > > > Mobile: +91 9910322604
>> > > > > > > > >
>> > > > > > > > >
>> > > > > > > >
>> > > > > > >
>> > > > > > > --
>> > > > > > > Thanks,
>> > > > > > > Deepak Agarwal,
>> > > > > > >
>> > > > > > > Paxcel Technologies Pvt Ltd.
>> > > > > > > Hartron Complex, Sector 18, Gurgaon, India.
>> > > > > > > E-Mail: deepak.agarwal@paxcel.net
>> > > > > > > Mobile: +91 9910322604
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > >
>> > > > > --
>> > > > > Thanks,
>> > > > > Deepak Agarwal,
>> > > > >
>> > > > > Paxcel Technologies Pvt Ltd.
>> > > > > Hartron Complex, Sector 18, Gurgaon, India.
>> > > > > E-Mail: deepak.agarwal@paxcel.net
>> > > > > Mobile: +91 9910322604
>> > > > >
>> > > > >
>> > > >
>> > >
>> > > --
>> > > Thanks,
>> > > Deepak Agarwal,
>> > >
>> > > Paxcel Technologies Pvt Ltd.
>> > > Hartron Complex, Sector 18, Gurgaon, India.
>> > > E-Mail: deepak.agarwal@paxcel.net
>> > > Mobile: +91 9910322604
>> > >
>> > >
>> >
>>
>> --
>> Thanks,
>> Deepak Agarwal,
>>
>> Paxcel Technologies Pvt Ltd.
>> Hartron Complex, Sector 18, Gurgaon, India.
>> E-Mail: deepak.agarwal@paxcel.net
>> Mobile: +91 9910322604
>>
>>


-- 
Thanks,
Deepak Agarwal,

Paxcel Technologies Pvt Ltd.
Hartron Complex, Sector 18, Gurgaon, India.
E-Mail: deepak.agarwal@paxcel.net
Mobile: +91 9910322604

--e89a8f923baad16fae04c3010ea3--