Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Red Hat This forum is for the discussion of Red Hat Linux.


  Search this Thread
Old 01-17-2004, 05:55 AM   #1
LQ Newbie
Registered: Nov 2003
Posts: 19

Rep: Reputation: 0
mysql connections

hi i am using redhat 9. its my webserver,where jsp runs on tomcat and i use mysql database, i often see that even though if nobody uses the server in the network the mysql threads are over 30 and the opens are over 20000, my users use mysqlcc to modify and create records, what might be the problem.
Old 01-17-2004, 07:39 AM   #2
Registered: Jan 2004
Distribution: Debian and Gentoo
Posts: 39

Rep: Reputation: 15
If you use database connection pooling in tomcat, there will always be some connections to the database as they are kept in the pool. 30 seems a little too much though. You may want to check the tomcat settings for minimum and maximum numbers of open connections and set it to something lower if appropriate.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
2000 MySQL connections, still "too many connections" newlinuxnewbie Linux - General 0 11-07-2005 01:03 PM
Increase MySQL Connections On FC2 br00tal Linux - Software 1 06-28-2005 07:45 AM
Bash and mysql connections. tia24 Linux - Newbie 1 04-13-2004 01:15 PM
MySQL too many connections problem NetScripter Linux - Software 0 12-10-2003 02:36 AM
MySQL connections from got me baffled! sewer_monkey Linux - General 0 02-20-2003 05:47 PM > Forums > Linux Forums > Linux - Distributions > Red Hat

All times are GMT -5. The time now is 04:06 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration