okay, so, as Romain said, > not a bug, without millis is the dbcp name and with millis the tomcat-jdbc one
you should be fine with the millis (tomcat-jdbc) one. On Fri, Feb 14, 2014 at 2:30 PM, José Luis Cetina <maxtorz...@gmail.com>wrote: > The default value!! > > > 2014-02-14 13:30 GMT-06:00 José Luis Cetina <maxtorz...@gmail.com>: > > > tomcat > > > > > > 2014-02-14 13:24 GMT-06:00 Howard W. Smith, Jr. <smithh032...@gmail.com > >: > > > > José, are you using tomcat-jdbc or dbcp? I thought I saw both mentioned > in > >> this discussion/thread 1 or 2 days ago. > >> > >> > >> On Fri, Feb 14, 2014 at 1:00 PM, José Luis Cetina <maxtorz...@gmail.com > >> >wrote: > >> > >> > Ok > >> > > >> > > >> > 2014-02-14 11:52 GMT-06:00 Romain Manni-Bucau <rmannibu...@gmail.com > >: > >> > > >> > > not a bug, without millis is the dbcp name and with millis the > >> > > tomcat-jdbc one. We just map one on the other for compatibility with > >> > > previous tomee versions. > >> > > 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 18:35 GMT+01:00 José Luis Cetina <maxtorz...@gmail.com>: > >> > > > @Romain the timeBetweenEvictionRuns property is recognized by > >> looking > >> > in > >> > > > jmx, the TimeBetweenEvictionRunsMillis not a bug? > >> > > > > >> > > > > >> > > > 2014-02-14 0:58 GMT-06:00 Romain Manni-Bucau < > rmannibu...@gmail.com > >> >: > >> > > > > >> > > >> 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* > >> > > >> >>> > >> > ------------------------------------------------------------------- > >> > > >> > >> > > > > >> > > > > >> > > > > >> > > > -- > >> > > > > ------------------------------------------------------------------- > >> > > > *José Luis Cetina* > >> > > > > ------------------------------------------------------------------- > >> > > > >> > > >> > > >> > > >> > -- > >> > ------------------------------------------------------------------- > >> > *José Luis Cetina* > >> > ------------------------------------------------------------------- > >> > > >> > > > > > > > > -- > > ------------------------------------------------------------------- > > *José Luis Cetina* > > ------------------------------------------------------------------- > > > > > > -- > ------------------------------------------------------------------- > *José Luis Cetina* > ------------------------------------------------------------------- >
