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 <dagarwa...@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 <mz4whee...@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 <dagarwa...@gmail.com > > >wrote: > > > > > -Xms2048M -Xmx2048M -XX:MaxPermSize=1024m -server > > > > > > On Thu, Jun 21, 2012 at 9:03 PM, Mike <mz4whee...@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 < > dagarwa...@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.agar...@paxcel.net > > Mobile: +91 9910322604 > > > > >