-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Steve,
On 6/4/20 16:59, Sanders, Steve wrote: > I'm working with an application team that wishes to set the > timeBetweenEvictionRunsMillis setting of their database connection > pool to a very low setting - 20ms. Hah! Sorry. Continue... > According to the documentation > (https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html), this > setting should never be set below 1000ms, so I'm weary to allow > this. Their claim is that application performance is poor when set > to our default of 2000ms. To me this indicates that there is a bug > in the application itself not closing connections after it is done > with them and have to wait for an idle connection to be created by > the pool, causing the performance lag. My experience suggests that you are right. > I'm curious if this advice in the documentation is given based on > performance concerns or if there is some other underlying issue > that could present itself if this setting is below 1000 ms? With a 20ms eviction run, you are going to be thrashing the CPU with that thread. Sure, the CPU can handle many context-switches in a short amount of time, but evicting lost database connections isn't something that really should be done /aggressively/ IMO. - -chris -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl7ZakEACgkQHPApP6U8 pFg1iQ/+MlwIaZJFVH7J8TQhvC5WOLg6VX4kkcRg9Jm8RYcz+OugkUPKN/p0MGdf +4U67pAqYFr0aoy/baXkcWsa1EwBnodIKZqZieR3L2PyN2t4GrnCBwX/9wSyZOAC IdzWAA9Jdg0jcFtIy0Erjib8TABYx1a8SxlFYLS4evyb9Ep1rBvQa+Rw/Uy3fSqo IHBuB3HZKfRMtUU69PPreXJkFq3WuS9rw2vKvGa4cOb6bCTTfmH4+tvSlFYfdrU4 SDtBXZuHGKe1nThR8WbSjxNa0rgGjV6L5FjhfcdtVYeJ1XCTOpEY9ilWIxwm4RIP uA8ZVXqV0jBCRoRb3U6uRVLxUghKCSgmvyrsn0TSeTiU4ipdSNfi1emPqxl3wgbX Gclw4sT6uIIqZx061OdKnQETYBLB++g0+lX+h82CsK+U0Ul1UACWsdkfiz2AU+EG rJSYjg2ZXjraeXj0hiKGrlwZ8V5BZIvIYp7O/UfM3mSG+UUYQPOmBcKDA6Z24up6 5VlmCoDWqlMNqHWyLDamifeNYAlytyrnGKwdhJczfoGpBjFynxmGFjBReargn2Xv fWFxLV0d03pr2FYJq5S4C0xgyPmkAwbTM7FxAYg383tlUCXHR5aes1Dxx/OIkCRz e9goRYTI1R5g2YlrV4RmApQqZ+1FTyuo9d3jwvGLdq0QSH0Fagc= =rdBH -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
