People wanted to see log and cache stats.
Since it takes a while to generate each one (hours), and the time
increases as the buffer/cache decreases, i'll post them as i generate
them, then make a nice table at the end.
For a 1 meg log buffer/cache, we get:
...
1MB Log record cache size (1048576 bytes).
...
103GB 703MB 879KB 664B Log bytes written (900760 bytes).
...
182430 Total log file writes.
90393 Total log file write due to overflow.
99106 Total log file flushes.
...
65574 Number of log flushes containing a transaction commit.
1MB 64KB Log region size (1114112 bytes).
...
Which is reasonable, but shows that 512, 256, and 32 are probably gonna
hurt quite a bit.
512k, 256k and 32k are still being worked out.
For caches we have so far:
1 meg cache:
1MB 256KB Total cache size (1310720 bytes).
1 Number of caches.
1310720 Pool individual cache size.
89M Requested pages found in the cache (96%).
0 Requested pages mapped into the process' address space.
4052882 Requested pages not found in the cache.
574907 Pages created in the cache.
4052881 Pages read into the cache.
2117285 Pages written from the cache to the backing file.
3217121 Clean pages forced from the cache.
1488688 Dirty pages forced from the cache.
0 Dirty buffers written by trickle-sync thread.
314 Current clean buffer count.
0 Current dirty buffer count.
131 Number of hash buckets used for page location.
98M Total number of times hash chains searched for a page.
9 The longest hash chain searched for a page.
197M Total number of hash buckets examined for page location.
204M The number of region locks granted without waiting.
17 The number of region locks granted after waiting.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: representations
4096 Page size.
1612328 Requested pages found in the cache (100%).
0 Requested pages mapped into the process' address space.
4843 Requested pages not found in the cache.
0 Pages created in the cache.
4843 Pages read into the cache.
5 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: transactions
4096 Page size.
1 Requested pages found in the cache (25%).
0 Requested pages mapped into the process' address space.
3 Requested pages not found in the cache.
0 Pages created in the cache.
3 Pages read into the cache.
4 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: revisions
4096 Page size.
3149 Requested pages found in the cache (82%).
0 Requested pages mapped into the process' address space.
686 Requested pages not found in the cache.
0 Pages created in the cache.
686 Pages read into the cache.
5 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: nodes
4096 Page size.
954663 Requested pages found in the cache (100%).
0 Requested pages mapped into the process' address space.
651 Requested pages not found in the cache.
0 Pages created in the cache.
651 Pages read into the cache.
5 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: strings
4096 Page size.
86M Requested pages found in the cache (96%).
0 Requested pages mapped into the process' address space.
4046699 Requested pages not found in the cache.
574907 Pages created in the cache.
4046698 Pages read into the cache.
2117266 Pages written from the cache to the backing file.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Sat Oct 21 14:37:05 2006