TestPrintConfiguration.golden 1.9 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
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
martianzhang's avatar
martianzhang 已提交
58
allow-charsets:
59 60
- utf8
- utf8mb4
martianzhang's avatar
martianzhang 已提交
61 62
allow-collates: []
allow-engines:
63 64 65
- innodb
max-index-count: 10
max-column-count: 40
martianzhang's avatar
martianzhang 已提交
66
max-value-count: 100
67 68 69 70
index-prefix: idx_
unique-key-prefix: uk_
max-subquery-depth: 5
max-varchar-length: 1024
71 72
column-not-allow-type:
- boolean
73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
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 已提交
96
verbose: false
97 98
dry-run: true
max-pretty-sql-length: 1024