index.md 36.4 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

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

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

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 |
52
| Default   | localhost:6030                                                 |
53 54 55

### secondEp

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 |
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 |
68 69
| Default Value | The first hostname configured for the host                             |
| Note          | It should be within 96 bytes                                             |                        |
70 71 72

### serverPort

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
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                                                                               |
| :------- | :----------- | :----------------------------------------------- | :--------------------------------------------------------------------------------------------- |
84 85 86 87 88 89
| TCP | 6030 | Communication between client and server. In a multi-node cluster, communication between nodes. serverPort |
| 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/) |
| 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                                                 |

100
## Monitoring Parameters
101

102
### monitor
103

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

111
### monitorFqdn
112

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

119
### monitorPort
120

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

### monitorInterval

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

### telemetryReporting

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                                                   |
144
| Default Value | 1                                                                                                                                                                                   |
145 146 147

## Query Parameters

148
### queryPolicy
149

150 151 152 153 154 155 156 157 158
| 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 |

2: Run subtasks without scan operators on qnodes and subtasks with scan operators on vnodes.
159

160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
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

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

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

:::info
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

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

```
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
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.

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
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
```

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

275
```
276 277 278 279
locale zh_CN.UTF-8
charset GBK
```

280 281 282
The charset that takes effect is GBK.

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

287
The charset that takes effect is UTF-8.
288 289 290 291 292 293 294

:::

## Storage Parameters

### dataDir

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

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 |
307 308
| Unit          | GB                            |
| Default Value | 1.0                                                                   |
309 310 311

### minimalDataDirGB

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

321
### supportVnodes
322

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

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

### shellActivityTimer

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

## Performance Optimization Parameters

### numOfCommitThreads

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

## Compression Parameters

### compressMsgSize

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 |
372
| Default Value | -1                                                               |
373 374 375

### compressColData

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 |
382
| Default Value | -1                                                               |
383 384 385 386 387

## Log Parameters

### logDir

388 389 390
| Attribute     | Description                            |
| -------- | -------------------------------------------------- |
| Applicable    | Server and Client         |
391 392 393 394 395
| Meaning       | The directory for writing log files |
| Default Value | /var/log/taos                       |

### minimalLogDirGB

396 397 398
| Attribute     | Description                                                                                                                                                                         |
| -------- | -------------------------------------------- |
| Applicable    | Server and Client         |
399
| Meaning       | When the available disk space in logDir is below this threshold, writing to log files is suspended |
400 401
| Unit          | GB                            |
| Default Value | 1.0                              |
402 403 404

### numOfLogLines

405 406 407
| Attribute     | Description                            |
| -------- | ---------------------------- |
| Applicable    | Server and Client         |
408
| Meaning       | Maximum number of lines in single log file |
409
| Default Value | 10000000                            |
410 411 412

### asyncLog

413 414 415
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server and Client         |
416 417
| Meaning       | The mode of writing log file |
| Value Range   | 0: sync way; 1: async way    |
418
| Default Value | 1                                                 |
419 420 421

### logKeepDays

422 423 424
| Attribute     | Description                            |
| -------- | ----------------------------------------------------------------------------------- |
| Applicable    | Server and Client         |
425
| Meaning       | The number of days for log files to be kept                                                                                                 |
426 427
| Unit          | day                                                   |
| Default Value | 0                                                               |
428 429 430 431
| 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

432 433 434
| Attribute     | Description                            |
| -------- | ------------------------------------------------------------------------------------------------- |
| Applicable    | Server and Client         |
435 436 437 438
| Meaning       | Log level                                                 |
| Value Range   | 131: INFO/WARNING/ERROR; 135: plus DEBUG; 143: plus TRACE |
| Default Value | 131 or 135, depending on the module                       |

439
### tmrDebugFlag
440

441 442 443 444
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server and Client         |
| Meaning       | Log level of timer module |
445
| Value Range   | same as debugFlag  |
446
| Default Value | |
447

448
### uDebugFlag
449

450 451 452 453
| Attribute     | Description                            |
| -------- | ---------------------- |
| Applicable    | Server and Client         |
| Meaning       | Log level of common module |
454
| Value Range   | same as debugFlag  |
455
| Default Value | |
456 457 458

### rpcDebugFlag

459 460 461
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server and Client         |
462
| Meaning       | Log level of rpc module |
463 464
| Value Range   | same as debugFlag  |
| Default Value | |
465

466
### jniDebugFlag
467

