index.md 38.3 KB
Newer Older
1 2 3 4 5 6 7 8 9
---
title: Configuration Parameters
description: "Configuration parameters for client and server in TDengine"
---

## Configuration File on Server Side

On the server side, the actual service of TDengine is provided by an executable `taosd` whose parameters can be configured in file `taos.cfg` to meet the requirements of different use cases. The default location of `taos.cfg` is `/etc/taos`, but can be changed by using `-c` parameter on the CLI of `taosd`. For example, the configuration file can be put under `/home/user` and used like below

D
danielclow 已提交
10
```
11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
taosd -c /home/user
```

Parameter `-C` can be used on the CLI of `taosd` to show its configuration, like below:

```
taosd -C
```

## Configuration File on Client Side

TDengine CLI `taos` is the tool for users to interact with TDengine. It can share same configuration file as `taosd` or use a separate configuration file. When launching `taos`, parameter `-c` can be used to specify the location where its configuration file is. For example `taos -c /home/cfg` means `/home/cfg/taos.cfg` will be used. If `-c` is not used, the default location of the configuration file is `/etc/taos`. For more details please use `taos --help` to get.

```bash
taos -C
```

```bash
taos --dump-config
```

# Configuration Parameters

D
danielclow 已提交
34 35 36 37 38
:::note
The parameters described in this document by the effect that they have on the system.

:::

39 40 41 42 43 44 45 46 47
:::note
`taosd` needs to be restarted for the parameters changed in the configuration file to take effect.

:::

## Connection Parameters

### firstEp

D
danielclow 已提交
48 49 50
| Attribute     | Description                            |
| -------- | -------------------------------------------------------------- |
| Applicable | Server and Client                                           |
51
| Meaning       | The end point of the first dnode in the cluster to be connected to when `taosd` or `taos` is started |
D
danielclow 已提交
52
| Default   | localhost:6030                                                 |
53 54 55

### secondEp

D
danielclow 已提交
56 57 58
| Attribute     | Description                                                                                  |
| -------- | ------------------------------------------------------------------------------------- |
| Applicable | Server and Client                                           |
59
| Meaning       | The end point of the second dnode to be connected to if the firstEp is not available when `taosd` or `taos` is started |
D
danielclow 已提交
60
| Default   | None                                                                                    |
61 62 63 64 65 66 67

### fqdn

| Attribute     | Description                                                              |
| ------------- | ------------------------------------------------------------------------ |
| Applicable    | Server Only                                                              |
| Meaning       | The FQDN of the host where `taosd` will be started. It can be IP address |
D
danielclow 已提交
68 69
| Default Value | The first hostname configured for the host                             |
| Note          | It should be within 96 bytes                                             |                        |
70 71 72

### serverPort

D
danielclow 已提交
73 74 75
| Attribute     | Description                                                              |
| -------- | ----------------------------------------------------------------------------------------------------------------------- |
| Applicable    | Server Only                                                              |
76 77 78 79
| Meaning       | The port for external access after `taosd` is started                                                                           |
| Default Value | 6030                                                                                                                            |

:::note
D
danielclow 已提交
80
- Ensure that your firewall rules do not block TCP port 6042  on any host in the cluster. Below table describes the ports used by TDengine in details.
81 82 83
:::
| Protocol | Default Port | Description                                      | How to configure                                                                               |
| :------- | :----------- | :----------------------------------------------- | :--------------------------------------------------------------------------------------------- |
D
danielclow 已提交
84
| TCP | 6030 | Communication between client and server. In a multi-node cluster, communication between nodes. serverPort |
85
| TCP      | 6041         | REST connection between client and server        | Prior to 2.4.0.0: serverPort+11; After 2.4.0.0 refer to [taosAdapter](/reference/taosadapter/) |
D
danielclow 已提交
86 87 88 89
| TCP      | 6043         | Service Port of TaosKeeper                       | The parameter of TaosKeeper |
| TCP      | 6044         | Data access port for StatsD                      | Configurable through taosAdapter parameters.
| UDP      | 6045         | Data access for statsd                           | Configurable through taosAdapter parameters.
| TCP      | 6060         | Port of Monitoring Service in Enterprise version | |
90 91 92 93 94 95 96 97 98 99

### maxShellConns

| Attribute     | Description                                          |
| ------------- | ---------------------------------------------------- |
| Applicable    | Server Only                                          |
| Meaning       | The maximum number of connections a dnode can accept |
| Value Range   | 10-50000000                                          |
| Default Value | 5000                                                 |

