1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
#!/usr/bin/env python
#
# Public Domain 2014-present MongoDB, Inc.
# Public Domain 2008-2014 WiredTiger, Inc.
#
# This is free and unencumbered software released into the public domain.
#
# Anyone is free to copy, modify, publish, use, compile, sell, or
# distribute this software, either in source code form or as a compiled
# binary, for any purpose, commercial or non-commercial, and by any
# means.
#
# In jurisdictions that recognize copyright laws, the author or authors
# of this software dedicate any and all copyright interest in the
# software to the public domain. We make this dedication for the benefit
# of the public at large and to the detriment of our heirs and
# successors. We intend this dedication to be an overt act of
# relinquishment in perpetuity of all present and future rights to this
# software under copyright law.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
# IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
# OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
# ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
# OTHER DEALINGS IN THE SOFTWARE.
import os
from unittest import skip
import wiredtiger, wttest
# test_stat08.py
# Session statistics for bytes read into the cache.
class test_stat08(wttest.WiredTigerTestCase):
nentries = 100000
# Leave the cache size on the default setting to avoid filling up the cache
# too much and triggering unnecessary rollbacks.
conn_config = 'statistics=(all)'
entry_value = "abcde" * 40
BYTES_READ = wiredtiger.stat.session.bytes_read
READ_TIME = wiredtiger.stat.session.read_time
session_stats = { BYTES_READ : "session: bytes read into cache", \
READ_TIME : "session: page read from disk to cache time (usecs)"}
def get_stat(self, stat):
statc = self.session.open_cursor('statistics:session', None, None)
val = statc[stat][2]
statc.close()
return val
def check_stats(self, cur, k):
#
# Some Windows machines lack the time granularity to detect microseconds.
# Skip the time check on Windows.
#
if os.name == "nt" and k is self.READ_TIME:
return
exp_desc = self.session_stats[k]
cur.set_key(k)
cur.search()
[desc, pvalue, value] = cur.get_values()
self.pr(' stat: \'%s\', \'%s\', \'%s\'' % (desc, pvalue, str(value)))
self.assertEqual(desc, exp_desc)
if k is self.BYTES_READ or k is self.READ_TIME:
self.assertTrue(value > 0)
def test_session_stats(self):
# We want to configure for pages to be explicitly evicted when we are done with them so
# that we can correctly verify the statistic measuring bytes read from cache.
self.session = self.conn.open_session("debug=(release_evict_page=true)")
self.session.create("table:test_stat08", "key_format=i,value_format=S")
cursor = self.session.open_cursor('table:test_stat08', None, None)
self.session.begin_transaction()
txn_dirty = self.get_stat(wiredtiger.stat.session.txn_bytes_dirty)
self.assertEqual(txn_dirty, 0)
# Write the entries.
for i in range(0, self.nentries):
cursor[i] = self.entry_value
# Since we're using an explicit transaction, we need to commit somewhat frequently.
# So check the statistics and commit/restart the transaction every 200 operations.
if i % 200 == 0:
txn_dirty = self.get_stat(wiredtiger.stat.session.txn_bytes_dirty)
self.assertNotEqual(txn_dirty, 0)
self.session.commit_transaction()
self.session.begin_transaction()
txn_dirty = self.get_stat(wiredtiger.stat.session.txn_bytes_dirty)
self.assertEqual(txn_dirty, 0)
self.session.commit_transaction()
cursor.reset()
# Read the entries.
i = 0
for key, value in cursor:
i = i + 1
cursor.reset()
# Now check the session statistics for bytes read into the cache.
stat_cur = self.session.open_cursor('statistics:session', None, None)
for k in self.session_stats:
self.check_stats(stat_cur, k)
# Session stats cursor reset should set all the stats values to zero.
stat_cur.reset()
while stat_cur.next() == 0:
[desc, pvalue, value] = stat_cur.get_values()
self.assertTrue(value == 0)
if __name__ == '__main__':
wttest.run()
|