PS2: in jmx operation of the datasource you have purge to force reset, if it works it is ok and just an idle config which is not the one you expect (tested on rest-example of tomee examples) 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:46 GMT+01:00 Romain Manni-Bucau <rmannibu...@gmail.com>: > 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* >>> -------------------------------------------------------------------
