Jboss and PostgresSQL Tuning for Muthoot ERP Environment - Revision history

Amit at 05:58, 22 January 2015

2015-01-22T05:58:05Z

@@ Line 79: / Line 79: @@
   JAVA_OPTS="'''-Xms12288m -Xmx12288m ''' -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"
-Updated On 20th Jan 2015 (By Amit Srivastava)
+Updated On 22th Jan 2015 (By Amit Srivastava)
   JAVA_OPTS="'''-Xms12288m -Xmx12288m -XX:MaxPermSize=512m''' -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"
@@ Line 87: / Line 87: @@
   ps -ef | grep java
-Page Compression (server.xml) in the connecter class
+Page Compression & Connection timeout and pool (server.xml) in the connecter class
-  URIEncoding="UTF-8" connectionTimeout="20000" compression="on" compressableMimeType="text/html,text/xml,text/plain,text/css,application/x-javascript,application/xml,application/javascript,application/json,application/xhtml+xml"
+  <!-- A HTTP/1.1 Connector on port 8080 -->
   Ref URL: http://imeji.org/install/server-setup/

Amit at 10:17, 20 January 2015

2015-01-20T10:17:31Z

← Older revision		Revision as of 10:17, 20 January 2015
Line 90:		Line 90:

	URIEncoding="UTF-8" connectionTimeout="20000" compression="on" compressableMimeType="text/html,text/xml,text/plain,text/css,application/x-javascript,application/xml,application/javascript,application/json,application/xhtml+xml"		URIEncoding="UTF-8" connectionTimeout="20000" compression="on" compressableMimeType="text/html,text/xml,text/plain,text/css,application/x-javascript,application/xml,application/javascript,application/json,application/xhtml+xml"

			Ref URL: http://imeji.org/install/server-setup/

Amit at 10:13, 20 January 2015

2015-01-20T10:13:57Z

← Older revision		Revision as of 10:13, 20 January 2015
Line 77:		Line 77:

	# JAVA_OPTS="-Xms128m -Xmx512m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"		# JAVA_OPTS="-Xms128m -Xmx512m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"
	JAVA_OPTS="'''-Xms12288m -Xmx12288m''' -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"		JAVA_OPTS="'''-Xms12288m -Xmx12288m ''' -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

			Updated On 20th Jan 2015 (By Amit Srivastava)

			JAVA_OPTS="'''-Xms12288m -Xmx12288m -XX:MaxPermSize=512m''' -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

	Test via		Test via

	ps -ef \| grep java		ps -ef \| grep java

			Page Compression (server.xml) in the connecter class

			URIEncoding="UTF-8" connectionTimeout="20000" compression="on" compressableMimeType="text/html,text/xml,text/plain,text/css,application/x-javascript,application/xml,application/javascript,application/json,application/xhtml+xml"

Biswajit: /* PostgreSQL Tuning and Process */

2013-08-12T11:26:48Z

PostgreSQL Tuning and Process

@@ Line 27: / Line 27: @@
 Check the difference between the created "post-pgtune.conf.sample" and Current "/var/lib/pgsql/data/postgresql.conf"
 diff post-pgtune.conf.sample /var/lib/pgsql/data/postgresql.conf
 As Muthoot Environment is on Redhat Cluster suite , check the cluster status via

Biswajit: /* JBOSS Tuning and Process */

2013-08-12T11:21:17Z

JBOSS Tuning and Process

← Older revision		Revision as of 11:21, 12 August 2013
Line 61:		Line 61:

	# JAVA_OPTS="-Xms128m -Xmx512m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"		# JAVA_OPTS="-Xms128m -Xmx512m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"
	JAVA_OPTS="-Xms12288m -Xmx12288m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"		JAVA_OPTS="'''-Xms12288m -Xmx12288m''' -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

	Test via		Test via

	ps -ef \| grep java		ps -ef \| grep java

Biswajit: /* PostgreSQL Tuning and Process */

2013-08-12T11:20:20Z

PostgreSQL Tuning and Process

← Older revision		Revision as of 11:20, 12 August 2013
Line 22:		Line 22:
	yum install pgtune		yum install pgtune

	Create a ~~Smaple config~~ file based on current environment		Create a Sample configuration file based on current environment

	pgtune -i /var/lib/pgsql/data/postgresql.conf -o post-pgtune.conf.sample		pgtune -i /var/lib/pgsql/data/postgresql.conf -o post-pgtune.conf.sample
Line 49:		Line 49:
	clustat		clustat
	ps -ef \| grep postgre		ps -ef \| grep postgre



	== JBOSS Tuning and Process ==		== JBOSS Tuning and Process ==

Biswajit: Created page with "category:Tetra Clients category:Muthoot group '''Objective :''' Tuning of Jboss (192.168.1.129) and PostgreSQl (Cluster- 192.168.1.140) for Muthoot Group '''Issue..."

2013-08-12T11:19:34Z

Created page with "category:Tetra Clients category:Muthoot group '''Objective :''' Tuning of Jboss (192.168.1.129) and PostgreSQl (Cluster- 192.168.1.140) for Muthoot Group '''Issue..."

New page

[[category:Tetra Clients]]
[[category:Muthoot group]]

'''Objective :''' Tuning of Jboss (192.168.1.129) and PostgreSQl (Cluster- 192.168.1.140) for Muthoot Group

'''Issue :''' long Report from Application makes the JBOSS Server to hung and Finally we have restart the server . The Long report was not coming even after 1+ hours .

'''Approach :'''

# Tune postgreSql to use high available memory
# Tune JBOSS to use high available memory

== PostgreSQL Tuning and Process ==

Install '''pgtune''' rpm package

yum install pgtune

Create a Smaple config file based on current environment

pgtune -i /var/lib/pgsql/data/postgresql.conf -o post-pgtune.conf.sample

Check the difference between the created "post-pgtune.conf.sample" and Current "/var/lib/pgsql/data/postgresql.conf"
diff post-pgtune.conf.sample /var/lib/pgsql/data/postgresql.conf

As Muthoot Environment is on Redhat Cluster suite , check the cluster status via

clustat

Stop the Cluster Services , which will bring down the postgresql too

clusvcadm -s Cluster-Service
cd /var/lib/pgsql/data/
chown postgres.postgres post-pgtune.conf.sample
cp -pvr postgresql.conf postgresql.conf.org_backedup_on_25_july_2013
cp -pvr post-pgtune.conf.sample postgresql.conf

Start the cluster so that PostgreSQL will start along

clusvcadm -R Cluster-Service

Test the environment

clustat
ps -ef | grep postgre

== JBOSS Tuning and Process ==

The Ram allocated to Jboss was less so needs to increase

Open the Jboss's run.conf file

vi /usr/bin/jboss-6.0.0.Final/bin/run.conf

Modify the old to new as shown below

# JAVA_OPTS="-Xms128m -Xmx512m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"
JAVA_OPTS="-Xms12288m -Xmx12288m -XX:MaxPermSize=256m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

Test via

ps -ef | grep java