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 <[email protected]>wrote: > Ok > > > 2014-02-14 11:52 GMT-06:00 Romain Manni-Bucau <[email protected]>: > > > 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 <[email protected]>: > > > @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 <[email protected]>: > > > > > >> 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 <[email protected]>: > > >> > 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 <[email protected] > >: > > >> >> 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 <[email protected]>: > > >> >>> @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. < > > >> [email protected]>: > > >> >>> > > >> >>>> +1 like!!! :) > > >> >>>> > > >> >>>> > > >> >>>> > > >> >>>> On Thu, Feb 13, 2014 at 3:42 PM, José Luis Cetina < > > >> [email protected] > > >> >>>> >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. < > > >> [email protected] > > >> >>>> >: > > >> >>>> > > > >> >>>> > > On Thu, Feb 13, 2014 at 10:21 AM, José Luis Cetina < > > >> >>>> [email protected] > > >> >>>> > > >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* > ------------------------------------------------------------------- >
