云数据库SQL Server实例不支持修改参数，MySQL实例支持修改参数，具体参数列表见下文MySQL参数列表

修改参数

1.     登录蜘蛛云控制台

2.     左侧菜单选择云数据库，然后点击管理 

3.     在云数据库详情页面最右侧点击参数设置 

4.     修改参数后，点击预览，预览修改的参数

5.     点击保存，保存参数修改

导入参数

1.     在参数设置页面，更多操作->导入参数 

2.     在导入参数弹出窗口，单击确定导入参数

·         多参数导入, 请以换行形式进行

·         导入参数值为字符时参数名与参数值之间不能有空格，如binlog_checksum=CRC32

·         支持导入的参数见下文MySQL参数列表

MySQL参数列表

1.  auto_increment_increment= 10

2.  auto_increment_offset= 5

3.  back_log= 3000

4.  binlog_cache_size= 2097152

5.  binlog_checksum=CRC32

6.  binlog_order_commits=ON

7.  binlog_rows_query_log_events=OFF

8.  binlog_row_image=full

9.  binlog_stmt_cache_size=32768

10. block_encryption_mode="aes-128-ecb"

11. bulk_insert_buffer_size=4194304

12. character_set_client=utf8

13. character_set_filesystem=binary

14. character_set_server=utf8

15. concurrent_insert=1

16. connect_timeout=10

17. default_storage_engine=InnoDB

18. default_time_zone=SYSTEM

19. default_week_format=0

20. delayed_insert_limit=100

21. delayed_insert_timeout=300

22. delayed_queue_size=1000

23. delay_key_write=ON

24. disconnect_on_expired_password=ON

25. div_precision_increment=4

26. end_markers_in_json=OFF

27. eq_range_index_dive_limit=10

28. explicit_defaults_for_timestamp=false

29. flush_time=0

30. ft_max_word_len=84

31. ft_min_word_len=4

32. ft_query_expansion_limit=20

33. group_concat_max_len=1024

34. host_cache_size=643

35. innodb_adaptive_flushing=ON

36. innodb_adaptive_flushing_lwm=10

37. innodb_adaptive_hash_index=ON

38. innodb_adaptive_max_sleep_delay=150000

39. innodb_additional_mem_pool_size=2097152

40. innodb_autoextend_increment=64

41. innodb_autoinc_lock_mode=2

42. innodb_buffer_pool_dump_at_shutdown=OFF

43. innodb_buffer_pool_instances=8

44. innodb_buffer_pool_load_at_startup=OFF

45. innodb_change_buffering=all

46. innodb_change_buffer_max_size=25

47. innodb_checksum_algorithm=innodb

48. innodb_cmp_per_index_enabled=OFF

49. innodb_commit_concurrency=0

50. innodb_compression_failure_threshold_pct=5

51. innodb_compression_level=6

52. innodb_compression_pad_pct_max=50

53. innodb_concurrency_tickets=5000

54. innodb_disable_sort_file_cache=ON

55. innodb_flush_method=O_DIRECT

56. innodb_flush_neighbors=1

57. innodb_ft_cache_size=8000000

58. innodb_ft_enable_diag_print=OFF

59. innodb_ft_enable_stopword=ON

60. innodb_ft_max_token_size=84

61. innodb_ft_min_token_size=3

62. innodb_ft_num_word_optimize=2000

63. innodb_ft_result_cache_limit=2000000000

64. innodb_ft_sort_pll_degree=2

65. innodb_ft_total_cache_size=640000000

66. innodb_io_capacity=2000

67. innodb_io_capacity_max=4000

68. innodb_large_prefix=OFF

69. innodb_lock_wait_timeout=50

70. innodb_log_compressed_pages=OFF

71. innodb_lru_scan_depth=1024

72. innodb_max_dirty_pages_pct=75

73. innodb_max_dirty_pages_pct_lwm=0

74. innodb_max_purge_lag=0

75. innodb_max_purge_lag_delay=0

76. innodb_monitor_disable=\s

77. innodb_monitor_enable=\s

78. innodb_old_blocks_pct=37

79. innodb_old_blocks_time=1000

80. innodb_online_alter_log_max_size=134217728

81. innodb_open_files=3000

82. innodb_optimize_fulltext_only=OFF

83. innodb_print_all_deadlocks=OFF

84. innodb_purge_batch_size=300

85. innodb_purge_threads=1

86. innodb_random_read_ahead=OFF

87. innodb_read_ahead_threshold=56

