You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by se...@apache.org on 2016/07/30 00:33:04 UTC
[1/2] incubator-trafodion git commit: [TRAFODION-2134] Change the
overflow_mode to 'DISK' by default
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 5ee3cb396 -> c855e1fe7
[TRAFODION-2134] Change the overflow_mode to 'DISK' by default
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/675017b0
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/675017b0
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/675017b0
Branch: refs/heads/master
Commit: 675017b05dcdeb3e6f3c6768517ffb2091fb482d
Parents: 5cc5945
Author: selvaganesang <se...@esgyn.com>
Authored: Fri Jul 29 04:36:30 2016 +0000
Committer: selvaganesang <se...@esgyn.com>
Committed: Fri Jul 29 04:36:30 2016 +0000
----------------------------------------------------------------------
core/sql/regress/core/EXPECTEDRTS | 32 ++++++++++++++++----------------
core/sql/sqlcomp/nadefaults.cpp | 2 +-
2 files changed, 17 insertions(+), 17 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/675017b0/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index 025145b..c32ce85 100755
--- a/core/sql/regress/core/EXPECTEDRTS
+++ b/core/sql/regress/core/EXPECTEDRTS
@@ -311,7 +311,7 @@ Request Message Count 26
Request Message Bytes 40,176
Reply Message Count 15
Reply Message Bytes 38,952
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -381,7 +381,7 @@ Request Message Count 26
Request Message Bytes 40,176
Reply Message Count 15
Reply Message Bytes 38,952
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -452,7 +452,7 @@ Request Message Count 26
Request Message Bytes 40,176
Reply Message Count 15
Reply Message Bytes 38,952
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -522,7 +522,7 @@ Request Message Count 26
Request Message Bytes 40,176
Reply Message Count 15
Reply Message Bytes 38,952
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2017,7 +2017,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2087,7 +2087,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2149,7 +2149,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2214,7 +2214,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2291,7 +2291,7 @@ TRAFODION.SCH.TSTAT
4 4 4 0 9,490 5,576
Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
--- SQL operation complete.
>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 PROGRESS;
@@ -2351,7 +2351,7 @@ TRAFODION.SCH.TSTAT
4 4 4 0 9,490 5,576
Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
--- SQL operation complete.
>>log;
@@ -2567,7 +2567,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2625,7 +2625,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2698,7 +2698,7 @@ TRAFODION.SCH.TSTAT
4 4 4 0 9,490 5,576
Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
--- SQL operation complete.
>>get statistics for qid current default ;
@@ -2866,7 +2866,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -2927,7 +2927,7 @@ Request Message Count 28
Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
-Scr. Overflow Mode MMAP
+Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
Scr. Buffer Blks Read 0
@@ -3003,7 +3003,7 @@ TRAFODION.SCH.TSTAT
4 4 4 0 9,490 5,576
Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
--- SQL operation complete.
>>set session default statistics_view_type 'pertable' ;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/675017b0/core/sql/sqlcomp/nadefaults.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index 14e274e..25c5672 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -2771,7 +2771,7 @@ SDDkwd__(ISO_MAPPING, (char *)SQLCHARSETSTRING_ISO88591),
DDansi_(OUTPUT_DATE_FORMAT, ""),
// Overflow mode for scratch files
- DDkwd__(OVERFLOW_MODE, "MMAP"),
+ DDkwd__(OVERFLOW_MODE, "DISK"),
// Sequence generator override identity values
DDkwd__(OVERRIDE_GENERATED_IDENTITY_VALUES, "OFF"),
[2/2] incubator-trafodion git commit: Merge [TRAFODION-2134] PR 628
Change the overflow_mode to 'DISK' by default
Posted by se...@apache.org.
Merge [TRAFODION-2134] PR 628 Change the overflow_mode to 'DISK' by default
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/c855e1fe
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/c855e1fe
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/c855e1fe
Branch: refs/heads/master
Commit: c855e1fe744607378202d9a65ec31a40b8f7dd57
Parents: 5ee3cb3 675017b
Author: selvaganesang <se...@apache.org>
Authored: Sat Jul 30 00:32:03 2016 +0000
Committer: selvaganesang <se...@apache.org>
Committed: Sat Jul 30 00:32:03 2016 +0000
----------------------------------------------------------------------
core/sql/regress/core/EXPECTEDRTS | 32 ++++++++++++++++----------------
core/sql/sqlcomp/nadefaults.cpp | 2 +-
2 files changed, 17 insertions(+), 17 deletions(-)
----------------------------------------------------------------------