1GET /v{version}/ddc/ob/instance/{instanceId}/tenant/{tenantId}/parameters HTTP/1.1
2Host: ddc.bj.baidubce.com
3Authorization: authorization string

1GET http://ddc.bj.baidubce.com/v1/ddc/ob/instance/ob7eyqcco3ya4g/tenant/t7eyt5nj7h1og/parameters
2Host: ddc.bj.baidubce.com
3Authorization: bce-auth-v1/f81d3b34e48048fbb2634dc7882d7e21/2015-08-11T04:17:29Z/3600/host/74c506f68c65e26c633bfa104c863fffac5190fdec1ec24b7c03eb5d67d2e1de

1HTTP/1.1 200 OK
2Content-Type: application/json;charset=UTF-8
3Date: Wed, 08 Jul 2015 03:28:11 GMT
4x-bce-request-id: d8752367-38e8-45e4-b4c7-e53be3137ce5
5Server: BWS
6{
7    "result": [
8        {
9            "name": "ob_vector_memory_limit_percentage",
10            "currentValue": "0",
11            "needReboot": false,
12            "defaultValue": "0",
13            "valueType": "RANGE",
14            "acceptableValue": [
15                "0",
16                "35"
17            ],
18            "rejectedValue": [],
19            "description": "设置向量索引模块占用内存资源的阈值。"
20        },
21        {
22            "name": "connect_timeout",
23            "currentValue": "9",
24            "needReboot": false,
25            "defaultValue": "10",
26            "valueType": "RANGE",
27            "acceptableValue": [
28                "2",
29                "31536000"
30            ],
31            "rejectedValue": [],
32            "description": "Connection timeout duration, in seconds."
33        },
34        {
35            "name": "ob_check_sys_variable",
36            "currentValue": "ON",
37            "needReboot": false,
38            "defaultValue": "ON",
39            "valueType": "ENUM",
40            "acceptableValue": [
41                "OFF",
42                "ON"
43            ],
44            "rejectedValue": [],
45            "description": "If enabled, system variables will be updated when the schema version changes."
46        },
47        {
48            "name": "writing_throttling_maximum_duration",
49            "currentValue": "2h",
50            "needReboot": false,
51            "defaultValue": "2h",
52            "valueType": "TIME",
53            "acceptableValue": [
54                "1s",
55                "3d"
56            ],
57            "rejectedValue": [],
58            "description": "Specifies the time required from allocating the remaining MemStore memory after write throttling is triggered. This parameter controls the write speed by controlling the memory allocation progress."
59        },
60        {
61            "name": "div_precision_increment",
62            "currentValue": "4",
63            "needReboot": false,
64            "defaultValue": "4",
65            "valueType": "RANGE",
66            "acceptableValue": [
67                "0",
68                "30"
69            ],
70            "rejectedValue": [],
71            "description": "Specifies the number of digits by which to increase the scale of the result of a division operation based on the scale of the dividend. This feature is compatible with MySQL."
72        },
73        {
74            "name": "ob_sql_work_area_percentage",
75            "currentValue": "5",
76            "needReboot": false,
77            "defaultValue": "5",
78            "valueType": "RANGE",
79            "acceptableValue": [
80                "0",
81                "100"
82            ],
83            "rejectedValue": [],
84            "description": "Percentage of tenant memory used for SQL execution."
85        },
86        {
87            "name": "tx_isolation",
88            "currentValue": "READ-COMMITTED",
89            "needReboot": false,
90            "defaultValue": "READ-COMMITTED",
91            "valueType": "ENUM",
92            "acceptableValue": [
93                "READ-COMMITTED",
94                "REPEATABLE-READ",
95                "SERIALIZABLE"
96            ],
97            "rejectedValue": [],
98            "description": "Transaction isolation level."
99        },
100        {
101            "name": "wait_timeout",
102            "currentValue": "28800",
103            "needReboot": false,
104            "defaultValue": "28800",
105            "valueType": "RANGE",
106            "acceptableValue": [
107                "1",
108                "31536000"
109            ],
110            "rejectedValue": [],
111            "description": "Specifies the time in seconds that the server waits for activity on a non-interactive connection before closing it. When a session is initiated, the value of wait_timeout for the session is initialized based on the value of the global wait_timeout variable or the global interactive_timeout variable, depending on the client type. The client type is determined by the CLIENT_INTERACTIVE option in mysql_real_connect(). See also interactive_timeout."
112        },
113        {
114            "name": "auto_increment_increment",
115            "currentValue": "1",
116            "needReboot": false,
117            "defaultValue": "1",
118            "valueType": "RANGE",
119            "acceptableValue": [
120                "1",
121                "65535"
122            ],
123            "rejectedValue": [],
124            "description": "Specifies the auto-increment step size, used only for MySQL client login."
125        },
126        {
127            "name": "foreign_key_checks",
128            "currentValue": "ON",
129            "needReboot": false,
130            "defaultValue": "ON",
131            "valueType": "ENUM",
132            "acceptableValue": [
133                "OFF",
134                "ON"
135            ],
136            "rejectedValue": [],
137            "description": "Specifies whether to enable FOREIGN KEY constraint check."
138        },
139        {
140            "name": "autocommit",
141            "currentValue": "ON",
142            "needReboot": false,
143            "defaultValue": "ON",
144            "valueType": "ENUM",
145            "acceptableValue": [
146                "OFF",
147                "ON"
148            ],
149            "rejectedValue": [],
150            "description": "Specifies whether auto-commit is enabled."
151        },
152        {
153            "name": "read_only",
154            "currentValue": "OFF",
155            "needReboot": false,
156            "defaultValue": "OFF",
157            "valueType": "ENUM",
158            "acceptableValue": [
159                "OFF",
160                "ON"
161            ],
162            "rejectedValue": [],
163            "description": "Determines if the tenant is in read-only mode. This affects all regular users under this tenant, excluding root users."
164        },
165        {
166            "name": "transaction_isolation",
167            "currentValue": "READ-COMMITTED",
168            "needReboot": false,
169            "defaultValue": "READ-COMMITTED",
170            "valueType": "ENUM",
171            "acceptableValue": [
172                "READ-COMMITTED",
173                "REPEATABLE-READ",
174                "SERIALIZABLE"
175            ],
176            "rejectedValue": [],
177            "description": "指定事务隔离级别。"
178        },
179        {
180            "name": "ob_trx_timeout",
181            "currentValue": "86400000000",
182            "needReboot": false,
183            "defaultValue": "86400000000",
184            "valueType": "RANGE",
185            "acceptableValue": [
186                "-1",
187                "1000000000000000"
188            ],
189            "rejectedValue": [
190                "0"
191            ],
192            "description": "Timeout for transactions, in microseconds."
193        },
194        {
195            "name": "net_read_timeout",
196            "currentValue": "30",
197            "needReboot": false,
198            "defaultValue": "30",
199            "valueType": "RANGE",
200            "acceptableValue": [
201                "1",
202                "31536000"
203            ],
204            "rejectedValue": [],
205            "description": "Seconds to wait for additional data from the connection before interrupting a read. Controls read interruption timeout when the server reads from the client."
206        },
207        {
208            "name": "ob_enable_index_direct_select",
209            "currentValue": "ON",
210            "needReboot": false,
211            "defaultValue": "OFF",
212            "valueType": "ENUM",
213            "acceptableValue": [
214                "OFF",
215                "ON"
216            ],
217            "rejectedValue": [],
218            "description": "Specifies whether to allow users to directly query index tables."
219        },
220        {
221            "name": "ob_trx_lock_timeout",
222            "currentValue": "-1",
223            "needReboot": false,
224            "defaultValue": "-1",
225            "valueType": "RANGE",
226            "acceptableValue": [
227                "-1",
228                "100000000000"
229            ],
230            "rejectedValue": [
231                "0"
232            ],
233            "description": "用于设置事务的等锁超时时长，单位是微秒。"
234        },
235        {
236            "name": "compaction_low_thread_score",
237            "currentValue": "0",
238            "needReboot": false,
239            "defaultValue": "0",
240            "valueType": "RANGE",
241            "acceptableValue": [
242                "0",
243                "100"
244            ],
245            "rejectedValue": [],
246            "description": "设置低优先级 compaction 的工作线程占用 CPU 时间片权重"
247        },
248        {
249            "name": "sql_throttle_rt",
250            "currentValue": "-1",
251            "needReboot": false,
252            "defaultValue": "-1",
253            "valueType": "RANGE",
254            "acceptableValue": [
255                "-1",
256                "2147483647"
257            ],
258            "rejectedValue": [
259                "0"
260            ],
261            "description": "Specifies the response time, in microseconds. Queries with the response time being less than the specified value can be executed."
262        },
263        {
264            "name": "ob_enable_transmission_checksum",
265            "currentValue": "ON",
266            "needReboot": false,
267            "defaultValue": "ON",
268            "valueType": "ENUM",
269            "acceptableValue": [
270                "OFF",
271                "ON"
272            ],
273            "rejectedValue": [],
274            "description": "Specifies whether to check the packet checksum between proxy and server."
275        },
276        {
277            "name": "writing_throttling_trigger_percentage",
278            "currentValue": "60",
279            "needReboot": false,
280            "defaultValue": "80",
281            "valueType": "RANGE",
282            "acceptableValue": [
283                "1",
284                "100"
285            ],
286            "rejectedValue": [],
287            "description": "Specifies the upper limit of the write speed."
288        },
289        {
290            "name": "ob_plan_cache_evict_low_percentage",
291            "currentValue": "50",
292            "needReboot": false,
293            "defaultValue": "50",
294            "valueType": "RANGE",
295            "acceptableValue": [
296                "0",
297                "100"
298            ],
299            "rejectedValue": [],
300            "description": "Memory usage percentage that stops eviction of plan cache entries."
301        },
302        {
303            "name": "ob_plan_cache_percentage",
304            "currentValue": "5",
305            "needReboot": false,
306            "defaultValue": "5",
307            "valueType": "RANGE",
308            "acceptableValue": [
309                "0",
310                "100"
311            ],
312            "rejectedValue": [],
313            "description": "Specifies the percentage of the tenant memory that can be used by the plan cache."
314        },
315        {
316            "name": "max_sp_recursion_depth",
317            "currentValue": "0",
318            "needReboot": false,
319            "defaultValue": "0",
320            "valueType": "RANGE",
321            "acceptableValue": [
322                "0",
323                "255"
324            ],
325            "rejectedValue": [],
326            "description": "Specifies the maximum number of times that a specified stored procedure can be recursively called."
327        },
328        {
329            "name": "sql_throttle_network",
330            "currentValue": "-1",
331            "needReboot": false,
332            "defaultValue": "-1",
333            "valueType": "RANGE",
334            "acceptableValue": [
335                "-1",
336                "2147483647"
337            ],
338            "rejectedValue": [
339                "0"
340            ],
341            "description": "SQL will not be executed if network usage exceeds this threshold."
342        },
343        {
344            "name": "undo_retention",
345            "currentValue": "1800",
346            "needReboot": false,
347            "defaultValue": "1800",
348            "valueType": "RANGE",
349            "acceptableValue": [
350                "0",
351                "4294967295"
352            ],
353            "rejectedValue": [],
354            "description": "Specifies the time range in seconds of data versions to be retained by the system."
355        },
356        {
357            "name": "sql_throttle_logical_reads",
358            "currentValue": "-1",
359            "needReboot": false,
360            "defaultValue": "-1",
361            "valueType": "RANGE",
362            "acceptableValue": [
363                "-1",
364                "2147483647"
365            ],
366            "rejectedValue": [
367                "0"
368            ],
369            "description": "SQL will not be executed if the logical read count exceeds this threshold."
370        },
371        {
372            "name": "auto_increment_cache_size",
373            "currentValue": "1000000",
374            "needReboot": false,
375            "defaultValue": "1000000",
376            "valueType": "RANGE",
377            "acceptableValue": [
378                "1",
379                "100000000"
380            ],
381            "rejectedValue": [],
382            "description": "Specifies the number of cached auto-increment values."
383        },
384        {
385            "name": "sql_auto_is_null",
386            "currentValue": "OFF",
387            "needReboot": false,
388            "defaultValue": "OFF",
389            "valueType": "ENUM",
390            "acceptableValue": [
391                "OFF",
392                "ON"
393            ],
394            "rejectedValue": [],
395            "description": "Used by some special drivers, such as ODBC, to specify whether to obtain the auto-increment column value of the last inserted row."
396        },
397        {
398            "name": "recyclebin",
399            "currentValue": "OFF",
400            "needReboot": false,
401            "defaultValue": "ON",
402            "valueType": "ENUM",
403            "acceptableValue": [
404                "ON",
405                "OFF"
406            ],
407            "rejectedValue": [],
408            "description": "Toggles the recycle bin. When enabled, deleted database objects go into the recycle bin."
409        },
410        {
411            "name": "ob_enable_plan_cache",
412            "currentValue": "ON",
413            "needReboot": false,
414            "defaultValue": "ON",
415            "valueType": "ENUM",
416            "acceptableValue": [
417                "OFF",
418                "ON"
419            ],
420            "rejectedValue": [],
421            "description": "Specifies whether to enable Plan Cache."
422        },
423        {
424            "name": "ob_enable_aggregation_pushdown",
425            "currentValue": "ON",
426            "needReboot": false,
427            "defaultValue": "ON",
428            "valueType": "ENUM",
429            "acceptableValue": [
430                "OFF",
431                "ON"
432            ],
433            "rejectedValue": [],
434            "description": "Specifies whether to allow aggregation operations to be pushed down."
435        },
436        {
437            "name": "net_write_timeout",
438            "currentValue": "60",
439            "needReboot": false,
440            "defaultValue": "60",
441            "valueType": "RANGE",
442            "acceptableValue": [
443                "1",
444                "31536000"
445            ],
446            "rejectedValue": [],
447            "description": "Seconds to wait before interrupting a write to the connection after writing a block. Controls write interruption timeout when the server writes to the client."
448        },
449        {
450            "name": "ob_enable_transformation",
451            "currentValue": "ON",
452            "needReboot": false,
453            "defaultValue": "ON",
454            "valueType": "ENUM",
455            "acceptableValue": [
456                "OFF",
457                "ON"
458            ],
459            "rejectedValue": [],
460            "description": "Specifies whether to allow SQL rewriting."
461        },
462        {
463            "name": "sql_quote_show_create",
464            "currentValue": "ON",
465            "needReboot": false,
466            "defaultValue": "ON",
467            "valueType": "ENUM",
468            "acceptableValue": [
469                "OFF",
470                "ON"
471            ],
472            "rejectedValue": [],
473            "description": "Specifies whether to quote identifiers for the SHOW CREATE TABLE and SHOW CREATE DATABASE statements."
474        },
475        {
476            "name": "sql_throttle_io",
477            "currentValue": "-1",
478            "needReboot": false,
479            "defaultValue": "-1",
480            "valueType": "RANGE",
481            "acceptableValue": [
482                "-1",
483                "2147483647"
484            ],
485            "rejectedValue": [
486                "0"
487            ],
488            "description": "SQL will not be executed if the I/O count exceeds this threshold."
489        },
490        {
491            "name": "ob_enable_jit",
492            "currentValue": "OFF",
493            "needReboot": false,
494            "defaultValue": "OFF",
495            "valueType": "ENUM",
496            "acceptableValue": [
497                "OFF",
498                "AUTO",
499                "FORCE"
500            ],
501            "rejectedValue": [],
502            "description": "Specifies the mode of the just-in-time (JIT) execution engine. \nOFF: Disables expression compilation execution for the current session.\nAUTO: Enables expression compilation for the current session only when the average response time of SQL statement execution is greater than 1s.\nFORCE: Forces enabling expression compilation execution for the current session."
503        },
504        {
505            "name": "max_stale_time_for_weak_consistency",
506            "currentValue": "5s",
507            "needReboot": false,
508            "defaultValue": "5s",
509            "valueType": "TIME",
510            "acceptableValue": [
511                "5s",
512                "24h"
513            ],
514            "rejectedValue": [],
515            "description": "Sets the allowed synchronization delay between a standby server and the primary server for weak consistency reads."
516        },
517        {
518            "name": "ob_enable_truncate_flashback",
519            "currentValue": "OFF",
520            "needReboot": false,
521            "defaultValue": "ON",
522            "valueType": "ENUM",
523            "acceptableValue": [
524                "OFF",
525                "ON"
526            ],
527            "rejectedValue": [],
528            "description": "Specifies whether to enable flashback for truncated tables."
529        },
530        {
531            "name": "ob_trx_idle_timeout",
532            "currentValue": "86400000000",
533            "needReboot": false,
534            "defaultValue": "120000000",
535            "valueType": "RANGE",
536            "acceptableValue": [
537                "-1",
538                "100000000000"
539            ],
540            "rejectedValue": [
541                "0"
542            ],
543            "description": "Timeout for idle transactions, in microseconds. A timeout occurs when the execution interval between two statements within a transaction exceeds this value."
544        },
545        {
546            "name": "optimizer_capture_sql_plan_baselines",
547            "currentValue": "ON",
548            "needReboot": false,
549            "defaultValue": "OFF",
550            "valueType": "ENUM",
551            "acceptableValue": [
552                "OFF",
553                "ON"
554            ],
555            "rejectedValue": [],
556            "description": "Enables automatic capture of SQL plan baselines."
557        },
558        {
559            "name": "auto_increment_offset",
560            "currentValue": "1",
561            "needReboot": false,
562            "defaultValue": "1",
563            "valueType": "RANGE",
564            "acceptableValue": [
565                "1",
566                "65535"
567            ],
568            "rejectedValue": [],
569            "description": "Determines the starting value of AUTO_INCREMENT columns."
570        },
571        {
572            "name": "ob_read_consistency",
573            "currentValue": "STRONG",
574            "needReboot": false,
575            "defaultValue": "STRONG",
576            "valueType": "ENUM",
577            "acceptableValue": [
578                "FROZEN",
579                "WEAK",
580                "STRONG"
581            ],
582            "rejectedValue": [],
583            "description": "Read consistency level."
584        },
585        {
586            "name": "block_encryption_mode",
587            "currentValue": "aes-128-ecb",
588            "needReboot": false,
589            "defaultValue": "aes-128-ecb",
590            "valueType": "ENUM",
591            "acceptableValue": [
592                "aes-128-ecb",
593                "aes-192-ecb",
594                "aes-256-ecb",
595                "aes-128-cbc",
596                "aes-192-cbc",
597                "aes-256-cbc",
598                "aes-128-cfb1",
599                "aes-192-cfb1",
600                "aes-256-cfb1",
601                "aes-128-cfb8",
602                "aes-192-cfb8",
603                "aes-256-cfb8",
604                "aes-128-cfb128",
605                "aes-192-cfb128",
606                "aes-256-cfb128",
607                "aes-128-ofb",
608                "aes-192-ofb",
609                "aes-256-ofb"
610            ],
611            "rejectedValue": [],
612            "description": "Specifies the encryption algorithm used in the aes_encrypt and aes_decrypt functions."
613        },
614        {
615            "name": "sql_throttle_cpu",
616            "currentValue": "2",
617            "needReboot": false,
618            "defaultValue": "-1",
619            "valueType": "RANGE",
620            "acceptableValue": [
621                "-1",
622                "100"
623            ],
624            "rejectedValue": [
625                "0"
626            ],
627            "description": "SQL will not be executed if the CPU usage exceeds this value."
628        },
629        {
630            "name": "error_on_overlap_time",
631            "currentValue": "OFF",
632            "needReboot": false,
633            "defaultValue": "OFF",
634            "valueType": "ENUM",
635            "acceptableValue": [
636                "OFF",
637                "ON"
638            ],
639            "rejectedValue": [],
640            "description": "Dynamic parameter that controls whether to raise an error when ambiguity occurs due to overlapping daylight saving time."
641        },
642        {
643            "name": "interactive_timeout",
644            "currentValue": "28800",
645            "needReboot": false,
646            "defaultValue": "28800",
647            "valueType": "RANGE",
648            "acceptableValue": [
649                "1",
650                "31536000"
651            ],
652            "rejectedValue": [],
653            "description": "Time in seconds that the server waits for activity before closing interactive connections. An interactive client is one that sets the CLIENT_INTERACTIVE option when it connects to the server with mysql_real_connect(). See also wait_timeout. "
654        },
655        {
656            "name": "query_cache_size",
657            "currentValue": "0",
658            "needReboot": false,
659            "defaultValue": "1048576",
660            "valueType": "RANGE",
661            "acceptableValue": [
662                "0",
663                "9007199254740991"
664            ],
665            "rejectedValue": [],
666            "description": "Specifies the memory in bytes, including the unused memory, allocated to store historical query results."
667        },
668        {
669            "name": "max_allowed_packet",
670            "currentValue": "16777216",
671            "needReboot": false,
672            "defaultValue": "4194304",
673            "valueType": "RANGE",
674            "acceptableValue": [
675                "1024",
676                "1073741824"
677            ],
678            "rejectedValue": [],
679            "description": "Maximum size of a network packet, in bytes."
680        },
681        {
682            "name": "ob_query_timeout",
683            "currentValue": "10000000",
684            "needReboot": false,
685            "defaultValue": "100000000000000",
686            "valueType": "RANGE",
687            "acceptableValue": [
688                "10000",
689                "100000000000000"
690            ],
691            "rejectedValue": [],
692            "description": "Query timeout duration, in microseconds."
693        },
694        {
695            "name": "sql_plan_management_mode",
696            "currentValue": "OnlineEvolve",
697            "needReboot": false,
698            "defaultValue": "Disable",
699            "valueType": "ENUM",
700            "acceptableValue": [
701                "Disable",
702                "OnlineEvolve"
703            ],
704            "rejectedValue": [],
705            "description": "设置SPM功能的工作模式。"
706        },
707        {
708            "name": "sql_throttle_priority",
709            "currentValue": "1",
710            "needReboot": false,
711            "defaultValue": "-1",
712            "valueType": "RANGE",
713            "acceptableValue": [
714                "-1",
715                "999"
716            ],
717            "rejectedValue": [],
718            "description": "SQL will not be executed if the priority is lower than this threshold."
719        },
720        {
721            "name": "ob_plan_cache_evict_high_percentage",
722            "currentValue": "90",
723            "needReboot": false,
724            "defaultValue": "90",
725            "valueType": "RANGE",
726            "acceptableValue": [
727                "0",
728                "100"
729            ],
730            "rejectedValue": [],
731            "description": "Memory usage percentage that triggers eviction of plan cache entries."
732        },
733        {
734            "name": "explicit_defaults_for_timestamp",
735            "currentValue": "ON",
736            "needReboot": false,
737            "defaultValue": "ON",
738            "valueType": "ENUM",
739            "acceptableValue": [
740                "OFF",
741                "ON"
742            ],
743            "rejectedValue": [],
744            "description": "Specifies whether to enable non-standard behaviors for processing default values and NULL values in TIMESTAMP columns."
745        },
746        {
747            "name": "optimizer_use_sql_plan_baselines",
748            "currentValue": "OFF",
749            "needReboot": false,
750            "defaultValue": "OFF",
751            "valueType": "ENUM",
752            "acceptableValue": [
753                "OFF",
754                "ON"
755            ],
756            "rejectedValue": [],
757            "description": "Specifies whether the optimizer uses the plan baseline."
758        },
759        {
760            "name": "sql_warnings",
761            "currentValue": "OFF",
762            "needReboot": false,
763            "defaultValue": "OFF",
764            "valueType": "ENUM",
765            "acceptableValue": [
766                "OFF",
767                "ON"
768            ],
769            "rejectedValue": [],
770            "description": "Specifies whether to generate an information string for single-row INSERT statements in the event of an alert."
771        },
772        {
773            "name": "group_concat_max_len",
774            "currentValue": "1024",
775            "needReboot": false,
776            "defaultValue": "1024",
777            "valueType": "RANGE",
778            "acceptableValue": [
779                "4",
780                "9007199254740991"
781            ],
782            "rejectedValue": [],
783            "description": "The maximum length in bytes allowed for the result of the GROUP_CONCAT() function."
784        },
785        {
786            "name": "sql_throttle_current_priority",
787            "currentValue": "100",
788            "needReboot": false,
789            "defaultValue": "100",
790            "valueType": "RANGE",
791            "acceptableValue": [
792                "1",
793                "999"
794            ],
795            "rejectedValue": [],
796            "description": "Current priority level for SQL throttling."
797        }
798    ]
799}