D
danielclow 已提交
100
## Monitoring Parameters
101

D
danielclow 已提交
102
### monitor
103

D
danielclow 已提交
104 105 106 107 108 109
| Attribute     | Description                                                                                                                                                                                               |
| -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Applicable | Server only                                           |
| Meaning       | The switch for monitoring inside server. The main object of monitoring is to collect information about load on physical nodes, including CPU usage, memory usage, disk usage, and network bandwidth. Monitoring information is sent over HTTP to the taosKeeper service specified by `monitorFqdn` and `monitorProt`.
| Value Range   | 0: monitoring disabled, 1: monitoring enabled                                                                                                                                                                |
| Default   | 1                                                                                                                                                                                                  |
110

D
danielclow 已提交
111
### monitorFqdn
112

D
danielclow 已提交
113 114 115 116 117
| Attribute     | Description                                                    |
| -------- | -------------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | FQDN of taosKeeper monitoring service |
| Default   | None                                                                                    |
118

D
danielclow 已提交
119
### monitorPort
120

D
danielclow 已提交
121 122 123 124 125
| Attribute     | Description                            |
| -------- | --------------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Port of taosKeeper monitoring service |
| Default Value | 6043                                                               |
126 127 128

### monitorInterval

D
danielclow 已提交
129 130 131
| Attribute     | Description                                                                                                                                                                         |
| -------- | -------------------------------------------- |
| Applicable    | Server Only                                                                                                                                                                         |
132 133
| Meaning       | The interval of collecting system workload |
| Unit          | second                                     |
D
danielclow 已提交
134 135
| Value Range | 1-200000                                     |
| Default Value | 30                                                                                                                                                                                   |
136 137 138

### telemetryReporting

D
danielclow 已提交
139 140 141
| Attribute     | Description                                                                                                                                                                         |
| -------- | ---------------------------------------- |
| Applicable    | Server Only                                                                                                                                                                         |
142 143
| Meaning       | Switch for allowing TDengine to collect and report service usage information |
| Value Range   | 0: Not allowed; 1: Allowed                                                   |
D
danielclow 已提交
144
| Default Value | 1                                                                                                                                                                                   |
145 146 147

## Query Parameters

D
danielclow 已提交
148
### queryPolicy
149

D
danielclow 已提交
150 151 152 153 154 155 156
| Attribute     | Description                          |
| -------- | ----------------------------- |
| Applicable | Client only                                           |
| Meaning     | Execution policy for query statements            |
| Unit     | None                            |
| Default   | 1                             |
| Notes | 1: Run queries on vnodes and not on qnodes |
157

D
danielclow 已提交
158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
2: Run subtasks without scan operators on qnodes and subtasks with scan operators on vnodes.

3: Only run scan operators on vnodes; run all other operators on qnodes.

### querySmaOptimize

| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable | Client only                                           |
| 含义     | SMA index optimization policy |
| Unit     | None                            |
| Default Value | 0                                                 |
| Notes |

0: Disable SMA indexing and perform all queries on non-indexed data.

1: Enable SMA indexing and perform queries from suitable statements on precomputation results.|
175 176 177 178


### maxNumOfDistinctRes

D
danielclow 已提交
179 180 181
| Attribute     | Description                                                                                                                                                                         |
| -------- | -------------------------------- | --- |
| Applicable    | Server Only                                                                                                                                                                         |
182
| Meaning       | The maximum number of distinct rows returned |
S
Sean Ely 已提交
183 184
| Value Range   | [100,000 - 100,000,000]                      |
| Default Value | 100,000                                      |
185 186 187 188 189

## Locale Parameters

### timezone

D
danielclow 已提交
190 191 192
| Attribute     | Description                                                                                                                                                                         |
| -------- | ------------------------------ |
| Applicable    | Server and Client                                                                                                      |
193 194 195 196
| Meaning       | TimeZone                        |
| Default Value | TimeZone configured in the host |

:::info
D
danielclow 已提交
197
To handle the data insertion and data query from multiple timezones, Unix Timestamp is used and stored in TDengine. The timestamp generated from any timezones at same time is same in Unix timestamp. Note that Unix timestamps are converted and recorded on the client side. To make sure the time on client side can be converted to Unix timestamp correctly, the timezone must be set properly.
198

D
danielclow 已提交
199
On Linux system, TDengine clients automatically obtain timezone from the host. Alternatively, the timezone can be configured explicitly in configuration file `taos.cfg` like below. For example:
200 201

