-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