468 469 470 471 472 473 474 475 476 477 478
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Client Only         |
| Meaning       | Log level of jni module |
| Value Range   | same as debugFlag  |
| Default Value | |

### qDebugFlag

| Attribute     | Description                            |
| -------- | -------------------- |
479
| Applicable    | Server and Client         |
480 481 482
| Meaning     | Log level of query module |
| Value Range   | same as debugFlag  |
| Default Value | |
483 484 485

### cDebugFlag

486 487
| Attribute     | Description                            |
| -------- | --------------------- |
488 489
| Applicable    | Client Only         |
| Meaning       | Log level of Client |
490 491
| Value Range   | same as debugFlag  |
| Default Value | |
492

493
### dDebugFlag
494

495 496 497 498 499 500
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning       | Log level of dnode |
| Value Range   | same as debugFlag  |
| Default Value | 135                              |
501

502
### vDebugFlag
503

504 505 506 507 508 509
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning       | Log level of vnode |
| Value Range   | same as debugFlag  |
| Default Value | |
510

511
### mDebugFlag
512

513 514 515 516 517 518
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of mnode module |
| Value Range   | same as debugFlag  |
| Default Value | 135                              |
519

520
### wDebugFlag
521

522 523 524 525 526 527
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of WAL module |
| Value Range   | same as debugFlag  |
| Default Value | 135                          |
528

529
### sDebugFlag
530

531 532
| Attribute     | Description                            |
| -------- | -------------------- |
533
| Applicable    | Server and Client         |
534 535 536
| Meaning       | Log level of sync module |
| Value Range   | same as debugFlag  |
| Default Value | 135                              |
537 538 539

### tsdbDebugFlag

540 541 542 543 544 545
| Attribute     | Description                            |
| -------- | ------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of TSDB module |
| Value Range   | same as debugFlag  |
| Default Value | |
546

547
### tqDebugFlag
548 549

| Attribute     | Description                          |
550 551 552 553 554
| -------- | ----------------- |
| Applicable | Server only                                           |
| Meaning     | Log level of TQ module |
| Value Range   | same as debugFlag  |
| Default Value | |
555

556
### fsDebugFlag
557

558 559 560 561 562 563 564 565
| Attribute     | Description                          |
| -------- | ----------------- |
| Applicable | Server only                                           |
| Meaning     | Log level of FS module |
| Value Range   | same as debugFlag  |
| Default Value | |

### udfDebugFlag
566 567

| Attribute     | Description                            |
568 569 570 571 572
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning       | Log level of UDF module |
| Value Range   | same as debugFlag  |
| Default Value | |
573

574
### smaDebugFlag
575

576 577 578 579 580 581
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of SMA module |
| Value Range   | same as debugFlag  |
| Default Value | |
582

583
### idxDebugFlag
584

585 586 587 588 589 590
| Attribute     | Description                            |
| -------- | -------------------- |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of index module |
| Value Range   | same as debugFlag  |
| Default Value | |
591

592
### tdbDebugFlag
593

594 595 596 597 598 599
| Attribute     | Description                            |
| -------- | ------------------ |
| Applicable    | Server Only                                                    |
| Meaning     | Log level of TDB module |
| Value Range   | same as debugFlag  |
| Default Value | |
600

601
## Schemaless Parameters
602

603
### smlChildTableName
604

605 606 607 608 609 610
| Attribute     | Description                      |
| -------- | ------------------------- |
| Applicable | Client only                                           |
| Meaning     | Custom subtable name for schemaless writes |
| Type     | String                    |
| Default Value   | None                        |
611

612
### smlTagName
613

614 615 616 617 618 619 620 621
| Attribute     | Description                            |
| -------- | ------------------------------------ |
| Applicable | Client only                                           |
| Meaning     | Default tag for schemaless writes without tag value specified |
| Type     | String                    |
| Default Value   | _tag_null                                 |

### smlDataFormat
622 623

| Attribute     | Description                          |
624 625 626 627 628
| -------- | ----------------------------- |
| Applicable | Client only                                           |
| Meaning     | Whether schemaless columns are consistently ordered |
| Value Range     | 0: not consistent; 1: consistent.            |
| Default   | 1                             |
629 630 631 632 633

## Other Parameters

### enableCoreFile

634 635
| Attribute     | Description                                                                                         |
| -------- | ------------------------------------------------------------------------------------------------------------------------------------------ |
636 637 638 639 640
| 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. |
641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 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

### 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 |