```
D
danielclow 已提交
202
timezone UTC-8
203 204 205 206 207 208
timezone GMT-8
timezone Asia/Shanghai
```

The above examples are all proper configuration for the timezone of UTC+8. On Windows system, however, `timezone Asia/Shanghai` is not supported, it must be set as `timezone UTC-8`.

209
The setting for timezone impacts strings that are not in Unix timestamp format and keywords or functions related to date/time. For example:
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226

```sql
SELECT count(*) FROM table_name WHERE TS<'2019-04-11 12:01:08';
```

If the timezone is UTC+8, the above SQL statement is equal to:

```sql
SELECT count(*) FROM table_name WHERE TS<1554955268000;
```

If the timezone is UTC, it's equal to

```sql
SELECT count(*) FROM table_name WHERE TS<1554984068000;
```

227
To avoid the problems of using time strings, Unix timestamp can be used directly. Furthermore, time strings with timezone can be used in SQL statements. For example "2013-04-12T15:52:01.123+08:00" in RFC3339 format or "2013-04-12T15:52:01.123+0800" in ISO-8601 format are not influenced by timezone setting when converted to Unix timestamp.
228 229 230 231 232 233 234 235 236 237 238 239

:::

### locale

| Attribute     | Description               |
| ------------- | ------------------------- |
| Applicable    | Server and Client         |
| Meaning       | Location code             |
| Default Value | Locale configured in host |

:::info
D
danielclow 已提交
240
A specific type "nchar" is provided in TDengine to store non-ASCII characters such as Chinese, Japanese, and Korean. The characters to be stored in nchar type are firstly encoded in UCS4-LE before sending to server side. Note that the correct encoding is determined by the user. To store non-ASCII characters correctly, the encoding format of the client side needs to be set properly.
241 242 243

The characters input on the client side are encoded using the default system encoding, which is UTF-8 on Linux, or GB18030 or GBK on some systems in Chinese, POSIX in docker, CP936 on Windows in Chinese. The encoding of the operating system in use must be set correctly so that the characters in nchar type can be converted to UCS4-LE.

D
danielclow 已提交
244
The locale definition standard on Linux is: <Language\>\_<Region\>.<charset\>, for example, in "zh_CN.UTF-8", "zh" means Chinese, "CN" means China mainland, "UTF-8" means charset. The charset indicates how to display the characters. On Linux and Mac OSX, the charset can be set by locale in the system. On Windows system another configuration parameter `charset` must be used to configure charset because the locale used on Windows is not POSIX standard. Of course, `charset` can also be used on Linux to specify the charset.
245 246 247 248 249 250 251 252 253 254 255 256

:::

### charset

| Attribute     | Description               |
| ------------- | ------------------------- |
| Applicable    | Server and Client         |
| Meaning       | Character                 |
| Default Value | charset set in the system |

:::info
D
danielclow 已提交
257 258 259
On Linux, if `charset` is not set in `taos.cfg`, when `taos` is started, the charset is obtained from system locale. If obtaining charset from system locale fails, `taos` would fail to start.

So on Linux system, if system locale is set properly, it's not necessary to set `charset` in `taos.cfg`. For example:
260 261 262 263 264

```
locale zh_CN.UTF-8
```

D
danielclow 已提交
265 266 267 268 269 270 271 272
On Windows system, it's not possible to obtain charset from system locale. If it's not set in configuration file `taos.cfg`, it would be default to CP936, same as set as below in `taos.cfg`. For example

```
charset CP936
```

Refer to the documentation for your operating system before changing the charset.

273
On a Linux system, if the charset contained in `locale` is not consistent with that set by `charset`, the later setting in the configuration file takes precedence.
274

D
danielclow 已提交
275
```
276 277 278 279
locale zh_CN.UTF-8
charset GBK
```

D
danielclow 已提交
280 281 282
The charset that takes effect is GBK.

```
283 284 285 286
charset GBK
locale zh_CN.UTF-8
```

D
danielclow 已提交
287
The charset that takes effect is UTF-8.
288 289 290 291 292 293 294

:::

## Storage Parameters

### dataDir

D
danielclow 已提交
295 296
| Attribute     | Description               |
| -------- | ------------------------------------------ |
297 298 299 300 301 302
| Applicable    | Server Only                                 |
| Meaning       | All data files are stored in this directory |
| Default Value | /var/lib/taos                               |

### minimalTmpDirGB

