Berkeley DB Family

Here are the answers to the Berkeley DB XML Performance Questionnaire. I hope it will help to diagnose the problem:

1. Describe the Performance area that you are measuring? What is the
current performance? What are your performance goals you hope to
achieve?
We are running into query performance degradation issue. After running for couple days execution time of some queries rises to more then a minute. All queries are pre-compliled.
Re-starting application server brings query performance time back to normal (less then 10 seconds).

2. What Berkeley DB XML Version? Any optional configuration flags
specified? Are you running with any special patches? Please specify?

BDB XML 2.3.10 with patches 1,2,3,4

3. What Berkeley DB Version? Any optional configuration flags
specified? Are you running with any special patches? Please Specify.

Berkeley DB that comes with BDB XML 2.3.10. No special patches

4. Processor name, speed and chipset?

Dual-Core AMD Opteron(tm) Processor 2218, 2600.248 MHz

5. Operating System and Version?

CentOS, Linux version 2.6.9-42.ELsmp (buildcentos@mehak.karan.org)

6. Disk Drive Type and speed?
---

7. File System Type? (such as EXT2, NTFS, Reiser)

EXT2

8. Physical Memory Available?

66Gb of disk space, 4Gb of RAM

9. Are you using Replication (HA) with Berkeley DB XML? If so, please
describe the network you are using, and the number of Replica’s.

NO

10. Are you using a Remote Filesystem (NFS) ? If so, for which
Berkeley DB XML/DB files?

NO

11. What type of mutexes do you have configured? Did you specify
–with-mutex=? Specify what you find inn your config.log, search
for db_cv_mutex?

---

12. Which API are you using (C++, Java, Perl, PHP, Python, other) ?
Which compiler and version?

Using Java API. Javac 1.5.0_11

13. If you are using an Application Server or Web Server, please
provide the name and version?

Using Apache Tomcat 5.5.9

14. Please provide your exact Environment Configuration Flags (include
anything specified in you DB_CONFIG file)

envConfig.setAllowCreate(true);
envConfig.setInitializeCache(true);
envConfig.setCacheSize( 536870912 );
envConfig.setInitializeLocking(true);
envConfig.setLockDetectMode(LockDetectMode.MINWRITE);
envConfig.setInitializeLogging(true);
envConfig.setTransactional(true);
envConfig.setRunRecovery(true);
envConfig.setRegister(true);
envConfig.setMultiversion(true);
envConfig.setMaxLocks( 20000 );
envConfig.setMaxLockObjects( 20000 );
envConfig.setMaxLockers( 20000 );
envConfig.setTxnMaxActive( 131072 );

xmlManagerConfig.setAdoptEnvironment(true);
xmlManagerConfig.setAllowAutoOpen(true);
xmlManagerConfig.setAllowExternalAccess(true);

15. Please provide your Container Configuration Flags?

contConfig.setTransactional(true);
contConfig.setAllowCreate(true);

16. How many XML Containers do you have? For each one please specify:

We have 4 containers

1. The Container Configuration Flags

See 15.

2. How many documents?
Tens of thousands

3. What type (node or wholedoc)?
"node"

4. Please indicate the minimum, maximum and average size of
documents?
Maximum size is 1-2 Mb, average size is about 4 - 10 Kb. There are only a few large documents and they are stored in one collection

5. Are you using document data? If so please describe how?
Querying, updating, adding new documents

17. Please describe the shape of one of your typical documents? Please
do this by sending us a skeleton XML document.

<TagName att="value">
<TagName>tag_value</TagName>
<TagName>
<TagName id="value">
<TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
</TagName>
<TagName>
<TagName>tag_value</TagName>
<TagName att="value">tag_value</TagName>
</TagName>
<TagName att="value">
<TagName att="value">tag_value</TagName>
</TagName>
<TagName>
<TagName>tag_value</TagName>
<TagName/>
</TagName>
<TagName att="value">
<TagName>tag_value</TagName>
<TagName>
<TagName att="value">tag_value</TagName>
</TagName>
<TagName>tag_value</TagName>
<TagName>
<TagName att="value">tag_value</TagName>
</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName att="value">tag_value</TagName>
<TagName att="value">tag_value</TagName>
<TagName type="value"/>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName att="value">tag_value</TagName>
<TagName att="value">
<TagName att="value">
<TagName att="value">tag_value</TagName>
</TagName>
<TagName att="value">
<TagName>tag_value</TagName>
<TagName att="value">tag_value</TagName>
<TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName att="value">tag_value</TagName>
<TagName>
<TagName att="value"/>
<TagName att="value"/>
</TagName>
</TagName>
</TagName>
</TagName>
</TagName>
</TagName>
</TagName>
<TagName att="value">
<TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
<TagName>tag_value</TagName>
</TagName>
</TagName>
</TagName>
</TagName>


