tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: configuration of db
Date Tue, 09 Apr 2013 14:11:00 GMT
-----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


Mime
View raw message