-
1. Re: Performance Cost of valid-connection-checker-class-name
vickyk Apr 16, 2008 9:47 AM (in response to spoulin)"spoulin" wrote:
Does anyone ever benchmarked the overhead of this feature?
No we don't have but it would be interesting to see this with millions of hits .
And don't have it if your DBA guarantees that DB will not be down ever . -
2. Re: Performance Cost of valid-connection-checker-class-name
vaerssv Feb 24, 2009 6:56 AM (in response to spoulin)hello, I've a little bit the same, so i'll not create a new post...
our dba are challenging us because they have millions of validation check hits on their db.
so i'm wondering if there is a way to limit the number of checks ? not removing them completely, but specifying that we want a maximum of one hit every 10 seconds for exemple, not just before every querry... ?
many tanks -
3. Re: Performance Cost of valid-connection-checker-class-name
peterj Feb 24, 2009 11:37 AM (in response to spoulin)Did you write your own validation checker class? If so, you can try putting the timing in there. If you didn't write your own class, you will probably have to.
-
4. Re: Performance Cost of valid-connection-checker-class-name
vaerssv Feb 25, 2009 7:07 AM (in response to spoulin)no we did'nt wrote our own class, we are just using the simple check-valid-connection-sql ...
But i suppose your post means that it is not possible to limit the numbers of check with this simple check-valid-connection-sql?
and so that I'll have to write my own connection checker class... ? -
5. Re: Performance Cost of valid-connection-checker-class-name
vickyk Feb 25, 2009 8:21 AM (in response to spoulin)"vaerssv" wrote:
so i'm wondering if there is a way to limit the number of checks ? not removing them completely, but specifying that we want a maximum of one hit every 10 seconds for exemple, not just before every querry... ?
many tanks
What is the rational of doing such changes, can you explain this in detail?
Yes making the changes in custom implementation of ConnectionChecker will help here but I wanted you to understand clearly about the benefit that would you get by implementing it. -
6. Re: Performance Cost of valid-connection-checker-class-name
vaerssv Feb 25, 2009 8:57 AM (in response to spoulin)in fact we use a simple "select 1 from dual", this causes few load, but the problem is that our dba's see millions of hits on the db, this generate some load that we wants to limit (by executing this query only every x time for exemple)...
i see in the doc:
check-valid-connection-sql : This is a SQL statement that should be run on a connection before it is returned from the pool to test its validity to test for stale pool connections. An example statement could be: select count(*) from x
maybe i don't understand exactly when the querry will be executed, but i suppose it is for every connection to the db... what i would like to have is to use the check-valid-connection not for every connection, but one every 10 seconds, for exemple, that will validate that the db is still reachable and all connection are considered as ok...
don't know if it makes sense? -
7. Re: Performance Cost of valid-connection-checker-class-name
peterj Feb 25, 2009 11:44 AM (in response to spoulin)so that I'll have to write my own connection checker class...
Yes. I would look at extending the existing class that handles the check-valid-connection-sql option. -
8. Re: Performance Cost of valid-connection-checker-class-name
vaerssv Feb 26, 2009 3:32 AM (in response to spoulin)that's realy nice, many thanks in advance !