蜘蛛云 - 企业级云服务器、服务器租用托管服务提供商
41
产品文档
APP服务
对象存储
云计算
云服务器
业务合作
网站服务
IDC服务
备案服务
会员服务
财务相关
蜘蛛云规则
MySQL实例自定义参数设置

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

修改参数

1.     登录蜘蛛云控制台

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

)A}UMWE7EZ@OF~Q[A_I2A~H.png

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

image.png

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

image.png 

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

导入参数

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

image.png

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

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

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

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

image.png

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


 


这条帮助是否解决了您的问题? 已解决 未解决

提交成功!非常感谢您的反馈,我们会继续努力做到更好! 很抱歉未能解决您的疑问。我们已收到您的反馈意见,同时会及时作出反馈处理!