Russell Beattie
Posts: 727
Nickname: rbeattie
Registered: Aug, 2003
Russell Beattie is a Mobile Internet Developer
Tomcat 5 Database Pooling with MySQL
Posted: Feb 10, 2004 11:59 PM
This post originated from an RSS feed registered with Java Buzz
by Russell Beattie.
Original Post: Tomcat 5 Database Pooling with MySQL
Feed Title: Russell Beattie Notebook
Feed URL: http://www.russellbeattie.com/notebook/rss.jsp?q=java,code,mobile
Feed Description: My online notebook with thoughts, comments, links and more.
Latest Java Buzz Posts
Latest Java Buzz Posts by Russell Beattie
Latest Posts From Russell Beattie Notebook
Advertisement
Does anyone know what the *hell* I'm doing wrong?
+-----+----------------+-----------+------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+----------------+-----------+------------------+---------+------+-------+------------------+
| 396 | russell_dbuser | www | russell_rbeattie | Sleep | 7029 | | |
| 398 | russell_dbuser | www | mobitopia | Sleep | 5468 | | |
| 399 | russell_dbuser | www | russell_rbeattie | Sleep | 5859 | | |
| 401 | russell_dbuser | www | russell_rbeattie | Sleep | 6764 | | |
| 402 | russell_dbuser | www | russell_rbeattie | Sleep | 5627 | | |
| 409 | russell_dbuser | www | russell_rbeattie | Sleep | 5607 | | |
| 410 | russell_dbuser | www | russell_rbeattie | Sleep | 5670 | | |
| 411 | russell_dbuser | www | russell_rbeattie | Sleep | 2135 | | |
| 412 | russell_dbuser | www | mobitopia | Sleep | 4712 | | |
| 413 | russell_dbuser | www | russell_rbeattie | Sleep | 1037 | | |
| 421 | russell_dbuser | www | russell_rbeattie | Sleep | 5010 | | |
| 423 | russell_dbuser | www | mobitopia | Sleep | 2083 | | |
| 424 | russell_dbuser | www | russell_rbeattie | Sleep | 2946 | | |
| 425 | russell_dbuser | www | russell_rbeattie | Sleep | 1348 | | |
| 426 | russell_dbuser | www | mobitopia | Sleep | 2644 | | |
| 434 | russell_dbuser | www | mobitopia | Sleep | 784 | | |
| 441 | russell_dbuser | www | russell_rbeattie | Sleep | 1740 | | |
| 453 | russell_dbuser | www | russell_rbeattie | Sleep | 1084 | | |
| 462 | russell_dbuser | www | russell_rbeattie | Sleep | 948 | | |
| 463 | russell_dbuser | www | russell_rbeattie | Sleep | 509 | | |
| 473 | russell_dbuser | www | russell_rbeattie | Sleep | 793 | | |
| 477 | russell_dbuser | www | mobitopia | Sleep | 785 | | |
| 478 | russell_dbuser | www | mobitopia | Sleep | 784 | | |
| 479 | russell_dbuser | www | mobitopia | Sleep | 727 | | |
| 480 | russell_dbuser | www | mobitopia | Sleep | 7 | | |
| 481 | russell_dbuser | www | russell_rbeattie | Sleep | 500 | | |
| 490 | russell_dbuser | www | russell_rbeattie | Sleep | 426 | | |
| 491 | russell_dbuser | www | russell_rbeattie | Sleep | 455 | | |
| 508 | russell_dbuser | www | russell_rbeattie | Sleep | 379 | | |
| 510 | russell_dbuser | www | russell_rbeattie | Sleep | 193 | | |
| 511 | russell_dbuser | www | russell_rbeattie | Sleep | 241 | | |
| 519 | russell_dbuser | www | russell_rbeattie | Sleep | 235 | | |
| 521 | russell_dbuser | www | russell_rbeattie | Sleep | 181 | | |
| 522 | russell_dbuser | www | russell_rbeattie | Sleep | 185 | | |
| 523 | russell_dbuser | www | russell_rbeattie | Sleep | 122 | | |
| 524 | russell_dbuser | www | russell_rbeattie | Sleep | 186 | | |
| 525 | russell_dbuser | www | russell_rbeattie | Sleep | 164 | | |
| 540 | russell_dbuser | www | russell_rbeattie | Sleep | 103 | | |
| 541 | russell_dbuser | www | russell_rbeattie | Sleep | 107 | | |
| 542 | russell_dbuser | www | russell_rbeattie | Sleep | 121 | | |
| 543 | russell_dbuser | www | russell_rbeattie | Sleep | 116 | | |
| 545 | russell_dbuser | www | russell_rbeattie | Sleep | 4 | | |
| 546 | russell_dbuser | www | russell_rbeattie | Sleep | 54 | | |
| 552 | root | localhost | | Query | 0 | | show processlist |
+-----+----------------+-----------+------------------+---------+------+-------+------------------+
There should be at most 20 connections and unused connections are supposed to go away after 10 seconds...
Any help would be appreciated on either side of the app to db equasion.
:-)
-Russ
Read: Tomcat 5 Database Pooling with MySQL