TestPrintConfiguration.golden 1.8 KB
Newer Older
1
online-dsn:
martianzhang's avatar
martianzhang 已提交
2 3 4 5
  addr: 127.0.0.1:3306
  schema: sakila
  user: root
  password: '********'
6
  charset: utf8mb4
martianzhang's avatar
martianzhang 已提交
7
  disable: false
8
test-dsn:
martianzhang's avatar
martianzhang 已提交
9 10 11 12
  addr: 127.0.0.1:3306
  schema: sakila
  user: root
  password: '********'
13
  charset: utf8mb4
martianzhang's avatar
martianzhang 已提交
14 15
  disable: false
allow-online-as-test: true
16 17 18 19
drop-test-temporary: true
cleanup-test-database: false
only-syntax-check: false
sampling-statistic-target: 100
martianzhang's avatar
martianzhang 已提交
20
sampling: true
21 22 23 24 25 26
profiling: false
trace: false
explain: true
conn-time-out: 3
query-time-out: 30
delimiter: ;
martianzhang's avatar
martianzhang 已提交
27 28
log-level: 7
log-output: soar.log
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
report-type: markdown
report-css: ""
report-javascript: ""
report-title: SQL优化分析报告
markdown-extensions: 94
markdown-html-flags: 0
ignore-rules:
- COL.011
rewrite-rules:
- delimiter
- orderbynull
- groupbyconst
- dmlorderby
- having
- star2columns
- insertcolumns
- distinctstar
blacklist: ""
max-join-table-count: 5
max-group-by-cols-count: 5
max-distinct-count: 5
max-index-cols-count: 5
max-total-rows: 9999999
max-query-cost: 9999
spaghetti-query-length: 2048
allow-drop-index: false
max-in-count: 10
max-index-bytes-percolumn: 767
max-index-bytes: 3072
table-allow-charsets:
- utf8
- utf8mb4
table-allow-engines:
- innodb
max-index-count: 10
max-column-count: 40
martianzhang's avatar
martianzhang 已提交
65
max-value-count: 100
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
index-prefix: idx_
unique-key-prefix: uk_
max-subquery-depth: 5
max-varchar-length: 1024
explain-sql-report-type: pretty
explain-type: extended
explain-format: traditional
explain-warn-select-type:
- ""
explain-warn-access-type:
- ALL
explain-max-keys: 3
explain-min-keys: 0
explain-max-rows: 10000
explain-warn-extra:
- Using temporary
- Using filesort
explain-max-filtered: 100
explain-warn-scalability:
- O(n)
show-warnings: false
show-last-query-cost: false
query: ""
list-heuristic-rules: false
list-rewrite-rules: false
list-test-sqls: false
list-report-types: false
martianzhang's avatar
martianzhang 已提交
93
verbose: false
94 95
dry-run: true
max-pretty-sql-length: 1024