btw you need to monitor active size, idle size etc because number of connection will grow to the max if eviction doesn't work/is not configured Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau
2014-02-14 7:40 GMT+01:00 Romain Manni-Bucau <rmannibu...@gmail.com>: > maybe try timeBetweenEvictionRuns = 30000 > Romain Manni-Bucau > Twitter: @rmannibucau > Blog: http://rmannibucau.wordpress.com/ > LinkedIn: http://fr.linkedin.com/in/rmannibucau > Github: https://github.com/rmannibucau > > > > 2014-02-14 1:14 GMT+01:00 José Luis Cetina <maxtorz...@gmail.com>: >> @Romain i could see in jconsole the value of TimeBetweenEvictionRunsMillis >> is -1 but i have in my tomee.xml >> >> TimeBetweenEvictionRunsMillis=30000 and the value is not get it by the >> Datasource >> >> >> 2014-02-13 18:02 GMT-06:00 Howard W. Smith, Jr. <smithh032...@gmail.com>: >> >>> +1 like!!! :) >>> >>> >>> >>> On Thu, Feb 13, 2014 at 3:42 PM, José Luis Cetina <maxtorz...@gmail.com >>> >wrote: >>> >>> > The apps are running GREAT!! i will share what is my infraestructure: >>> > >>> > 1 Apache Server at front (configure with workers for tomee instances) >>> > 1 Database server with mysql (All the resources are available just for >>> > mysql) >>> > 2 Tomee server for production (they do DB operations to database server, >>> > here i have all the available resource just for TomEE) >>> > 1 Tomee server for testing and jira issue tracker >>> > >>> > All of them running great, my server are intel i5 with 16gb of ram with >>> > debian 6. >>> > >>> > My app is an ear, with 6 webapps and 3 own libraries + 1 ejb module, >>> today >>> > i reach to 450 users from only 1 weeek. The app has more than 650 user's, >>> > by the way the mainly app has only 1 week at the web and is responding >>> > well, the only problem that i had is that the pull get empty, i get that >>> > error just today. From yesterday to today we get just 200 new users and >>> > they are interacting with any other issue. >>> > >>> > What i can see is that the active connections still growing it just time >>> to >>> > reach the limite (500) but im monitoring, i will let you know. >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > 2014-02-13 14:29 GMT-06:00 Howard W. Smith, Jr. <smithh032...@gmail.com >>> >: >>> > >>> > > On Thu, Feb 13, 2014 at 10:21 AM, José Luis Cetina < >>> maxtorz...@gmail.com >>> > > >wrote: >>> > > >>> > > > I use 2 servers with this configuration and tomee and both of them >>> read >>> > > to >>> > > > other server where the database is (2 webapp server + 1 db server). >>> > > > >>> > > >>> > > with your current config, have (180) endusers reported performance >>> > > feedback? web page (database) transactions seems to be fast/responsive, >>> > > no-wait, few seconds wait for most transactions? >>> > > >>> > > when you changed max active from 250 to 500, any better (or different) >>> > > feedback from endusers of your app? >>> > > >>> > > i don't have 180 (concurrent) users (or connections), but i have >>> tweaked >>> > > those jdbc resource settings a few times. I think, my last change was >>> > from >>> > > higher number to lower number, and app performs well. app always >>> > performed >>> > > well, but i don't think i've seen difference in performance when jdbc >>> > > resource settings were tweaked. >>> > > >>> > > there is something that I recognized recently. for some time, there was >>> > one >>> > > page that retrieved data from database via @Stateless, and the data was >>> > not >>> > > the latest-and-greatest data. Recently, I did some transactions in the >>> > app >>> > > (on other pages), and opened that page, and it seems to >>> work-as-expected >>> > > 'now' (finally). I think the latest change to my app was tomee 1.6.1 >>> > > snapshot, but i think it had something to do with @Stateless EJBs and >>> the >>> > > jdbc connections. seem as though app was reusing a pooled connection >>> and >>> > it >>> > > did not get the latest data, but glad it's working as expected now. >>> > > >>> > >>> > >>> > >>> > -- >>> > ------------------------------------------------------------------- >>> > *José Luis Cetina* >>> > ------------------------------------------------------------------- >>> > >>> >> >> >> >> -- >> ------------------------------------------------------------------- >> *José Luis Cetina* >> -------------------------------------------------------------------
