查看数据库参数模板

描述


该接口返回参数模板列表，包含参数名、参数默认值、是否可修改、是否需要重启才能生效、参数校验规则（正则表达式）。

[backcolor=transparent]说明：该接口只适用于MySQL和SQL Server类型的数据库。

• 
  请求示例
  1. [backcolor=transparent] https[backcolor=transparent] :[backcolor=transparent] //rds.aliyuncs.com/?Action=DescribeParameterTemplates
  2. [backcolor=transparent]&[backcolor=transparent]Engine[backcolor=transparent]=[backcolor=transparent]SQLServer
  3. [backcolor=transparent]&[backcolor=transparent]EngineVersion[backcolor=transparent]=[backcolor=transparent]2008r2
  4. [backcolor=transparent]&<公共请求参数>
• 
  返回示例
  XML格式：
  1. [backcolor=transparent] <DescribeParameterTemplatesResponse>
  2. [backcolor=transparent]  [backcolor=transparent]<Engine>[backcolor=transparent]mssql[backcolor=transparent]</Engine>
  3. [backcolor=transparent]  [backcolor=transparent]<EngineVersion>[backcolor=transparent]2008r2[backcolor=transparent]</EngineVersion>
  4. [backcolor=transparent]  [backcolor=transparent]<ParameterCount>[backcolor=transparent]1[backcolor=transparent]</ParameterCount>
  5. [backcolor=transparent]  [backcolor=transparent]<Parameters>
  6. [backcolor=transparent]    [backcolor=transparent]<TemplateRecord>
  7. [backcolor=transparent]    [backcolor=transparent]<CheckingCode>[backcolor=transparent][0-100][backcolor=transparent]</CheckingCode>
  8. [backcolor=transparent]    [backcolor=transparent]<ForceRestart>[backcolor=transparent]True[backcolor=transparent]</ForceRestart>
  9. [backcolor=transparent]    [backcolor=transparent]<Factor>[backcolor=transparent]1[backcolor=transparent]</Factor>
  10. [backcolor=transparent]    [backcolor=transparent]<ParameterDescription>[backcolor=transparent]此选项设置服务器范围内的默认填充因子值。提供填充因子是为了优化索引数据存储和性能。[backcolor=transparent]</ParameterDescription>
  11. [backcolor=transparent]    [backcolor=transparent]<ParameterName>[backcolor=transparent]fill factor[backcolor=transparent]</ParameterName>
  12. [backcolor=transparent]    [backcolor=transparent]<ParameterValue>[backcolor=transparent]0[backcolor=transparent]</ParameterValue>
  13. [backcolor=transparent]    [backcolor=transparent]<ForceModify>[backcolor=transparent]True[backcolor=transparent]</ForceModify>
  14. [backcolor=transparent]    [backcolor=transparent]<Unit>[backcolor=transparent]INT[backcolor=transparent]</Unit>
  15. [backcolor=transparent]    [backcolor=transparent]</TemplateRecord>
  16. [backcolor=transparent]  [backcolor=transparent]</Parameters>
  17. [backcolor=transparent]  [backcolor=transparent]<RequestId>[backcolor=transparent]7B96585A-0FF2-4979-8FE5-7D147A29FDC0[backcolor=transparent]</RequestId>
  18. [backcolor=transparent]</DescribeParameterTemplatesResponse>
  
  JSON格式：
  1. [backcolor=transparent]{
  2. [backcolor=transparent]"Engine"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]"mssql"[backcolor=transparent],[backcolor=transparent]
  3. [backcolor=transparent]"EngineVersion"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]"2008r2"[backcolor=transparent],[backcolor=transparent]
  4. [backcolor=transparent]"ParameterCount"[backcolor=transparent]:[backcolor=transparent]1
  5. [backcolor=transparent]  [backcolor=transparent]"Parameters"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]{
  6. [backcolor=transparent]         [backcolor=transparent]"TemplateRecord"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent][
  7. [backcolor=transparent]            [backcolor=transparent]{
  8. [backcolor=transparent]              [backcolor=transparent]"ParameterDescription"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]"此选项设置服务器范围内的默认填充因子值。提供填充因子是为了优化索引数据存储和性能。"[backcolor=transparent],[backcolor=transparent]
  9. [backcolor=transparent]              [backcolor=transparent]"ForceRestart"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]"True"[backcolor=transparent],[backcolor=transparent]
  10. [backcolor=transparent]              [backcolor=transparent]"CheckingCode"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]"[0-100]"
  11. [backcolor=transparent]              [backcolor=transparent]"Factor"[backcolor=transparent]:[backcolor=transparent]"1"
  12. [backcolor=transparent]              [backcolor=transparent]"ParameterName"[backcolor=transparent]:[backcolor=transparent]"fill factor"
  13. [backcolor=transparent]              [backcolor=transparent]"ParameterValue"[backcolor=transparent]:[backcolor=transparent]"0"
  14. [backcolor=transparent]              [backcolor=transparent]"ForceModify"[backcolor=transparent]:[backcolor=transparent]"True"
  15. [backcolor=transparent]              [backcolor=transparent]"Unit"[backcolor=transparent]:[backcolor=transparent]"INT"
  16. [backcolor=transparent]           [backcolor=transparent]}
  17. [backcolor=transparent]          [backcolor=transparent]]
  18. [backcolor=transparent]       [backcolor=transparent]},[backcolor=transparent]
  19. [backcolor=transparent]  [backcolor=transparent]"RequestId"[backcolor=transparent]:[backcolor=transparent] [backcolor=transparent]"7B96585A-0FF2-4979-8FE5-7D147A29FDC0"
  20. [backcolor=transparent]}