Skip to content

Latest commit

 

History

History
28 lines (20 loc) · 1.59 KB

README.md

File metadata and controls

28 lines (20 loc) · 1.59 KB
Raw

Commons-DBCP-monitoring

Monitor what threads are using connections from the DBCP pool, and waiting for connection. Generate a nice table to understand what is happening.

Usage:

  1. Replace your application's commons-dbcp-1.4.jar with commons-dbcp-1.4-monitored.jar (rename it to pretend it is really the same JAR file)
  2. Run your application, making sure the output is directed to a log file
  3. When you want, generate a graph:
    1. Run: ./generate-dbcp-graph.sh <your-output-file.log>
    2. Wait while dbcp-connected-by-thread.csv and dbcp-waiting-by-thread.csv are generated.
    3. Open the CSV files with any spreadsheet program (like LibreOffice) and use conditional formatting to end up with the table below. To create the graph below, create a SUM column for each CSV and use your spreadsheet program's graphing feature.

Threads using connections Combined using/waiting graph

Compilation:

  1. Download the Commons DBCP 1.4 source code
  2. Uncompress it.
  3. Copy all files from the patch-for-commons-dbcp-1.4-src directory to into the uncompressed directory
  4. Run Ant

This product includes software developed by The Apache Software Foundation (http://www.apache.org/).