TestPrintConfiguration.golden 2.4 KB
Newer Older
1
online-dsn:
2 3
  user: root
  password: '********'
4
  net: tcp
martianzhang's avatar
martianzhang 已提交
5 6
  addr: 127.0.0.1:3306
  schema: sakila
7
  charset: utf8
martianzhang's avatar
martianzhang 已提交
8
  collation: utf8mb4_general_ci
9 10 11
  loc: UTC
  tls: ""
  server-public-key: ""
12
  max-allowed-packet: 4194304
13 14
  params:
    charset: utf8
martianzhang's avatar
fix #98  
martianzhang 已提交
15 16 17
  timeout: 3s
  read-timeout: 0s
  write-timeout: 0s
18 19 20
  allow-native-passwords: true
  allow-old-passwords: false
  disable: false
21
test-dsn:
22 23
  user: root
  password: '********'
24
  net: tcp
martianzhang's avatar
martianzhang 已提交
25 26
  addr: 127.0.0.1:3306
  schema: sakila
27
  charset: utf8
martianzhang's avatar
martianzhang 已提交
28
  collation: utf8mb4_general_ci
29 30 31
  loc: UTC
  tls: ""
  server-public-key: ""
32
  max-allowed-packet: 4194304
33 34
  params:
    charset: utf8
martianzhang's avatar
fix #98  
martianzhang 已提交
35 36 37
  timeout: 3s
  read-timeout: 0s
  write-timeout: 0s
38 39 40
  allow-native-passwords: true
  allow-old-passwords: false
  disable: false
martianzhang's avatar
martianzhang 已提交
41
allow-online-as-test: true
42
disable-version-check: false
43 44 45 46
drop-test-temporary: true
cleanup-test-database: false
only-syntax-check: false
sampling-statistic-target: 100
martianzhang's avatar
martianzhang 已提交
47
sampling: true
48
sampling-condition: ""
49 50 51 52
profiling: false
trace: false
explain: true
delimiter: ;
martianzhang's avatar
martianzhang 已提交
53 54
log-level: 7
log-output: soar.log
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
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
L
liipx 已提交
77
max-text-cols-count: 2
78 79 80 81 82 83 84
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 已提交
85
allow-charsets:
86 87
- utf8
- utf8mb4
martianzhang's avatar
martianzhang 已提交
88 89
allow-collates: []
allow-engines:
90 91 92
- innodb
max-index-count: 10
max-column-count: 40
martianzhang's avatar
martianzhang 已提交
93
max-value-count: 100
94 95 96 97
index-prefix: idx_
unique-key-prefix: uk_
max-subquery-depth: 5
max-varchar-length: 1024
98
column-not-allow-type:
99 100
- json
- text
101
- boolean
L
liipx 已提交
102
min-cardinality: 0
103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125
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 已提交
126
verbose: false
127 128
dry-run: true
max-pretty-sql-length: 1024