yes, config are close enough to be understood a single time ;) Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau
2014-02-13 16:34 GMT+01:00 José Luis Cetina <[email protected]>: > Then if tomee use tomcat-pool is this where the info really is? > > https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html not here > http://commons.apache.org/proper/commons-dbcp/configuration.html > > > 2014-02-13 9:32 GMT-06:00 José Luis Cetina <[email protected]>: > >> What about this info in tomee web page >> >> "Internally, from TomEE 1.5.0, JDBC pools are managed via Tomcat-pool. You >> can still switch back to Apache Commons DBCP by adding the following >> property: DataSourceCreator dbcp. To get the full list of available >> configuration properties, have a look to Apache Commons DBCP >> configuration<http://commons.apache.org/dbcp/configuration.html> >> ." >> >> What is the difference between tomcat pool and dbcp, they share the same >> properties? >> >> >> 2014-02-13 9:23 GMT-06:00 Romain Manni-Bucau <[email protected]>: >> >> Hi, >>> >>> some read >>> http://commons.apache.org/proper/commons-dbcp/configuration.html ;) >>> Romain Manni-Bucau >>> Twitter: @rmannibucau >>> Blog: http://rmannibucau.wordpress.com/ >>> LinkedIn: http://fr.linkedin.com/in/rmannibucau >>> Github: https://github.com/rmannibucau >>> >>> >>> >>> 2014-02-13 16:21 GMT+01:00 José Luis Cetina <[email protected]>: >>> > Hi, im having about 180 users at the same time connected to my webapp, >>> > yesterday i got an mysql exception saying "Ton many connections" then i >>> > read in blogs and update the property max_connections in my.cnf to 500 >>> > connections (i have a stand alone server for database only that has >>> 16gb of >>> > ram just for the OS and the DB) then in that post recommend to adjust >>> that >>> > value (max_connections) accord to my pool connection. I use a datasource >>> > resource configured in tomee.xml and i have this >>> > >>> > <Resource id="any" type="DataSource"> >>> > JdbcDriver com.mysql.jdbc.Driver >>> > JdbcUrl ... >>> > UserName xxx >>> > Password xxx >>> > jtaManaged true >>> > initialSize=30 >>> > MaxActive=500 (my old value was 250) >>> > MaxIdle=50 >>> > MaxWait=90000 >>> > MaxWaitTime=90000 >>> > validationQuery=SELECT 1 >>> > testOnBorrow=true >>> > </Resource> >>> > >>> > Then i have this questions: >>> > >>> > 1.What advice can you give me for handle around 180 users that use my >>> app >>> > an hit the database with each action. >>> > I use JSF (@NamedBeans) + EJB (All my EJBS are statless) + 1 SessionBean >>> > (@Named) for each users. >>> > >>> > 2. Which is the difference between MaxIdle and MaxActive? >>> > >>> > 3. Which is the default timeout for close inactive connections and what >>> is >>> > the name of the property? >>> > >>> > >>> > >>> > I will be happy with any kind of advice. >>> > >>> > 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). >>> > >>> > >>> > >>> > >>> > ------------------------------------------------------------------- >>> > *José Luis Cetina* >>> > ------------------------------------------------------------------- >>> >> >> >> >> -- >> ------------------------------------------------------------------- >> *José Luis Cetina* >> ------------------------------------------------------------------- >> > > > > -- > ------------------------------------------------------------------- > *José Luis Cetina* > -------------------------------------------------------------------