D
danielclow 已提交
303 304 305
| Attribute     | Description                            |
| -------- | ------------------------------------------------ |
| Applicable    | Server and Client         |
306
| Meaning       | When the available disk space in tmpDir is below this threshold, writing to tmpDir is suspended |
D
danielclow 已提交
307 308
| Unit          | GB                            |
| Default Value | 1.0                                                                   |
309 310 311

### minimalDataDirGB

D
danielclow 已提交
312 313 314 315 316 317
| Attribute     | Description                            |
| -------- | ------------------------------------------------ |
| Applicable    | Server Only                                                    |
| Meaning       | When the available disk space in dataDir is below this threshold, writing to dataDir is suspended |
| Unit          | GB                            |
| Default Value | 2.0                                                                   |
318 319 320

## Cluster Parameters

D
danielclow 已提交
321
### supportVnodes
322

D
danielclow 已提交
323 324 325 326 327 328
| Attribute     | Description                            |
| -------- | --------------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Maximum number of vnodes per dnode |
| Value Range | 0-4096                                     |
| Default Value | 256                                                    |
329 330 331 332 333

## Time Parameters

### statusInterval

D
danielclow 已提交
334 335 336
| Attribute     | Description                            |
| -------- | --------------------------- |
| Applicable    | Server Only                                                    |
337 338
| Meaning       | the interval of dnode reporting status to mnode |
| Unit          | second                                          |
D
danielclow 已提交
339 340
| Value Range   | 1-10                                         |
| Default Value | 1                          |
341 342 343

### shellActivityTimer

D
danielclow 已提交
344 345 346
| Attribute     | Description                            |
| -------- | --------------------------------- |
| Applicable    | Server and Client         |
347
| Meaning       | The interval for TDengine CLI to send heartbeat to mnode |
D
danielclow 已提交
348 349 350
| Unit          | second                                          |
| Value Range   | 1-120                                         |
| Default Value | 3                              |
351 352 353 354 355

## Performance Optimization Parameters

### numOfCommitThreads

D
danielclow 已提交
356 357 358
| Attribute     | Description                            |
| -------- | ---------------------- |
| Applicable    | Server Only                                                    |
359
| Meaning       | Maximum of threads for committing to disk |
D
danielclow 已提交
360
| Default Value | |
361 362 363 364 365

## Compression Parameters

### compressMsgSize

D
danielclow 已提交
366 367 368 369
| Attribute     | Description                                                                                                                                                                         |
| ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Applicable    | Server Only                                                                                                                                                                         |
| Meaning       | The threshold for message size to compress the message.                         | Set the value to 64330 bytes for good message compression. |
370 371
| Unit          | bytes                                                                            |
| Value Range   | 0: already compress; >0: compress when message exceeds it; -1: always uncompress |
D
danielclow 已提交
372
| Default Value | -1                                                               |
373 374 375

### compressColData

D
danielclow 已提交
376 377 378 379
| Attribute     | Description                            |
| -------- | --------------------------------------------------------------------------------------- |
| Applicable    | Server Only                                                    |
| Meaning       | The threshold for size of column data to trigger compression for the query result              |
380 381
| Unit          | bytes                                                                                                               |
| Value Range   | 0: always compress; >0: only compress when the size of any column data exceeds the threshold; -1: always uncompress |
D
danielclow 已提交
382
| Default Value | -1                                                               |
383
| Default Value | -1                                                                                                                  |
384
| Note          | available from version 2.3.0.0                                                                                      |                                                                                                                       |
385

386
## Continuous Query Parameters                                  |
387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416

### minSlidingTime

| Attribute     | Description                                              |
| ------------- | -------------------------------------------------------- |
| Applicable    | Server Only                                              |
| Meaning       | Minimum sliding time of time window                      |
| Unit          | millisecond or microsecond , depending on time precision |
| Value Range   | 10-1000000                                               |
| Default Value | 10                                                       |

### minIntervalTime

| Attribute     | Description                 |
| ------------- | --------------------------- |
| Applicable    | Server Only                 |
| Meaning       | Minimum size of time window |
| Unit          | millisecond                 |
| Value Range   | 1-1000000                   |
| Default Value | 10                          |

:::info
To prevent system resource from being exhausted by multiple concurrent streams, a random delay is applied on each stream automatically. `maxFirstStreamCompDelay` is the maximum delay time before a continuous query is started the first time. `streamCompDelayRatio` is the ratio for calculating delay time, with the size of the time window as base. `maxStreamCompDelay` is the maximum delay time. The actual delay time is a random time not bigger than `maxStreamCompDelay`. If a continuous query fails, `retryStreamComDelay` is the delay time before retrying it, also not bigger than `maxStreamCompDelay`.

