[jboss-user] [Performance Tuning] - Re: JBoss Performance Problems with SPECjAppServer2004

[Frank.Feinbube]

I tried the following configuration:

mysql-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
  | 
  | <datasources>
  |   <xa-datasource>
  |     <jndi-name>DefaultDS</jndi-name>
  | 	
  |     <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
  |     <xa-datasource-property name="URL">jdbc:mysql://DBHost/specj</xa-datasource-property>
  | 	<xa-datasource-property name="User">specj2004</xa-datasource-property>
  | 	<xa-datasource-property name="Password">*****</xa-datasource-property>
  |     
  | 	<track-connection-by-tx>true</track-connection-by-tx>
  | 	<no-tx-separate-pools>true</no-tx-separate-pools>
  | 
  | 	
  |     <min-pool-size>20</min-pool-size>
  |     <max-pool-size>20</max-pool-size>
  | 
  |     <blocking-timeout-millis>15001</blocking-timeout-millis>
  |     <idle-timeout-minutes>15</idle-timeout-minutes>
  | 
  | 	<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
  | 
  |     <metadata>
  |        <type-mapping>mySQL</type-mapping>
  |     </metadata>
  |   </xa-datasource>
  | 
  |   <xa-datasource>
  |     <jndi-name>SpecjDS_RC</jndi-name>
  | 	
  | 	<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
  |     <xa-datasource-property name="URL">jdbc:mysql://DBHost/specj</xa-datasource-property>
  | 	<xa-datasource-property name="User">specj2004</xa-datasource-property>
  | 	<xa-datasource-property name="Password">*****</xa-datasource-property>
  | 
  | 	<track-connection-by-tx>true</track-connection-by-tx>
  | 	<no-tx-separate-pools>true</no-tx-separate-pools>
  | 	
  |     <min-pool-size>320</min-pool-size>
  |     <max-pool-size>320</max-pool-size>
  | 	
  |     <prepared-statement-cache-size>512</prepared-statement-cache-size>
  | 
  |     <blocking-timeout-millis>60002</blocking-timeout-millis>
  |     <idle-timeout-minutes>90</idle-timeout-minutes>
  | 
  | 	<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
  | 
  |     <metadata>
  |        <type-mapping>mySQL</type-mapping>
  |     </metadata>
  |   </xa-datasource>
  | 
  |   <no-tx-datasource>
  |     <jndi-name>SpecjJMSDS</jndi-name>
  |     <connection-url>jdbc:mysql://DBHost/jms</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>jbossjms</user-name>
  |     <password>*****</password>
  | 
  |     <min-pool-size>20</min-pool-size>
  |     <max-pool-size>20</max-pool-size>
  | 
  |     <prepared-statement-cache-size>512</prepared-statement-cache-size>
  | 
  |     <blocking-timeout-millis>60003</blocking-timeout-millis>
  |     <idle-timeout-minutes>15</idle-timeout-minutes>
  | 
  |     <metadata>
  |        <type-mapping>mySQL</type-mapping>
  |     </metadata>
  | 
  |   </no-tx-datasource>
  | 
  | </datasources>

my.ini
[client]
  | port=3306
  | 
  | [mysql]
  | default-character-set=latin1
  | 
  | [mysqld]
  | max_connections=800
  | thread_cache_size=38
  | 
  | port=3306
  | lower_case_table_names = 1
  | sql-mode = IGNORE_SPACE
  | basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
  | datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
  | default-character-set=latin1
  | default-storage-engine=INNODB
  | query_cache_size=84M
  | table_cache=1520
  | tmp_table_size=30M
  | 
  | myisam_max_sort_file_size=100G
  | myisam_sort_buffer_size=30M
  | key_buffer_size=129M
  | read_buffer_size=64K
  | read_rnd_buffer_size=256K
  | sort_buffer_size=256K
  | 
  | 
  | #*** INNODB Specific options ***
  | innodb_additional_mem_pool_size=6M
  | innodb_flush_log_at_trx_commit=1
  | innodb_log_buffer_size=3M
  | innodb_buffer_pool_size=250M
  | innodb_log_file_size=50M
  | innodb_thread_concurrency=8
  | 

This should work for an Injectionrate of 40. But I got lots of errors.

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4224235#4224235

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4224235