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 21:12:20 GMT
Ok. Thanks. I will do that and paste the results here tomorrow.

On Fri, Jun 22, 2012 at 2:31 AM, Mike <mz4wheeler@gmail.com> wrote:

> If you run "iostat -x 5", for about 1 minute, what is the "%util" value?
>
> On Thu, Jun 21, 2012 at 1:53 PM, Deepak Agarwal <dagarwal82@gmail.com
> >wrote:
>
> > Will run it again. Had done it before getting load on mysql.
> >
> > On Fri, Jun 22, 2012 at 2:22 AM, Deepak Agarwal <dagarwal82@gmail.com
> > >wrote:
> >
> > > Yes. All set.
> > >
> > >
> > > On Fri, Jun 22, 2012 at 2:21 AM, Mike <mz4wheeler@gmail.com> wrote:
> > >
> > >> Have you tried the mysql tuning primer script?
> > >>
> > >> https://launchpad.net/mysql-tuning-primer
> > >>
> > >> Download, execute, and double any recommendations.
> > >>
> > >>
> > >> On Thu, Jun 21, 2012 at 1:06 PM, Deepak Agarwal <dagarwal82@gmail.com
> > >> >wrote:
> > >>
> > >> > 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
> > >> >
> > >>
> > >> --
> > >> 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