:::

## Log Parameters

### logDir

D
danielclow 已提交
417 418 419
| Attribute     | Description                            |
| -------- | -------------------------------------------------- |
| Applicable    | Server and Client         |
420 421 422 423 424
| Meaning       | The directory for writing log files |
| Default Value | /var/log/taos                       |

### minimalLogDirGB

D
danielclow 已提交
425 426 427
| Attribute     | Description                                                                                                                                                                         |
| -------- | -------------------------------------------- |
| Applicable    | Server and Client         |
428
| Meaning       | When the available disk space in logDir is below this threshold, writing to log files is suspended |
D
danielclow 已提交
429 430
| Unit          | GB                            |
| Default Value | 1.0                              |
431 432 433

### numOfLogLines

D
danielclow 已提交
434 435 436
| Attribute     | Description                            |
| -------- | ---------------------------- |
| Applicable    | Server and Client         |
437
| Meaning       | Maximum number of lines in single log file |
D
danielclow 已提交
438
| Default Value | 10000000                            |
439 440 441

### asyncLog

D
danielclow 已提交
442 443 444
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server and Client         |
445 446
| Meaning       | The mode of writing log file |
| Value Range   | 0: sync way; 1: async way    |
D
danielclow 已提交
447
| Default Value | 1                                                 |
448 449 450

### logKeepDays

D
danielclow 已提交
451 452 453
| Attribute     | Description                            |
| -------- | ----------------------------------------------------------------------------------- |
| Applicable    | Server and Client         |
454
| Meaning       | The number of days for log files to be kept                                                                                                 |
D
danielclow 已提交
455 456
| Unit          | day                                                   |
| Default Value | 0                                                               |
457 458 459 460
| Note          | When it's bigger than 0, the log file would be renamed to "taosdlog.xxx" in which "xxx" is the timestamp when the file is changed last time |

### debugFlag

D
danielclow 已提交
461 462 463
| Attribute     | Description                            |
| -------- | ------------------------------------------------------------------------------------------------- |
| Applicable    | Server and Client         |
464 465 466 467
| Meaning       | Log level                                                 |
| Value Range   | 131: INFO/WARNING/ERROR; 135: plus DEBUG; 143: plus TRACE |
| Default Value | 131 or 135, depending on the module                       |

D
danielclow 已提交
468
### tmrDebugFlag
469

D
danielclow 已提交
470 471 472 473
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server and Client         |
| Meaning       | Log level of timer module |
474
| Value Range   | same as debugFlag  |
D
danielclow 已提交
475
| Default Value | |
476

D
danielclow 已提交
477
### uDebugFlag
478

D
danielclow 已提交
479 480 481 482
| Attribute     | Description                            |
| -------- | ---------------------- |
| Applicable    | Server and Client         |
| Meaning       | Log level of common module |
483
| Value Range   | same as debugFlag  |
D
danielclow 已提交
484
| Default Value | |
485 486 487

### rpcDebugFlag

D
danielclow 已提交
488 489 490
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server and Client         |
491
| Meaning       | Log level of rpc module |
D
danielclow 已提交
492 493
| Value Range   | same as debugFlag  |
| Default Value | |
494

D
danielclow 已提交
495
### jniDebugFlag
496

D
danielclow 已提交
497 498 499 500 501 502 503 504 505 506 507
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Client Only         |
| Meaning       | Log level of jni module |
| Value Range   | same as debugFlag  |
| Default Value | |

### qDebugFlag

| Attribute     | Description                            |
| -------- | -------------------- |
508
| Applicable    | Server and Client         |
D
danielclow 已提交
509 510 511
| Meaning     | Log level of query module |
| Value Range   | same as debugFlag  |
| Default Value | |
512 513 514

### cDebugFlag

D
danielclow 已提交
515 516
| Attribute     | Description                            |
| -------- | --------------------- |
517 518
| Applicable    | Client Only         |
| Meaning       | Log level of Client |
D
danielclow 已提交
519 520
| Value Range   | same as debugFlag  |
| Default Value | |
521

D
danielclow 已提交
522
### dDebugFlag
523

D
danielclow 已提交
524 525 526 527 528 529
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning       | Log level of dnode |
| Value Range   | same as debugFlag  |
| Default Value | 135                              |
530

D
danielclow 已提交
531
### vDebugFlag
532

