-
1. Re: JBOSS 3.2.6RC2 mySQL performance issues
starksm64 Oct 8, 2004 1:51 PM (in response to tsnoke)What profiling of the sql pages has been done either via logging or with a profiler?
-
2. Re: JBOSS 3.2.6RC2 mySQL performance issues
tsnoke Oct 8, 2004 2:17 PM (in response to tsnoke)We haven't done any profiling, this was working in 3.2.1 just fine.
The only change is running it under 3.2.6RC2.
If profiling would help, I am not sure where to go with this... but if you could point me at a FAQ for setting it up and I will post the results.
Thanks for looking at this,
Timur -
3. Re: JBOSS 3.2.6RC2 mySQL performance issues
starksm64 Oct 8, 2004 2:48 PM (in response to tsnoke)Go get a profiler. The following one is easy to use with jboss:
http://www.yourkit.com/download/index.jsp
Otherwise enable trace level logging of the org.jboss category in the log4j.xml file and be sure to include the thread id using the %t option so that you can identify where the time in a request is spent. -
4. Re: JBOSS 3.2.6RC2 mySQL performance issues
genman Oct 8, 2004 3:06 PM (in response to tsnoke)
The JBoss profiler is pretty good too, if you can get it working.
Refer to
http://sourceforge.net/cvs/?group_id=22866
This should work:
$ cvs -z3 -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/jboss co jboss-profiler
Take a look at readme.txt -
5. Re: JBOSS 3.2.6RC2 mySQL performance issues
tsnoke Oct 12, 2004 12:50 PM (in response to tsnoke)This was very instructive, by looking at the traces we found a problem with our mySQL keep alive...
instead of an "are you there" we were asking for a complete dump of the DB.
so now we are trying to continue to squeeze every last bit of performance out of this solution, playing with the acceptCount and the maxProcessors to try to get the most robust results. Is there a best practice for setting these numbers? we want to be able to handle 100K+ users an hour.
Thanks in Advance,
-Timur