Is it possible to set JBOSS/JDBC's MySQL connector to cache the server's settings so that I won't get a big bunch of "show variables" connection all the time?
I think there is a similar settings under Glassfish called CacheServerConfiguration but I was not able to find more information about that under JBOSS.
Does anyone know if this is possible?
Edit: Got it.
Reason for asking this is that, I have been firing around 200 concurrent connections via SOAP to a web service, and in MySQL, I have never seen more than 20 connections being processed at a time.
My MySQL settings are as below: max_connections=1000 max_user_connections=50
MySQL show variables have confirmed that these are the settings in effect, so I am tempted to rule out MySQL.
Any inputs from anyone familiar with JBOSS (EJB) or Tomcat could shed some light on this?
I am trying to run Jmeter to simulate 40k concurrent users and stress test a particular system. Putting aside the possibility that Jmeter may not be able to push such a high number (although I have read that it is at least possible to handle 10k concurrent threads on a very powerful machine), is FreeBSD a more suitable OS as compare to CentOS to be used for my Jmeter machine for handling 40k (or as high as possible) of concurrent outbound connections?
Reason for asking this is that, I have found articles on FreeBSD for tuning and optimizing for maximum outbound connections, but seem to have little luck with CentOS. It makes me wonder if for some specific reasons, people don't use CentOS for such high number of outbound connections. Personally however, I am more familiar with CentOS and would like to stick with it if possible.
In short, I would like to know whether it's a better option to tune FreeBSD for such high number of connections, or if I could achieve the same results with CentOS too?
Any input is greatly appreciated!