D
danielclow 已提交
533 534 535 536 537 538
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning       | Log level of vnode |
| Value Range   | same as debugFlag  |
| Default Value | |
539

D
danielclow 已提交
540
### mDebugFlag
541

D
danielclow 已提交
542 543 544 545 546 547
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of mnode module |
| Value Range   | same as debugFlag  |
| Default Value | 135                              |
548

D
danielclow 已提交
549
### wDebugFlag
550

D
danielclow 已提交
551 552 553 554 555 556
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of WAL module |
| Value Range   | same as debugFlag  |
| Default Value | 135                          |
557

D
danielclow 已提交
558
### sDebugFlag
559

D
danielclow 已提交
560 561
| Attribute     | Description                            |
| -------- | -------------------- |
562
| Applicable    | Server and Client         |
D
danielclow 已提交
563 564 565
| Meaning       | Log level of sync module |
| Value Range   | same as debugFlag  |
| Default Value | 135                              |
566 567 568

### tsdbDebugFlag

D
danielclow 已提交
569 570 571 572 573 574
| Attribute     | Description                            |
| -------- | ------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of TSDB module |
| Value Range   | same as debugFlag  |
| Default Value | |
575

D
danielclow 已提交
576
### tqDebugFlag
577 578

| Attribute     | Description                          |
D
danielclow 已提交
579 580 581 582 583
| -------- | ----------------- |
| Applicable | Server only                                           |
| Meaning     | Log level of TQ module |
| Value Range   | same as debugFlag  |
| Default Value | |
584

D
danielclow 已提交
585
### fsDebugFlag
586

D
danielclow 已提交
587 588 589 590 591 592 593 594
| Attribute     | Description                          |
| -------- | ----------------- |
| Applicable | Server only                                           |
| Meaning     | Log level of FS module |
| Value Range   | same as debugFlag  |
| Default Value | |

### udfDebugFlag
595 596

| Attribute     | Description                            |
D
danielclow 已提交
597 598 599 600 601
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning       | Log level of UDF module |
| Value Range   | same as debugFlag  |
| Default Value | |
602

D
danielclow 已提交
603
### smaDebugFlag
604

D
danielclow 已提交
605 606 607 608 609 610
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of SMA module |
| Value Range   | same as debugFlag  |
| Default Value | |
611

D
danielclow 已提交
612
### idxDebugFlag
613

D
danielclow 已提交
614 615 616 617 618 619
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of index module |
| Value Range   | same as debugFlag  |
| Default Value | |
620

D
danielclow 已提交
621
### tdbDebugFlag
622

D
danielclow 已提交
623 624 625 626 627 628
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of TDB module |
| Value Range   | same as debugFlag  |
| Default Value | |
629

D
danielclow 已提交
630
## Schemaless Parameters
631

D
danielclow 已提交
632
### smlChildTableName
633

D
danielclow 已提交
634 635 636 637 638 639
| Attribute     | Description                      |
| -------- | ------------------------- |
| Applicable | Client only                                           |
| Meaning     | Custom subtable name for schemaless writes |
| Type     | String                    |
| Default Value   | None                        |
640

D
danielclow 已提交
641
### smlTagName
642

D
danielclow 已提交
643 644 645 646 647 648 649 650
| Attribute     | Description                            |
| -------- | ------------------------------------ |
| Applicable | Client only                                           |
| Meaning     | Default tag for schemaless writes without tag value specified |
| Type     | String                    |
| Default Value   | _tag_null                                 |

### smlDataFormat
651 652

| Attribute     | Description                          |
D
danielclow 已提交
653 654 655 656 657
| -------- | ----------------------------- |
| Applicable | Client only                                           |
| Meaning     | Whether schemaless columns are consistently ordered |
| Value Range     | 0: not consistent; 1: consistent.            |
| Default   | 1                             |
658 659 660 661 662

## Other Parameters

### enableCoreFile

D
danielclow 已提交
663 664
| Attribute     | Description                                                                                         |
| -------- | ------------------------------------------------------------------------------------------------------------------------------------------ |
665 666 667 668 669
| Applicable    | Server and Client                                                                                                                                                       |
| Meaning       | Whether to generate core file when server crashes                                                                                                                       |
| Value Range   | 0: false, 1: true                                                                                                                                                       |
| Default Value | 1                                                                                                                                                                       |
| Note          | The core file is generated under root directory `systemctl start taosd` is used to start, or under the working directory if `taosd` is started directly on Linux Shell. |
D
danielclow 已提交
670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848

### udf

| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Whether the UDF service is enabled  |
| Value Range   | 0: disable UDF; 1: enabled UDF |
| Default Value | 1                              |

## Parameter Comparison of TDengine 2.x and 3.0
| #   | **Parameter**             | **In 2.x** | **In 3.0** |
| --- | :-----------------: | ---------------    | ---------------   |
| 1   | firstEp | Yes | Yes |
| 2   | secondEp | Yes | Yes |
| 3   | fqdn | Yes | Yes |
| 4   | serverPort | Yes | Yes |
| 5   | maxShellConns | Yes | Yes |
| 6   | monitor | Yes | Yes |
| 7   | monitorFqdn | No | Yes |
| 8   | monitorPort | No | Yes |
| 9   | monitorInterval | Yes | Yes |
| 10  | monitorMaxLogs | No | Yes |
| 11  | monitorComp | No | Yes |
| 12  | telemetryReporting | Yes | Yes |
| 13  | telemetryInterval | No | Yes |
| 14  | telemetryServer | No | Yes |
| 15  | telemetryPort | No | Yes |
| 16  | queryPolicy | No | Yes |
| 17  | querySmaOptimize | No | Yes |
| 18  | queryBufferSize | Yes | Yes |
| 19  | maxNumOfDistinctRes | Yes | Yes |
| 20  | minSlidingTime | Yes | Yes |
| 21  | minIntervalTime | Yes | Yes |
| 22  | countAlwaysReturnValue | Yes | Yes |
| 23  | dataDir | Yes | Yes |
| 24  | minimalDataDirGB | Yes | Yes |
| 25  | supportVnodes | No | Yes |
| 26  | tempDir | Yes | Yes |
| 27  | minimalTmpDirGB | Yes | Yes |
| 28  | compressMsgSize | Yes | Yes |
| 29  | compressColData | Yes | Yes |
| 30  | smlChildTableName | Yes | Yes |
| 31  | smlTagName | Yes | Yes |
| 32  | smlDataFormat | No | Yes |
| 33  | statusInterval | Yes | Yes |
| 34  | shellActivityTimer | Yes | Yes |
| 35  | transPullupInterval | No | Yes |
| 36  | mqRebalanceInterval | No | Yes |
| 37  | ttlUnit | No | Yes |
| 38  | ttlPushInterval | No | Yes |
| 39  | numOfTaskQueueThreads | No | Yes |
| 40  | numOfRpcThreads | No | Yes |
| 41  | numOfCommitThreads | Yes | Yes |
| 42  | numOfMnodeReadThreads | No | Yes |
| 43  | numOfVnodeQueryThreads | No | Yes |
| 44  | numOfVnodeStreamThreads | No | Yes |
| 45  | numOfVnodeFetchThreads | No | Yes |
| 46  | numOfVnodeWriteThreads | No | Yes |
| 47  | numOfVnodeSyncThreads | No | Yes |
| 48  | numOfQnodeQueryThreads | No | Yes |
| 49  | numOfQnodeFetchThreads | No | Yes |
| 50  | numOfSnodeSharedThreads | No | Yes |
| 51  | numOfSnodeUniqueThreads | No | Yes |
| 52  | rpcQueueMemoryAllowed | No | Yes |
| 53  | logDir | Yes | Yes |
| 54  | minimalLogDirGB | Yes | Yes |
| 55  | numOfLogLines | Yes | Yes |
| 56  | asyncLog | Yes | Yes |
| 57  | logKeepDays | Yes | Yes |
| 58  | debugFlag | Yes | Yes |
| 59  | tmrDebugFlag | Yes | Yes |
| 60  | uDebugFlag | Yes | Yes |
| 61  | rpcDebugFlag | Yes | Yes |
| 62  | jniDebugFlag | Yes | Yes |
| 63  | qDebugFlag | Yes | Yes |
| 64  | cDebugFlag | Yes | Yes |
| 65  | dDebugFlag | Yes | Yes |
| 66  | vDebugFlag | Yes | Yes |
| 67  | mDebugFlag | Yes | Yes |
| 68  | wDebugFlag | Yes | Yes |
| 69  | sDebugFlag | Yes | Yes |
| 70  | tsdbDebugFlag | Yes | Yes |
| 71  | tqDebugFlag | No | Yes |
| 72  | fsDebugFlag | Yes | Yes |
| 73  | udfDebugFlag | No | Yes |
| 74  | smaDebugFlag | No | Yes |
| 75  | idxDebugFlag | No | Yes |
| 76  | tdbDebugFlag | No | Yes |
| 77  | metaDebugFlag | No | Yes |
| 78  | timezone | Yes | Yes |
| 79  | locale | Yes | Yes |
| 80  | charset | Yes | Yes |
| 81  | udf | Yes | Yes |
| 82  | enableCoreFile | Yes | Yes |
| 83  | arbitrator | Yes | No |
| 84  | numOfThreadsPerCore | Yes | No |
| 85  | numOfMnodes | Yes | No |
| 86  | vnodeBak | Yes | No |
| 87  | balance | Yes | No |
| 88  | balanceInterval | Yes | No |
| 89  | offlineThreshold | Yes | No |
| 90  | role | Yes | No |
| 91  | dnodeNopLoop | Yes | No |
| 92  | keepTimeOffset | Yes | No |
| 93  | rpcTimer | Yes | No |
| 94  | rpcMaxTime | Yes | No |
| 95  | rpcForceTcp | Yes | No |
| 96  | tcpConnTimeout | Yes | No |
| 97  | syncCheckInterval | Yes | No |
| 98  | maxTmrCtrl | Yes | No |
| 99  | monitorReplica | Yes | No |
| 100 | smlTagNullName | Yes | No |
| 101 | keepColumnName | Yes | No |
| 102 | ratioOfQueryCores | Yes | No |
| 103 | maxStreamCompDelay | Yes | No |
| 104 | maxFirstStreamCompDelay | Yes | No |
| 105 | retryStreamCompDelay | Yes | No |
| 106 | streamCompDelayRatio | Yes | No |
| 107 | maxVgroupsPerDb | Yes | No |
| 108 | maxTablesPerVnode | Yes | No |
| 109 | minTablesPerVnode | Yes | No |
| 110 | tableIncStepPerVnode | Yes | No |
| 111 | cache | Yes | No |
| 112 | blocks | Yes | No |
| 113 | days | Yes | No |
| 114 | keep | Yes | No |
| 115 | minRows | Yes | No |
| 116 | maxRows | Yes | No |
| 117 | quorum | Yes | No |
| 118 | comp | Yes | No |
| 119 | walLevel | Yes | No |
| 120 | fsync | Yes | No |
| 121 | replica | Yes | No |
| 122 | partitions | Yes | No |
| 123 | quorum | Yes | No |
| 124 | update | Yes | No |
| 125 | cachelast | Yes | No |
| 126 | maxSQLLength | Yes | No |
| 127 | maxWildCardsLength | Yes | No |
| 128 | maxRegexStringLen | Yes | No |
| 129 | maxNumOfOrderedRes | Yes | No |
| 130 | maxConnections | Yes | No |
| 131 | mnodeEqualVnodeNum | Yes | No |
| 132 | http | Yes | No |
| 133 | httpEnableRecordSql | Yes | No |
| 134 | httpMaxThreads | Yes | No |
| 135 | restfulRowLimit | Yes | No |
| 136 | httpDbNameMandatory | Yes | No |
| 137 | httpKeepAlive | Yes | No |
| 138 | enableRecordSql | Yes | No |
| 139 | maxBinaryDisplayWidth | Yes | No |
| 140 | stream | Yes | No |
| 141 | retrieveBlockingModel | Yes | No |
| 142 | tsdbMetaCompactRatio | Yes | No |
| 143 | defaultJSONStrType | Yes | No |
| 144 | walFlushSize | Yes | No |
| 145 | keepTimeOffset | Yes | No |
| 146 | flowctrl | Yes | No |
| 147 | slaveQuery | Yes | No |
| 148 | adjustMaster | Yes | No |
| 149 | topicBinaryLen | Yes | No |
| 150 | telegrafUseFieldNum | Yes | No |
| 151 | deadLockKillQuery | Yes | No |
| 152 | clientMerge | Yes | No |
| 153 | sdbDebugFlag | Yes | No |
| 154 | odbcDebugFlag | Yes | No |
| 155 | httpDebugFlag | Yes | No |
| 156 | monDebugFlag | Yes | No |
| 157 | cqDebugFlag | Yes | No |
| 158 | shortcutFlag | Yes | No |
| 159 | probeSeconds | Yes | No |
| 160 | probeKillSeconds | Yes | No |
| 161 | probeInterval | Yes | No |
| 162 | lossyColumns | Yes | No |
| 163 | fPrecision | Yes | No |
| 164 | dPrecision | Yes | No |
| 165 | maxRange | Yes | No |
| 166 | range | Yes | No |