18. What is the rate of document insertion/update required or
expected? Are you doing partial node updates (via XmlModify) or
replacing the document?

There are document updates made through XmlModify about once in 10 seconds.

19. What is the query rate required/expected?

Queries are made once a second. There may be several concurrent queires executed.

20. XQuery -- supply some sample queries

Query time degradation happends to various queries in the system, therefore no query plan could be provided. Some collections against which slow queries are executed do have indexes, some don't.

21. Are you running with Transactions? If so please provide any
transactions flags you specify with any API calls.

YES. See 14 and:

txnConfig.setSnapshot(true);

22. If your application is transactional, are your log files stored on
the same disk as your containers/databases?

YES

23. Do you use AUTO_COMMIT?

NO

24. Please list any non-transactional operations performed?

All operations are transactional

25. How many threads of control are running? How many threads in read
only mode? How many threads are updating?

There might be various number of cucurrently running threads of control.
There is always one thread that performs database checkpoint every 5 minutes.

26. Please include a paragraph describing the performance measurements
you have made. Please specifically list any Berkeley DB operations
where the performance is currently insufficient.

After each query its time is output.

27. What performance level do you hope to achieve?

Constant execution time for each query

28. Please send us the output of the following db_stat utility commands
after your application has been running under "normal" load for some
period of time:

***** db_stat -C A -h /opt/db/ *****

