[opencms-dev] OpenCMS hangs under heavy load

[Mark Belanger]

Andras Balogh wrote:
> Have you optimized Tomcat with -Xmx -Xms to have more memory?

Here are the flags we're currently using:

java
  -server
  -XX:NewSize=96m
  -XX:MaxNewSize=96m
  -Xms384m
  -Xmx384m
  -XX:+UseConcMarkSweepGC
  -XX:+UseParNewGC
  -XX:+CMSParallelRemarkEnabled
  -XX:CMSInitiatingOccupancyFraction=60
  -Dfile.encoding=ISO-8859-1

> How many SQL connections are allowed?

Here are the relevant MySQL settings:

  skip-locking
  skip-bdb
  log-bin
  max_connections         = 200
  key_buffer              = 32M
  max_allowed_packet      = 20M
  net_buffer_length       = 8K
  table_cache             = 128
  myisam_sort_buffer_size = 32M
  sort_buffer_size        = 8M
  read_buffer_size        = 2M
  query_cache_size        = 32M
  query_cache_limit       = 2M
  query_cache_type        = 1

> If you do a "show processlist" in mysql console how many
> processes(connections) do you see?

Twenty-seven, excluding the one from the console.

> Also what helped is nightly auto restart of Tomcat.

Sadly, that's the conclusion we're coming to, though it pains me to 
implement such a hack.  OpenCMS must really tickle a nasty bug in Java 
as we've never seen this on other projects.

Thanks for all the advice and interest.


-MB
-- 
_______________________________________________________________________
Mark Belanger - belanger at fluid.com