88. innodb_read_io_threads=4

89. innodb_rollback_on_timeout=OFF

90. innodb_rollback_segments=128

91. innodb_sort_buffer_size=1048576

92. innodb_spin_wait_delay=6

93. innodb_stats_auto_recalc=ON

94. innodb_stats_method=nulls_equal

95. innodb_stats_on_metadata=OFF

96. innodb_stats_persistent=ON

97. innodb_stats_persistent_sample_pages=20

98. innodb_stats_sample_pages=8

99. innodb_stats_transient_sample_pages=8

100.     innodb_status_output=OFF

101.     innodb_status_output_locks=OFF

102.     innodb_strict_mode=OFF

103.     innodb_support_xa=ON

104.     innodb_sync_array_size=1

105.     innodb_sync_spin_loops=100

106.     innodb_table_locks=ON

107.     innodb_thread_concurrency=0

108.     innodb_thread_sleep_delay=10000

109.     innodb_write_io_threads=4

110.     interactive_timeout=7200

111.     join_buffer_size=262144

112.     key_cache_age_threshold=300

113.     key_cache_block_size=1024

114.     key_cache_division_limit=100

115.     lc_time_names=en_US

116.     lock_wait_timeout=31536000

117.     log_queries_not_using_indexes=OFF

118.     log_throttle_queries_not_using_indexes=0

119.     long_query_time=1

120.     loose_gap_lock_raise_error=OFF

121.     loose_gap_lock_write_log=OFF

122.     loose_max_statement_time=0

123.     loose_optimizer_trace=enabled=off,one_line=off

124.     loose_optimizer_trace_features=greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on

125.     loose_rds_indexstat=OFF

126.     loose_rds_max_tmp_disk_space=10737418240

127.     loose_rds_set_connection_id_enabled=ON

128.     loose_rds_tablestat=OFF

129.     loose_rds_threads_running_high_watermark=50000

130.     loose_thread_handling="one-thread-per-connection"

131.     loose_thread_pool_oversubscribe=10

132.     loose_thread_pool_size=64

133.     loose_thread_pool_stall_limit=30

134.     loose_tokudb_auto_analyze=30

135.     loose_tokudb_buffer_pool_ratio=0

136.     loose_validate_password_length=8

137.     low_priority_updates=0

138.     master_verify_checksum=OFF

139.     max_allowed_packet=1073741824

140.     max_binlog_stmt_cache_size=18446744073709547520

141.     max_connect_errors=100

142.     max_error_count=64

143.     max_heap_table_size=16777216

144.     max_join_size=18446744073709551615

145.     max_length_for_sort_data=1024

146.     max_prepared_stmt_count=16382

147.     max_seeks_for_key=18446744073709500000

148.     max_sort_length=1024

149.     max_sp_recursion_depth=0

150.     max_write_lock_count=102400

151.     metadata_locks_cache_size=1024

152.     min_examined_row_limit=0

153.     myisam_sort_buffer_size=262144

154.     net_buffer_length=16384

155.     net_read_timeout=30

156.     net_retry_count=10

157.     net_write_timeout=60

158.     old_passwords=0

159.     open_files_limit=65535

160.     optimizer_prune_level=1

161.     optimizer_search_depth=62

162.     optimizer_trace_limit=1

163.     optimizer_trace_max_mem_size=16384

164.     optimizer_trace_offset=-1

165.     performance_schema=OFF

166.     preload_buffer_size=32768

167.     query_alloc_block_size=8192

168.     query_cache_limit=1048576

169.     query_cache_min_res_unit=4096

170.     query_cache_size=3145728

171.     query_cache_type=0

172.     query_cache_wlock_invalidate=OFF

173.     query_prealloc_size=8192

174.     range_alloc_block_size=4096

175.     rds_reset_all_filter=0

176.     slave_net_timeout=60

177.     slow_launch_time=2

178.     slow_query_log=ON

179.     sort_buffer_size=262144

180.     sql_mode=\s

181.     stored_program_cache=256

182.     table_definition_cache=512

183.     table_open_cache=2000

184.     table_open_cache_instances=1

185.     thread_cache_size=100

186.     thread_stack=262144

187.     tls_version=TLSv1,TLSv1.1,TLSv1.2

188.     tmp_table_size=2097152

189.     transaction_alloc_block_size=8192

190.     transaction_isolation=READ-COMMITTED

191.     transaction_prealloc_size=4096

192.     updatable_views_with_limit=YES

193.     wait_timeout=86400