MySQL实例自定义参数设置 |
云数据库SQL Server实例不支持修改参数,MySQL实例支持修改参数,具体参数列表见下文MySQL参数列表 修改参数1. 登录蜘蛛云控制台 2. 左侧菜单选择云数据库,然后点击管理 3. 在云数据库详情页面最右侧点击参数设置 4. 修改参数后,点击预览,预览修改的参数
5. 点击保存,保存参数修改 导入参数1. 在参数设置页面,更多操作->导入参数 2. 在导入参数弹出窗口,单击确定导入参数 · 多参数导入, 请以换行形式进行 · 导入参数值为字符时参数名与参数值之间不能有空格,如 · 支持导入的参数见下文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
|