Default locking region information:
2416 Last allocated locker ID
0x7fffffff Current maximum unused locker ID
9 Number of lock modes
20000 Maximum number of locks possible
20000 Maximum number of lockers possible
20000 Maximum number of lock objects possible
32 Number of current locks
216 Maximum number of locks at any one time
204 Number of current lockers
214 Maximum number of lockers at any one time
32 Number of current lock objects
151 Maximum number of lock objects at any one time
1019M Total number of locks requested (1019968974)
1019M Total number of locks released (1019968816)
0 Total number of locks upgraded
308 Total number of locks downgraded
494 Lock requests not available due to conflicts, for which we waited
26 Lock requests not available due to conflicts, for which we did not wait
100 Number of deadlocks
0 Lock timeout value
0 Number of locks that have timed out
0 Transaction timeout value
0 Number of transactions that have timed out
10MB 1008KB The size of the lock region
15894 The number of region locks that required waiting (0%)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Lock REGINFO information:
Lock Region type
5 Region ID
/opt/db/__db.005 Region name
0x2ab807a000 Original region address
0x2ab807a000 Region address
0x2ab8b75f00 Region primary address
0 Region maximum allocation
0 Region allocated
REGION_JOIN_OK Region flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Lock region parameters:
131100 Lock region region mutex [15894/1320M 0% 11498/182896240896]
32771 locker table size
32771 object table size
10993256 obj_off
10468912 locker_off
0 need_dd
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Lock conflict matrix:
0 0 0 0 0 0 0 0 0
0 0 1 0 1 0 1 0 1
0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0
0 1 1 0 0 0 0 1 1
0 0 1 0 0 0 0 0 1
0 1 1 0 0 0 0 1 1
0 0 1 0 1 0 1 0 0
0 1 1 0 1 1 1 0 1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Locks grouped by lockers:
Locker Mode Count Status ----------------- Object ---------------
61 dd=209 locks held 1 write locks 0 pid/thread 2563/182894082400
61 READ 1 HELD db/title handle 109658
64 dd=208 locks held 0 write locks 0 pid/thread 2563/182894082400
65 dd=207 locks held 1 write locks 0 pid/thread 2563/182894082400
65 READ 1 HELD db/title handle 116915
68 dd=206 locks held 0 write locks 0 pid/thread 2563/182894082400
69 dd=205 locks held 1 write locks 0 pid/thread 2563/182894082400
69 READ 1 HELD db/title handle 109656
6c dd=204 locks held 0 write locks 0 pid/thread 2563/182894082400
6d dd=203 locks held 1 write locks 0 pid/thread 2563/182894082400
6d READ 1 HELD db/title handle 109660
70 dd=202 locks held 0 write locks 0 pid/thread 2563/1191975264
71 dd=201 locks held 1 write locks 0 pid/thread 2563/182894082400
71 READ 1 HELD db/title handle 109662
74 dd=200 locks held 0 write locks 0 pid/thread 2563/182894082400
75 dd=199 locks held 1 write locks 0 pid/thread 2563/182894082400
75 READ 1 HELD db/title handle 2
78 dd=198 locks held 0 write locks 0 pid/thread 2563/182894082400
7c dd=197 locks held 1 write locks 0 pid/thread 2563/182894082400
7c READ 1 HELD db/title handle 110243
7f dd=196 locks held 0 write locks 0 pid/thread 2563/1191975264
80 dd=195 locks held 1 write locks 0 pid/thread 2563/182894082400
80 READ 1 HELD db/title handle 116913
83 dd=194 locks held 0 write locks 0 pid/thread 2563/182894082400
b1 dd=193 locks held 0 write locks 0 pid/thread 2563/182894082400
b2 dd=192 locks held 1 write locks 0 pid/thread 2563/182894082400
b2 READ 1 HELD db/fat handle 2
b5 dd=191 locks held 0 write locks 0 pid/thread 2563/182894082400
b6 dd=190 locks held 1 write locks 0 pid/thread 2563/182894082400
b6 READ 1 HELD db/fat handle 4
b9 dd=189 locks held 0 write locks 0 pid/thread 2563/182894082400
ba dd=188 locks held 1 write locks 0 pid/thread 2563/182894082400
ba READ 1 HELD db/fat handle 6
bd dd=187 locks held 0 write locks 0 pid/thread 2563/182894082400
be dd=186 locks held 1 write locks 0 pid/thread 2563/182894082400
be READ 1 HELD db/fat handle 8
c1 dd=185 locks held 0 write locks 0 pid/thread 2563/182894082400
c2 dd=184 locks held 1 write locks 0 pid/thread 2563/182894082400
c2 READ 1 HELD db/fat handle 10
c5 dd=183 locks held 0 write locks 0 pid/thread 2563/182894082400
c6 dd=182 locks held 1 write locks 0 pid/thread 2563/182894082400
c6 READ 1 HELD db/fat handle 12
c9 dd=181 locks held 0 write locks 0 pid/thread 2563/182894082400
cd dd=180 locks held 1 write locks 0 pid/thread 2563/182894082400
cd READ 1 HELD db/fat handle 14
d0 dd=179 locks held 0 write locks 0 pid/thread 2563/182894082400
d1 dd=178 locks held 1 write locks 0 pid/thread 2563/182894082400
d1 READ 1 HELD db/fat handle 16
d4 dd=177 locks held 0 write locks 0 pid/thread 2563/182894082400
102 dd=176 locks held 0 write locks 0 pid/thread 2563/182894082400
103 dd=175 locks held 1 write locks 0 pid/thread 2563/182894082400
103 READ 1 HELD db/trade_view/trade_request handle 16787
106 dd=174 locks held 0 write locks 0 pid/thread 2563/182894082400
107 dd=173 locks held 1 write locks 0 pid/thread 2563/182894082400
107 READ 1 HELD db/trade_view/trade_request handle 17908
10a dd=172 locks held 0 write locks 0 pid/thread 2563/182894082400
10b dd=171 locks held 1 write locks 0 pid/thread 2563/182894082400
10b READ 1 HELD db/trade_view/trade_request handle 16785
10e dd=170 locks held 0 write locks 0 pid/thread 2563/182894082400
10f dd=169 locks held 1 write locks 0 pid/thread 2563/182894082400
10f READ 1 HELD db/trade_view/trade_request handle 16789
112 dd=168 locks held 0 write locks 0 pid/thread 2563/182894082400
113 dd=167 locks held 1 write locks 0 pid/thread 2563/182894082400
113 READ 1 HELD db/trade_view/trade_request handle 16791
116 dd=166 locks held 0 write locks 0 pid/thread 2563/182894082400
117 dd=165 locks held 1 write locks 0 pid/thread 2563/182894082400
117 READ 1 HELD db/trade_view/trade_request handle 2
11a dd=164 locks held 0 write locks 0 pid/thread 2563/182894082400
11e dd=163 locks held 1 write locks 0 pid/thread 2563/182894082400
11e READ 1 HELD db/trade_view/trade_request handle 17349
121 dd=162 locks held 0 write locks 0 pid/thread 2563/182894082400
122 dd=161 locks held 1 write locks 0 pid/thread 2563/182894082400
122 READ 1 HELD db/trade_view/trade_request handle 17906
125 dd=160 locks held 0 write locks 0 pid/thread 2563/182894082400
153 dd=159 locks held 0 write locks 0 pid/thread 2563/182894082400
154 dd=158 locks held 1 write locks 0 pid/thread 2563/182894082400
154 READ 1 HELD db/trade_view/title handle 15114
157 dd=157 locks held 0 write locks 0 pid/thread 2563/182894082400
158 dd=156 locks held 1 write locks 0 pid/thread 2563/182894082400
158 READ 1 HELD db/trade_view/title handle 15292
15b dd=155 locks held 0 write locks 0 pid/thread 2563/182894082400
15c dd=154 locks held 1 write locks 0 pid/thread 2563/182894082400
15c READ 1 HELD db/trade_view/title handle 15112
15f dd=153 locks held 0 write locks 0 pid/thread 2563/182894082400
160 dd=152 locks held 1 write locks 0 pid/thread 2563/182894082400
160 READ 1 HELD db/trade_view/title handle 15116
163 dd=151 locks held 0 write locks 0 pid/thread 2563/182894082400
164 dd=150 locks held 1 write locks 0 pid/thread 2563/182894082400
164 READ 1 HELD db/trade_view/title handle 15118
167 dd=149 locks held 0 write locks 0 pid/thread 2563/182894082400
168 dd=148 locks held 1 write locks 0 pid/thread 2563/182894082400
168 READ 1 HELD db/trade_view/title handle 2
16b dd=147 locks held 0 write locks 0 pid/thread 2563/182894082400
16f dd=146 locks held 1 write locks 0 pid/thread 2563/182894082400
16f READ 1 HELD db/trade_view/title handle 15191
172 dd=145 locks held 0 write locks 0 pid/thread 2563/182894082400
173 dd=144 locks held 1 write locks 0 pid/thread 2563/182894082400
173 READ 1 HELD db/trade_view/title handle 15290
176 dd=143 locks held 0 write locks 0 pid/thread 2563/182894082400
1a4 dd=142 locks held 0 write locks 0 pid/thread 2563/182894082400
1a5 dd=141 locks held 0 write locks 0 pid/thread 2563/1191975264
1a6 dd=140 locks held 0 write locks 0 pid/thread 2563/1115130208
1a7 dd=139 locks held 0 write locks 0 pid/thread 2563/1191975264
1a8 dd=138 locks held 0 write locks 0 pid/thread 2563/1191975264
1a9 dd=137 locks held 0 write locks 0 pid/thread 2563/1115130208
1aa dd=136 locks held 0 write locks 0 pid/thread 2563/1101445472
1ab dd=135 locks held 0 write locks 0 pid/thread 2563/1101445472
1ac dd=134 locks held 0 write locks 0 pid/thread 2563/1101445472
1ad dd=133 locks held 0 write locks 0 pid/thread 2563/1115130208
1ae dd=132 locks held 0 write locks 0 pid/thread 2563/1113024864
1af dd=131 locks held 0 write locks 0 pid/thread 2563/1093024096
1b0 dd=130 locks held 0 write locks 0 pid/thread 2563/1113024864
1b1 dd=129 locks held 0 write locks 0 pid/thread 2563/1108814176
1b2 dd=128 locks held 0 write locks 0 pid/thread 2563/1108814176
1b3 dd=127 locks held 0 write locks 0 pid/thread 2563/1115130208
1b4 dd=126 locks held 0 write locks 0 pid/thread 2563/1115130208
1b5 dd=125 locks held 0 write locks 0 pid/thread 2563/1191975264
1b6 dd=124 locks held 0 write locks 0 pid/thread 2563/1191975264
1b7 dd=123 locks held 0 write locks 0 pid/thread 2563/1191975264
1b8 dd=122 locks held 0 write locks 0 pid/thread 2563/1106708832
1b9 dd=121 locks held 0 write locks 0 pid/thread 2563/1106708832
1ce dd=120 locks held 0 write locks 0 pid/thread 2563/1191975264
1cf dd=119 locks held 0 write locks 0 pid/thread 2563/1101445472
1d0 dd=118 locks held 0 write locks 0 pid/thread 2563/1101445472
1d5 dd=117 locks held 0 write locks 0 pid/thread 2563/1111972192
1d6 dd=116 locks held 0 write locks 0 pid/thread 2563/1111972192
1d7 dd=115 locks held 0 write locks 0 pid/thread 2563/1108814176
1d8 dd=114 locks held 0 write locks 0 pid/thread 2563/1105656160
1d9 dd=113 locks held 0 write locks 0 pid/thread 2563/1093024096
1da dd=112 locks held 0 write locks 0 pid/thread 2563/1093024096
1db dd=111 locks held 0 write locks 0 pid/thread 2563/1108814176
1dc dd=110 locks held 0 write locks 0 pid/thread 2563/1105656160
1dd dd=109 locks held 0 write locks 0 pid/thread 2563/1109866848
1de dd=108 locks held 0 write locks 0 pid/thread 2563/1109866848
1f2 dd=107 locks held 0 write locks 0 pid/thread 2563/1099340128
1f3 dd=106 locks held 0 write locks 0 pid/thread 2563/1089866080
1f4 dd=105 locks held 0 write locks 0 pid/thread 2563/1147763040
1f5 dd=104 locks held 0 write locks 0 pid/thread 2563/1093024096
1f6 dd=103 locks held 0 write locks 0 pid/thread 2563/1111972192
1f7 dd=102 locks held 0 write locks 0 pid/thread 2563/1146710368
1f8 dd=101 locks held 0 write locks 0 pid/thread 2563/1146710368
1f9 dd=100 locks held 0 write locks 0 pid/thread 2563/1103550816
1fa dd=99 locks held 0 write locks 0 pid/thread 2563/1091971424
1fb dd=98 locks held 0 write locks 0 pid/thread 2563/1103550816
1fc dd=97 locks held 0 write locks 0 pid/thread 2563/1091971424
1fd dd=96 locks held 0 write locks 0 pid/thread 2563/1091971424
1fe dd=95 locks held 0 write locks 0 pid/thread 2563/1093024096
1ff dd=94 locks held 0 write locks 0 pid/thread 2563/1093024096
200 dd=93 locks held 0 write locks 0 pid/thread 2563/1093024096
201 dd=92 locks held 0 write locks 0 pid/thread 2563/1105656160
202 dd=91 locks held 0 write locks 0 pid/thread 2563/1093024096
203 dd=90 locks held 0 write locks 0 pid/thread 2563/1093024096
204 dd=89 locks held 0 write locks 0 pid/thread 2563/1097234784
205 dd=88 locks held 0 write locks 0 pid/thread 2563/1093024096
206 dd=87 locks held 0 write locks 0 pid/thread 2563/1146710368
207 dd=86 locks held 0 write locks 0 pid/thread 2563/1143552352
208 dd=85 locks held 0 write locks 0 pid/thread 2563/1144605024
209 dd=84 locks held 0 write locks 0 pid/thread 2563/1144605024
20a dd=83 locks held 0 write locks 0 pid/thread 2563/1094076768
20b dd=82 locks held 0 write locks 0 pid/thread 2563/1094076768
20c dd=81 locks held 0 write locks 0 pid/thread 2563/1191975264
20d dd=80 locks held 0 write locks 0 pid/thread 2563/1191975264
233 dd=79 locks held 0 write locks 0 pid/thread 2563/1097234784
234 dd=78 locks held 0 write locks 0 pid/thread 2563/1097234784
235 dd=77 locks held 0 write locks 0 pid/thread 2563/1097234784
25f dd=76 locks held 0 write locks 0 pid/thread 2563/1104603488
272 dd=75 locks held 0 write locks 0 pid/thread 2563/1191975264
273 dd=74 locks held 0 write locks 0 pid/thread 2563/1191975264
379 dd=73 locks held 0 write locks 0 pid/thread 2563/1094076768
3d7 dd=72 locks held 0 write locks 0 pid/thread 2563/1191975264
3d8 dd=71 locks held 0 write locks 0 pid/thread 2563/1191975264
3d9 dd=70 locks held 0 write locks 0 pid/thread 2563/1191975264
3da dd=69 locks held 0 write locks 0 pid/thread 2563/1191975264
3e3 dd=68 locks held 0 write locks 0 pid/thread 2563/1091971424
3e4 dd=67 locks held 0 write locks 0 pid/thread 2563/1091971424
3e5 dd=66 locks held 0 write locks 0 pid/thread 2563/1191975264
3e6 dd=65 locks held 0 write locks 0 pid/thread 2563/1191975264
3e7 dd=64 locks held 0 write locks 0 pid/thread 2563/1191975264
3e8 dd=63 locks held 0 write locks 0 pid/thread 2563/1191975264
3e9 dd=62 locks held 0 write locks 0 pid/thread 2563/1191975264
3ea dd=61 locks held 0 write locks 0 pid/thread 2563/1191975264
3eb dd=60 locks held 0 write locks 0 pid/thread 2563/1191975264
3ec dd=59 locks held 0 write locks 0 pid/thread 2563/1191975264
3ed dd=58 locks held 0 write locks 0 pid/thread 2563/1102498144
3ee dd=57 locks held 0 write locks 0 pid/thread 2563/1102498144
420 dd=56 locks held 0 write locks 0 pid/thread 2563/1091971424
421 dd=55 locks held 0 write locks 0 pid/thread 2563/1091971424
422 dd=54 locks held 0 write locks 0 pid/thread 2563/1191975264
431 dd=53 locks held 0 write locks 0 pid/thread 2563/1103550816
432 dd=52 locks held 0 write locks 0 pid/thread 2563/1103550816
44a dd=51 locks held 0 write locks 0 pid/thread 2563/1110919520
44b dd=50 locks held 0 write locks 0 pid/thread 2563/1141447008
45e dd=49 locks held 0 write locks 0 pid/thread 2563/1113024864
45f dd=48 locks held 0 write locks 0 pid/thread 2563/1093024096
4d4 dd=47 locks held 0 write locks 0 pid/thread 2563/1097234784
4d5 dd=46 locks held 0 write locks 0 pid/thread 2563/1102498144
4d6 dd=45 locks held 0 write locks 0 pid/thread 2563/1102498144
4d7 dd=44 locks held 0 write locks 0 pid/thread 2563/1102498144
4d8 dd=43 locks held 0 write locks 0 pid/thread 2563/1102498144
4d9 dd=42 locks held 0 write locks 0 pid/thread 2563/1102498144
4da dd=41 locks held 0 write locks 0 pid/thread 2563/1149868384
4db dd=40 locks held 0 write locks 0 pid/thread 2563/1111972192
4dc dd=39 locks held 0 write locks 0 pid/thread 2563/1111972192
4dd dd=38 locks held 0 write locks 0 pid/thread 2563/1142499680
4de dd=37 locks held 0 write locks 0 pid/thread 2563/1139341664
4df dd=36 locks held 0 write locks 0 pid/thread 2563/1139341664
4e0 dd=35 locks held 0 write locks 0 pid/thread 2563/1149868384
4e1 dd=34 locks held 0 write locks 0 pid/thread 2563/1140394336
4e2 dd=33 locks held 0 write locks 0 pid/thread 2563/1140394336
4e3 dd=32 locks held 0 write locks 0 pid/thread 2563/1142499680
4e4 dd=31 locks held 0 write locks 0 pid/thread 2563/1142499680
56a dd=30 locks held 0 write locks 0 pid/thread 2563/1191975264
56b dd=29 locks held 0 write locks 0 pid/thread 2563/1106708832
5a6 dd=28 locks held 0 write locks 0 pid/thread 2563/1136183648
5da dd=27 locks held 0 write locks 0 pid/thread 2563/1102498144
5db dd=26 locks held 0 write locks 0 pid/thread 2563/1102498144
5dc dd=25 locks held 0 write locks 0 pid/thread 2563/1102498144
5dd dd=24 locks held 0 write locks 0 pid/thread 2563/1133025632
5de dd=23 locks held 0 write locks 0 pid/thread 2563/1111972192
5df dd=22 locks held 0 write locks 0 pid/thread 2563/1111972192
6ea dd=21 locks held 0 write locks 0 pid/thread 2563/1175132512
6eb dd=20 locks held 0 write locks 0 pid/thread 2563/1130920288
73c dd=19 locks held 0 write locks 0 pid/thread 2563/1174079840
73d dd=18 locks held 0 write locks 0 pid/thread 2563/1171974496
73e dd=17 locks held 0 write locks 0 pid/thread 2563/1171974496
73f dd=16 locks held 0 write locks 0 pid/thread 2563/1129867616
740 dd=15 locks held 0 write locks 0 pid/thread 2563/1129867616
741 dd=14 locks held 0 write locks 0 pid/thread 2563/1174079840
742 dd=13 locks held 0 write locks 0 pid/thread 2563/1162500448
743 dd=12 locks held 0 write locks 0 pid/thread 2563/1162500448
744 dd=11 locks held 0 write locks 0 pid/thread 2563/1160395104
745 dd=10 locks held 0 write locks 0 pid/thread 2563/1162500448
755 dd= 9 locks held 0 write locks 0 pid/thread 2563/1197238624
756 dd= 8 locks held 0 write locks 0 pid/thread 2563/1196185952
757 dd= 7 locks held 0 write locks 0 pid/thread 2563/1156184416
758 dd= 6 locks held 0 write locks 0 pid/thread 2563/1156184416
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Locks grouped by object:
Locker Mode Count Status ----------------- Object ---------------
11e READ 1 HELD db/trade_view/trade_request handle 17349

