5 Replies Latest reply on Oct 12, 2004 12:50 PM by Timur Snoke

    JBOSS 3.2.6RC2 mySQL performance issues

    Timur Snoke Newbie

      Hello,

      We are trying to move our production environment application from JBoss 3.2.1 to 3.2.6RC2 to take advantage of Tomcat 5, et.al.

      We are using a two server configuration with JBoss/Tomcat running on one and a mySQL running on the other.

      The old config used:
      JBoss 3.2.1
      Java SDK 1.4.2_05
      Red Hat Enterprise Server ES 3.0 Update 3
      MySQL 4.0.21

      The new config uses:
      JBoss 3.2.6RC2
      Java SDK 1.4.2_05
      Red Hat Enterprise Server ES 3.0 Update 3
      MySQL 4.0.21

      We have an identical config for both 3.2.1 and 3.2.6RC2 on a robust server and we have developed a stress test that goes through a strictly defined process of accessing a series of webpages to emulate a user. some of the pages are exlusively on the JBoss server and some require sql calls to the other server. A single thread is a process composed of 12 tests that includes 3 sql calls. In our testing we instantiate 50 threads simultaneously and watch the stats on each test: mean time per thread, mean threads per second, max threads per second.

      when we run stress tests we find that simple web acesses are much faster in 3.2.6RC2 (2 or 3 times), but every page that makes a database query, to the different server, is much slower (3 to 6 times).

      our overall transactions per second is droped to 1/3 the volume that 3.2.1 can handle in a 15 minute period.

      what can we do to troubleshoot the mysql integration into 3.2.6RC2, we want to take advantage of tomcat5, and 3.2.1 has performance issues that develop in longer stress tests.

      thanks in advance,

      Timur