The default value!!
2014-02-14 13:30 GMT-06:00 José Luis Cetina <[email protected]>: > tomcat > > > 2014-02-14 13:24 GMT-06:00 Howard W. Smith, Jr. <[email protected]>: > > 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* >> > ------------------------------------------------------------------- >> > >> > > > > -- > ------------------------------------------------------------------- > *José Luis Cetina* > ------------------------------------------------------------------- > -- ------------------------------------------------------------------- *José Luis Cetina* -------------------------------------------------------------------
