Re: Tuning Datasource Connections

2019-08-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jerry, On 8/14/19 23:44, Jerry Malcolm wrote: > I was able to use a global resource and put a in > the default context file for each host. That will work, but you will have to restart Tomcat to make any changes to the . It's not a great solution.

Re: Tuning Datasource Connections

2019-08-14 Thread Jerry Malcolm
On 8/14/2019 6:07 PM, Jerry Malcolm wrote: On 8/14/2019 5:39 PM, Mark Thomas wrote: On 14/08/2019 23:35, Jerry Malcolm wrote: On 8/14/2019 5:26 PM, Mark Thomas wrote: On 14/08/2019 23:09, Jerry Malcolm wrote: In my previous environment, I had a dedicated MySQL install where I could set the

Re: Tuning Datasource Connections

2019-08-14 Thread Jerry Malcolm
On 8/14/2019 5:39 PM, Mark Thomas wrote: On 14/08/2019 23:35, Jerry Malcolm wrote: On 8/14/2019 5:26 PM, Mark Thomas wrote: On 14/08/2019 23:09, Jerry Malcolm wrote: In my previous environment, I had a dedicated MySQL install where I could set the max connections to pretty much anything I wa

Re: Tuning Datasource Connections

2019-08-14 Thread Mark Thomas
On 14/08/2019 23:35, Jerry Malcolm wrote: > On 8/14/2019 5:26 PM, Mark Thomas wrote: >> On 14/08/2019 23:09, Jerry Malcolm wrote: >>> In my previous environment, I had a dedicated MySQL install where I >>> could set the max connections to pretty much anything I wanted. Now I'm >>> moving to AWS whe

Re: Tuning Datasource Connections

2019-08-14 Thread Jerry Malcolm
On 8/14/2019 5:26 PM, Mark Thomas wrote: On 14/08/2019 23:09, Jerry Malcolm wrote: In my previous environment, I had a dedicated MySQL install where I could set the max connections to pretty much anything I wanted. Now I'm moving to AWS where more connections mean a higher charge.  So it's time

Re: Tuning Datasource Connections

2019-08-14 Thread Mark Thomas
On 14/08/2019 23:09, Jerry Malcolm wrote: > In my previous environment, I had a dedicated MySQL install where I > could set the max connections to pretty much anything I wanted. Now I'm > moving to AWS where more connections mean a higher charge.  So it's time > to get real about how many connectio

Tuning Datasource Connections

2019-08-14 Thread Jerry Malcolm
In my previous environment, I had a dedicated MySQL install where I could set the max connections to pretty much anything I wanted. Now I'm moving to AWS where more connections mean a higher charge.  So it's time to get real about how many connections I really need.  BTW, TC 8.5.xx. I 'thought