Re: [luciddb-users] Connection limit or something else?

[Jeremy L. <je...@vo...>]

A couple of changes that have been made to the system recently and some
general observation that I should mention:

./bin/lucidDbServer now using params -Xms2048m -Xmx4096m
./binsqllineClient now using params -Xms512m -Xmx5120m
-XX:-UseGCOverheadLimit

I am also continuing to run only one or two instances of ./bin/sqllineClient
concurrently while doing an import to conserve memory.  

With the changes made failures seem to be less frequent but more severe
(i.e. exceptions rather than hangs)

There are concurrent queries originating from the Geronimo database pool,
but expectedConcurrentStatements is still set at 32 and we are never
anywhere near this limit so this does not appear to be an issue.

We are in the last month of Q1.  The larger tables in the system are
partitioned by quarter.  The system seems to run much faster and with less
failures at the beginning of each quarter than it does at the end. Monthly
partitions may help but I am afraid it would hinder query performance when
crossing partitions.  



--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/Connection-limit-or-something-else-tp3122544p6089917.html
Sent from the luciddb-users mailing list archive at Nabble.com.