122 READ 1 HELD db/trade_view/trade_request handle 17906

107 READ 1 HELD db/trade_view/trade_request handle 17908

75 READ 1 HELD db/title handle 2

61 READ 1 HELD db/title handle 109658

69 READ 1 HELD db/title handle 109656

71 READ 1 HELD db/title handle 109662

6d READ 1 HELD db/title handle 109660

7c READ 1 HELD db/title handle 110243

168 READ 1 HELD db/trade_view/title handle 2

117 READ 1 HELD db/trade_view/trade_request handle 2

65 READ 1 HELD db/title handle 116915

80 READ 1 HELD db/title handle 116913

164 READ 1 HELD db/trade_view/title handle 15118

160 READ 1 HELD db/trade_view/title handle 15116

154 READ 1 HELD db/trade_view/title handle 15114

15c READ 1 HELD db/trade_view/title handle 15112

16f READ 1 HELD db/trade_view/title handle 15191

158 READ 1 HELD db/trade_view/title handle 15292

173 READ 1 HELD db/trade_view/title handle 15290

b6 READ 1 HELD db/fat handle 4

ba READ 1 HELD db/fat handle 6

b2 READ 1 HELD db/fat handle 2

c6 READ 1 HELD db/fat handle 12

cd READ 1 HELD db/fat handle 14

