You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by aishani <ni...@gmail.com> on 2013/04/07 12:58:02 UTC
configuration of db
SIR WHEN MORE THAN 15 DB CONNECTION CROSSED TOMCAT GIVES AN ERROR MESSAGE
THAT TOO MANY SQL CONNECTION. I AM USING TOMCAT 5.X WITH MYSQL.HOW CAN I
CONFIGURE TOMCAT FOR EXECUTING MANY DB CONNECTION?
Re: configuration of db
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
David,
On 4/7/13 11:58 AM, David Kerber wrote:
> On 4/7/2013 11:32 AM, aishani wrote:
>> SIR WHEN I RE-START MY STARTUP BAT FILE AGAIN DB CONNECTION
>> ESTABLISHED. PLEASE GUIDE ME WHAT I HAVE TO CONFIGURE IN MQSQL.
>>
>> THANKS
>
> Please don't top-post.
>
> I can't help you with mySQL; I've never used it. Do some research
> through your favorite search engine to find how to set the maximum
> number of simultaneous connections in mySQL.
By default, MySQL does not have any per-user connection limit. One can
check to see if a user has a maximum connection limit like this:
mysql> SELECT * FROM mysql.user WHERE user=''\G
There are a few columns with max_* that indicate the maximums for
these things.
One can also do this:
mysql> SHOW VARIABLES LIKE 'max%';
You'll get results like this:
+----------------------------+----------------------+
| Variable_name | Value |
+----------------------------+----------------------+
| ........ | |
| max_connections | 151 |
| ........ | |
| max_user_connections | 0 |
| ........ | |
+----------------------------+----------------------+
If the OP would care to share the actual error message, perhaps we can
give better help. For example, this could be a MySQL connection-limit
issue, or it could be a connection-pool exhaustion error.
In either case, a likely scenario is that the webapp has a connection
leak that needs to be fixed.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBCAAGBQJRZCFzAAoJEBzwKT+lPKRY7WIP+gOpoqjwACvVbL3gXgeop7Xo
PyfbljZKsCSsyjZJS2pqkRx01Tcdvafj7Dov4HfmSrnXajma5WOgrTL6rAf/LXvb
elsEWlaSbG01p/+BgYqyL/pT7EQtOOoJ0m4t5/ijkL46TPGD+tvD/GFZRE4B4paO
IOUv3mJBeZInAgCo9qBGFRcOwQh9qtEHC91BcHREWmRqMX2S71FyhnHIDUE+gdIQ
chC2BvvYyuXIE9t+h5Zxx3AemFXTTjMjAVNIYfS60b3yqB2UofE/U9zts3ws+VvL
1FpgjyGrtKDOIMj/fik4coXs+Bj/4wdR0yJbjgPjeWNHNWvdrCD1M7HsKMTnPzWT
c8aO6H+PN2aDrrnhFGV1p0/vuvXOStvXCITzt/bv/H/9kt3k9SjuidbsjJ+nVstG
mipWPtqugbcXtwmNGzneLym/Vkjc1h2nhrRJDIYUBRlr+LjwcaOT5POQ2Q/3Ic7+
4jbQsDF35O5T10un/pFQdZzw1QXhB6it984di1TqCYcKhtVXs1HsJ04R9cee978t
lbPxh234NR6xpsre5SBTqRf4+65h7MIae3iRytt1c4SaKKuQlx0ClwSTSNi8FG6B
7SGh/caceZRzql7ySDFV4DPUqDLyhl8HwENGc/FWeONR9XA4UjxY13EVpXDZPqtr
P4P2ZohjfCpDaInnr2KF
=r1Ex
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: configuration of db
Posted by David Kerber <dc...@verizon.net>.
On 4/7/2013 11:32 AM, aishani wrote:
> SIR WHEN I RE-START MY STARTUP BAT FILE AGAIN DB CONNECTION ESTABLISHED.
> PLEASE GUIDE ME WHAT I HAVE TO CONFIGURE IN MQSQL.
>
> THANKS
Please don't top-post.
I can't help you with mySQL; I've never used it. Do some research
through your favorite search engine to find how to set the maximum
number of simultaneous connections in mySQL.
>
>
>
> -----Original Message-----
> From: David Kerber [mailto:dckerber@verizon.net]
> Sent: Sunday, April 07, 2013 5:25 PM
> To: users@tomcat.apache.org
> Subject: Re: configuration of db
>
> On 4/7/2013 6:58 AM, aishani wrote:
>> SIR WHEN MORE THAN 15 DB CONNECTION CROSSED TOMCAT GIVES AN ERROR
>> MESSAGE THAT TOO MANY SQL CONNECTION. I AM USING TOMCAT 5.X WITH
>> MYSQL.HOW CAN I CONFIGURE TOMCAT FOR EXECUTING MANY DB CONNECTION?
>>
>>
>
> That error is almost certainly coming from MySQL, not tomcat. Verify that
> you have mySQL configured to accept as many connections as you need.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: configuration of db
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Aishani,
On 4/7/13 11:32 AM, aishani wrote:
> SIR WHEN I RE-START MY STARTUP BAT FILE AGAIN DB CONNECTION
> ESTABLISHED. PLEASE GUIDE ME WHAT I HAVE TO CONFIGURE IN MQSQL.
What have you tried so far? Please post your existing configuration.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBCAAGBQJRYZYMAAoJEBzwKT+lPKRYN6IP/1FmwjzkVP5jc588PDCboJYe
Fii2fJFnZRpFOEIuOUcfkaKqVEum+p6IQMrC0MVVa+8wTpIeyX6GKAw2zwf6m5g9
0kxwFW5ztFOK53tZ5CQiTkv7MDfDU2nqfA33J8MF4X4qwgWT7g1NyPhmDBPlJsru
gLTD5cF0zhDBG0yGz8Vopj6yWLX3MAt22vLhA3NXjy5AjUdfzeIy2WWrPyvpDYBj
nhkRFRflK7msBwDGGw53LBBnFoyiRDZQCiJ+FdbHIbZU1vYMCAsrbuj7Z7ZZs4Ux
rSiRehHqIeYCBjJGTPfzEQDqd7ulw/yTfLZD4exgMMjN11MftSlFWDSoWL1aUXQT
9catzqN7QUscCSFtAfOq6k2D0iZzYCXuTfjXVubgJHt7S2s5qyZWxuT5HUb0jjeJ
m3YDAQuPQ420WKEamv94QSw0GuY5axGuAAYEOdVE2PXOqosdgd6NW2R/wpF0MiDr
b9KPNbJV8b4FBeS2NTE0ab8nR1Ll3xcJFuZXi+tImoaPRMo6RQT3ShIWNNcpmkNg
MM1lBm7IS5zVUHtTPGdaPNCSgVIGBNZszsVCBJK/saVaxtXYvClmFb4/YaOaaLrH
r0C8uEugXDTfBkiF2z5x2fhtioo0uoyRRtcbVmgkGkI9KcI1tLFcrSJxDskv8Q6H
oYbvHjWIwCIyQAYkH76i
=txkB
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: configuration of db
Posted by aishani <ni...@gmail.com>.
SIR WHEN I RE-START MY STARTUP BAT FILE AGAIN DB CONNECTION ESTABLISHED.
PLEASE GUIDE ME WHAT I HAVE TO CONFIGURE IN MQSQL.
THANKS
-----Original Message-----
From: David Kerber [mailto:dckerber@verizon.net]
Sent: Sunday, April 07, 2013 5:25 PM
To: users@tomcat.apache.org
Subject: Re: configuration of db
On 4/7/2013 6:58 AM, aishani wrote:
> SIR WHEN MORE THAN 15 DB CONNECTION CROSSED TOMCAT GIVES AN ERROR
> MESSAGE THAT TOO MANY SQL CONNECTION. I AM USING TOMCAT 5.X WITH
> MYSQL.HOW CAN I CONFIGURE TOMCAT FOR EXECUTING MANY DB CONNECTION?
>
>
That error is almost certainly coming from MySQL, not tomcat. Verify that
you have mySQL configured to accept as many connections as you need.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: configuration of db
Posted by David Kerber <dc...@verizon.net>.
On 4/7/2013 6:58 AM, aishani wrote:
> SIR WHEN MORE THAN 15 DB CONNECTION CROSSED TOMCAT GIVES AN ERROR MESSAGE
> THAT TOO MANY SQL CONNECTION. I AM USING TOMCAT 5.X WITH MYSQL.HOW CAN I
> CONFIGURE TOMCAT FOR EXECUTING MANY DB CONNECTION?
>
>
That error is almost certainly coming from MySQL, not tomcat. Verify
that you have mySQL configured to accept as many connections as you need.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org