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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