be READ 1 HELD db/fat handle 8

c2 READ 1 HELD db/fat handle 10

d1 READ 1 HELD db/fat handle 16

10b READ 1 HELD db/trade_view/trade_request handle 16785

103 READ 1 HELD db/trade_view/trade_request handle 16787

10f READ 1 HELD db/trade_view/trade_request handle 16789

113 READ 1 HELD db/trade_view/trade_request handle 16791


***** db_stat -M A -h /opt/db/ *****

Default cache region information:
512MB Total cache size
1 Number of caches
512MB Pool individual cache size
0 Maximum memory-mapped file size
0 Maximum open file descriptors
0 Maximum sequential buffer writes
0 Sleep after writing maximum sequential buffers
0 Requested pages mapped into the process' address space
1899M Requested pages found in the cache (97%)
50M Requested pages not found in the cache (50062325)
5767606 Pages created in the cache
50M Pages read into the cache (50061174)
5120790 Pages written from the cache to the backing file
45M Clean pages forced from the cache (45488072)
10M Dirty pages forced from the cache (10361909)
0 Dirty pages written by trickle-sync thread
88759 Current total page count
75650 Current clean page count
13109 Current dirty page count
65537 Number of hash buckets used for page location
2005M Total number of times hash chains searched for a page (2005817731)
10 The longest hash chain searched for a page
455M Total number of hash chain entries checked for page (455037828)
654492 The number of hash bucket locks that required waiting (0%)
593054 The maximum number of times any hash bucket lock was waited for (0%)
13M The number of region locks that required waiting (12%)
0 The number of buffers frozen
0 The number of buffers thawed
0 The number of frozen buffers freed
56M The number of page allocations (56626507)
114M The number of hash buckets examined during allocations (114462029)
6768 The maximum number of hash buckets examined for an allocation
56M The number of pages examined during allocations (56891559)
3362 The max number of pages examined for an allocation
351189 Threads waited on page I/O
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
3603204 Requested pages found in the cache (99%)
29621 Requested pages not found in the cache
30769 Pages created in the cache
29620 Pages read into the cache
32675 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
1303 Requested pages found in the cache (99%)
1 Requested pages not found in the cache
24 Pages created in the cache
0 Pages read into the cache
0 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
846365 Requested pages found in the cache (99%)
1 Requested pages not found in the cache
10242 Pages created in the cache
0 Pages read into the cache
147 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
638225 Requested pages found in the cache (99%)
1 Requested pages not found in the cache
7889 Pages created in the cache
0 Pages read into the cache
0 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
23691 Requested pages found in the cache (99%)
1 Requested pages not found in the cache
2 Pages created in the cache
0 Pages read into the cache
0 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
746784 Requested pages found in the cache (99%)
1 Requested pages not found in the cache
4753 Pages created in the cache
0 Pages read into the cache
0 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: temporary
1024 Page size
0 Requested pages mapped into the process' address space
283589 Requested pages found in the cache (99%)
1 Requested pages not found in the cache
797 Pages created in the cache
0 Pages read into the cache
0 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: db/trade_view/trade_request
4096 Page size
0 Requested pages mapped into the process' address space
749M Requested pages found in the cache (99%)
3824742 Requested pages not found in the cache
597 Pages created in the cache
3824742 Pages read into the cache
2165 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: db/fat
8192 Page size
0 Requested pages mapped into the process' address space
10M Requested pages found in the cache (59%)
6922169 Requested pages not found in the cache
1181 Pages created in the cache
6922171 Pages read into the cache
72331 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: db/trade_view/title
4096 Page size
0 Requested pages mapped into the process' address space
118M Requested pages found in the cache (96%)
4907311 Requested pages not found in the cache
2558 Pages created in the cache
4907311 Pages read into the cache
4037 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: db/title
8192 Page size
0 Requested pages mapped into the process' address space
16M Requested pages found in the cache (34%)
29M Requested pages not found in the cache (29773805)
3660 Pages created in the cache
29M Pages read into the cache (29773840)
27648 Pages written from the cache to the backing file
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Mpool REGINFO information:
Mpool Region type
3 Region ID
/opt/db/__db.003 Region name
0x2a98062000 Original region address
0x2a98062000 Region address
0x2ab8061ee0 Region primary address
0 Region maximum allocation
0 Region allocated
REGION_JOIN_OK Region flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MPOOL structure:
3 MPOOL region mutex [13M/91M 12% 11169/182896240896]
0/0 Maximum checkpoint LSN
65537 Hash table entries
20122 Hash table last-checked
1949984477 Hash table LRU count
1955198251 Put counter
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB_MPOOL handle information:
0 DB_MPOOL handle mutex [!Set]
1 Underlying cache regions
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DB_MPOOLFILE structures:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MPOOLFILE structures:
File #1: temporary
131701 Mutex [1/214567 0% !Own]
0 Reference count
445 Block count
30768 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
62 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #2: temporary
131676 Mutex [0/83 0% !Own]
0 Reference count
13 Block count
23 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
64 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #3: temporary
131368 Mutex [0/38763 0% !Own]
0 Reference count
2352 Block count
10241 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
66 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #4: temporary
131714 Mutex [0/27270 0% !Own]
0 Reference count
4286 Block count
7888 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
6a 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #5: temporary
131367 Mutex [0/6 0% !Own]
0 Reference count
2 Block count
1 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
6c 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #6: temporary
131314 Mutex [0/14280 0% !Own]
0 Reference count
4732 Block count
4752 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
6e 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #7: temporary
131633 Mutex [0/2446 0% !Own]
0 Reference count
742 Block count
796 Last page number
0 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
6f 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ID
deadfile, file written Flags
File #8: db/trade_view/trade_request
131117 Mutex [12/11M 0% !Own]
8 Reference count
23638 Block count
23701 Last page number
23104 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
10 c0 6e 0 2 8 0 0 c6 9d 73 ff 3e 9 0 0 0 0 0 0 ID
file written Flags
File #9: db/fat
131127 Mutex [69/21M 0% !Own]
8 Reference count
19330 Block count
50907 Last page number
49726 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
5 80 6a 0 2 8 0 0 97 ee ba cd 28 c4 1 0 0 0 0 0 ID
file written Flags
File #10: db/trade_view/title
131107 Mutex [10/14M 0% !Own]
8 Reference count
23785 Block count
39073 Last page number
36515 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
f c0 6e 0 2 8 0 0 29 17 2d 9c 39 9 0 0 0 0 0 0 ID
file written Flags
File #11: db/title
131137 Mutex [1072/89M 0% !Own]
8 Reference count
9434 Block count
214832 Last page number
211172 Original last page number
0 Maximum page number
0 Type
0 Priority
0 Page's LSN offset
32 Page's clear length
ab 10 64 0 2 8 0 0 ef 74 96 e2 b7 41 0 0 0 0 0 0 ID
file written Flags
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


29. Are there any other significant applications running on this
system? Are you using Berkeley DB outside of Berkeley DB XML?
Please describe the application?

NO

Thank you,
Basil