ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Agarwal <dagarwa...@gmail.com>
Subject Re: Tables getting locked even for 3-4 users
Date Thu, 21 Jun 2012 20:06:37 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message