{"id":2067,"date":"2020-07-29T23:32:17","date_gmt":"2020-07-29T15:32:17","guid":{"rendered":"http:\/\/39.97.231.10\/?p=2067"},"modified":"2020-07-29T23:32:17","modified_gmt":"2020-07-29T15:32:17","slug":"mysql-8-0-%e6%96%b0%e5%a2%9e%e7%9a%84%e9%85%8d%e7%bd%ae%e5%8f%82%e6%95%b0","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=2067","title":{"rendered":"MySQL 8.0 \u65b0\u589e\u7684\u914d\u7f6e\u53c2\u6570"},"content":{"rendered":"<div class=\\\"blog_title\\\">\n<div>\n<span style=\\\"font-size: 1rem;\\\">MySQL 8.0 \u589e\u52a0\u4e86\u8bb8\u591a\u65b0\u7684\u7279\u6027\u548c\u529f\u80fd\uff0c\u4e0e\u6b64\u540c\u65f6\u4e5f\u5f15\u5165\u4e86\u8bb8\u591a\u65b0\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u672c\u6587\u6c47\u603b\u4e86MySQL 8.0 \u65b0\u589e\u52a0\u7684\u53c2\u6570\uff0c\u5e76\u6309\u529f\u80fd\u8fdb\u884c\u4e86\u5206\u7c7b\u3002\u622a\u6b628.0.20\u7248\u672c\u3002<\/span>\n<\/div>\n<\/div>\n<div class=\\\"blog_content\\\">\n<div class=\\\"blog_detail\\\">\n<h4>1. Binlog<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>binlog_encryption<\/li>\n<li>binlog_expire_logs_seconds<\/li>\n<li>binlog_rotate_encryption_master_key_at_startup<\/li>\n<li>binlog_row_metadata<\/li>\n<li>binlog_row_value_options<\/li>\n<li>binlog_transaction_compression<\/li>\n<li>binlog_transaction_compression_level_zstd<\/li>\n<li>binlog_transaction_dependency_history_size<\/li>\n<li>binlog_transaction_dependency_tracking<\/li>\n<\/ul>\n<h4>2. InnoDB<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>innodb_dedicated_server<\/li>\n<li>innodb_directories<\/li>\n<li>innodb_fsync_threshold<\/li>\n<li>innodb_idle_flush_pct<\/li>\n<li>innodb_log_checkpoint_fuzzy_now\uff08WITH_DEBUG\u7f16\u8bd1\u9009\u9879\u4e0b\u53ef\u7528\uff09<\/li>\n<li>innodb_log_spin_cpu_abs_lwm<\/li>\n<li>innodb_log_spin_cpu_pct_hwm<\/li>\n<li>innodb_log_wait_for_flush_spin_hwm<\/li>\n<li>innodb_log_writer_threads\uff088.0.22\u7248\u672c\uff09<\/li>\n<li>innodb_parallel_read_threads<\/li>\n<li>innodb_print_ddl_logs<\/li>\n<li>innodb_redo_log_archive_dirs<\/li>\n<li>innodb_redo_log_encrypt<\/li>\n<li>innodb_spin_wait_pause_multiplier<\/li>\n<li>innodb_stats_include_delete_marked<\/li>\n<li>innodb_temp_tablespaces_dir<\/li>\n<li>innodb_tmpdir<\/li>\n<li>innodb_undo_log_encrypt<\/li>\n<li>innodb_buffer_pool_in_core_file<\/li>\n<li>innodb_doublewrite_batch_size<\/li>\n<li>innodb_doublewrite_dir<\/li>\n<li>innodb_doublewrite_files<\/li>\n<li>innodb_doublewrite_pages<\/li>\n<li>innodb_buffer_pool_debug\uff08WITH_DEBUG\u7f16\u8bd1\u9009\u9879\u4e0b\u53ef\u7528\uff09<\/li>\n<li>innodb_checkpoint_disabled\uff08WITH_DEBUG\u7f16\u8bd1\u9009\u9879\u4e0b\u53ef\u7528\uff09<\/li>\n<li>innodb_ddl_log_crash_reset_debug\uff08WITH_DEBUG\u7f16\u8bd1\u9009\u9879\u4e0b\u53ef\u7528\uff09<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Innodb_system_rows_deleted<\/li>\n<li>Innodb_system_rows_inserted<\/li>\n<li>Innodb_system_rows_read<\/li>\n<li>Innodb_undo_tablespaces_active<\/li>\n<li>Innodb_undo_tablespaces_explicit<\/li>\n<li>Innodb_undo_tablespaces_implicit<\/li>\n<li>Innodb_undo_tablespaces_total<\/li>\n<\/ul>\n<h4>3. \u514b\u9686\u529f\u80fd<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>clone_autotune_concurrency<\/li>\n<li>clone_buffer_size<\/li>\n<li>clone_ddl_timeout<\/li>\n<li>clone_enable_compression<\/li>\n<li>clone_max_concurrency<\/li>\n<li>clone_max_data_bandwidth<\/li>\n<li>clone_max_network_bandwidth<\/li>\n<li>clone_ssl_ca<\/li>\n<li>clone_ssl_cert<\/li>\n<li>clone_ssl_key<\/li>\n<li>clone_valid_donor_list<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Com_clone<\/li>\n<\/ul>\n<h4>4. \u7ec4\u590d\u5236<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>group_replication_autorejoin_tries<\/li>\n<li>group_replication_clone_threshold<\/li>\n<li>group_replication_communication_debug_options<\/li>\n<li>group_replication_communication_max_message_size<\/li>\n<li>group_replication_consistency<\/li>\n<li>group_replication_exit_state_action<\/li>\n<li>group_replication_flow_control_hold_percent<\/li>\n<li>group_replication_flow_control_max_quota<\/li>\n<li>group_replication_flow_control_member_quota_percent<\/li>\n<li>group_replication_flow_control_min_quota<\/li>\n<li>group_replication_flow_control_min_recovery_quota<\/li>\n<li>group_replication_flow_control_period<\/li>\n<li>group_replication_flow_control_release_percent<\/li>\n<li>group_replication_member_expel_timeout<\/li>\n<li>group_replication_member_weight<\/li>\n<li>group_replication_message_cache_size<\/li>\n<li>group_replication_recovery_compression_algorithms<\/li>\n<li>group_replication_recovery_get_public_key<\/li>\n<li>group_replication_recovery_public_key_path<\/li>\n<li>group_replication_recovery_tls_ciphersuites<\/li>\n<li>group_replication_recovery_tls_version<\/li>\n<li>group_replication_recovery_zstd_compression_level<\/li>\n<li>group_replication_unreachable_majority_timeout<\/li>\n<\/ul>\n<h4>5. \u89d2\u8272\u529f\u80fd<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>activate_all_roles_on_login<\/li>\n<li>mandatory_roles<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Com_alter_user_default_role<\/li>\n<li>Com_create_role<\/li>\n<li>Com_drop_role<\/li>\n<li>Com_grant_roles<\/li>\n<li>Com_revoke_roles<\/li>\n<li>Com_set_role<\/li>\n<\/ul>\n<h4>6. \u8d44\u6e90\u7ec4<\/h4>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Com_alter_resource_group<\/li>\n<li>Com_create_resource_group<\/li>\n<li>Com_drop_resource_group<\/li>\n<li>Com_set_resource_group<\/li>\n<\/ul>\n<h4>7. CTE<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>cte_max_recursion_depth<\/li>\n<\/ul>\n<h4>8. \u76f4\u65b9\u56fe<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>histogram_generation_max_mem_size<\/li>\n<\/ul>\n<h4>9. \u6b63\u5219\u8868\u8fbe\u5f0f<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>regexp_stack_limit<\/li>\n<li>regexp_time_limit<\/li>\n<\/ul>\n<h4>10. \u7a97\u53e3\u51fd\u6570<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>windowing_use_high_precision<\/li>\n<\/ul>\n<h4>11. \u538b\u7f29\u529f\u80fd\uff1a<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>protocol_compression_algorithms<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Compression_algorithm\uff08session\u7ea7\uff09<\/li>\n<li>Compression_level\uff08session\u7ea7\uff09<\/li>\n<\/ul>\n<h4>12. \u7ba1\u7406\u7aef\u53e3\uff1a<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>admin_address<\/li>\n<li>admin_port<\/li>\n<li>create_admin_listener_thread<\/li>\n<\/ul>\n<h4>13. caching_sha2_password<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>caching_sha2_password_auto_generate_rsa_keys<\/li>\n<li>caching_sha2_password_private_key_path<\/li>\n<li>caching_sha2_password_public_key_path<br \/>\n<strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/li>\n<li>Caching_sha2_password_rsa_public_key<\/li>\n<\/ul>\n<h4>14. Mysqlx<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>mysqlx<\/li>\n<li>mysqlx_compression_algorithms<\/li>\n<li>mysqlx_deflate_default_compression_level<\/li>\n<li>mysqlx_deflate_max_client_compression_level<\/li>\n<li>mysqlx_interactive_timeout<\/li>\n<li>mysqlx_lz4_default_compression_level<\/li>\n<li>mysqlx_lz4_max_client_compression_level<\/li>\n<li>mysqlx_read_timeout<\/li>\n<li>mysqlx_wait_timeout<\/li>\n<li>mysqlx_write_timeout<\/li>\n<li>mysqlx_zstd_default_compression_level<\/li>\n<li>mysqlx_zstd_max_client_compression_level<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Mysqlx_bytes_received_compressed_payload<\/li>\n<li>Mysqlx_bytes_received_uncompressed_frame<\/li>\n<li>Mysqlx_bytes_sent_compressed_payload<\/li>\n<li>Mysqlx_bytes_sent_uncompressed_frame<\/li>\n<li>Mysqlx_compression_algorithm<\/li>\n<li>Mysqlx_compression_level<\/li>\n<\/ul>\n<h4>15. tls<\/h4>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>tls_ciphersuites<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Current_tls_ca<\/li>\n<li>Current_tls_capath<\/li>\n<li>Current_tls_cert<\/li>\n<li>Current_tls_cipher<\/li>\n<li>Current_tls_ciphersuites<\/li>\n<li>Current_tls_crl<\/li>\n<li>Current_tls_crlpath<\/li>\n<li>Current_tls_key<\/li>\n<li>Current_tls_version<\/li>\n<\/ul>\n<h4>16. Secondary_engine<\/h4>\n<p><strong>\u53c2\u6570\u914d\u7f6e\uff1a<\/strong><\/p>\n<ul>\n<li>secondary_engine_cost_threshold\uff08\u672a\u6765\u4f7f\u7528\uff09<\/li>\n<li>use_secondary_engine\uff08\u672a\u6765\u4f7f\u7528\uff09<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Secondary_engine_execution_count\uff08\u672a\u6765\u4f7f\u7528<\/li>\n<\/ul>\n<h4>17. \u5176\u4ed6<\/h4>\n<p><strong>\u547d\u4ee4\u884c\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>early-plugin-load<\/li>\n<li>upgrade<\/li>\n<li>validate-config<\/li>\n<\/ul>\n<p><strong>\u914d\u7f6e\u53c2\u6570\uff1a<\/strong><\/p>\n<ul>\n<li>default_collation_for_utf8mb4<\/li>\n<li>internal_tmp_mem_storage_engine<\/li>\n<li>default_table_encryption<\/li>\n<li>generated_random_password_length<\/li>\n<li>immediate_server_version\uff08session\u7ea7\u53c2\u6570\uff09<\/li>\n<li>information_schema_stats_expiry<\/li>\n<li>log_error_services<\/li>\n<li>log_error_suppression_list<\/li>\n<li>log_slow_extra<\/li>\n<li>original_commit_timestamp\uff08session\u7ea7\u53c2\u6570\uff09<\/li>\n<li>original_server_version\uff08session\u7ea7\u53c2\u6570\uff09<\/li>\n<li>partial_revokes<\/li>\n<li>password_history<\/li>\n<li>password_require_current<\/li>\n<li>password_reuse_interval<\/li>\n<li>performance_schema_max_digest_sample_age<\/li>\n<li>persist_only_admin_x509_subject<\/li>\n<li>persisted_globals_load<\/li>\n<li>print_identified_with_as_hex<\/li>\n<li>require_row_format\uff08session\u7ea7\u53c2\u6570\uff09<\/li>\n<li>resultset_metadata<\/li>\n<li>rpl_read_size<\/li>\n<li>show_create_table_skip_secondary_engine<\/li>\n<li>show_create_table_verbosity<\/li>\n<li>sql_require_primary_key<\/li>\n<li>ssl_fips_mode<\/li>\n<li>table_encryption_privilege_check<\/li>\n<li>temptable_max_ram<\/li>\n<li>temptable_use_mmap<\/li>\n<li>version_compile_zlib<\/li>\n<\/ul>\n<p><strong>\u72b6\u6001\u53d8\u91cf\uff1a<\/strong><\/p>\n<ul>\n<li>Acl_cache_items_count<\/li>\n<li>Com_install_component<\/li>\n<li>Com_uninstall_component<\/li>\n<li>Com_restart<\/li>\n<\/ul>\n<p><strong>\u5907\u6ce8\uff1a<\/strong><br \/>\n\u4f01\u4e1a\u7248\u5ba1\u8ba1\u529f\u80fd\u3001\u9632\u706b\u5899\u3001\u7ebf\u7a0b\u6c60\u4ee5\u53ca\u4e00\u4e9b\u4e0d\u5e38\u7528\u7684\u63d2\u4ef6\uff0c\u6bd4\u5982connection_control\u3001keyring\u3001validate_password\u7b49\u7b49\u672a\u8fdb\u884c\u7edf\u8ba1\u3002\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL 8.0 \u589e\u52a0\u4e86\u8bb8\u591a\u65b0\u7684\u7279\u6027\u548c\u529f\u80fd\uff0c\u4e0e\u6b64\u540c\u65f6\u4e5f\u5f15\u5165\u4e86\u8bb8\u591a\u65b0\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u672c\u6587\u6c47\u603b\u4e86MySQL 8.0  &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.weijing.co\/?p=2067\"> <span class=\"screen-reader-text\">MySQL 8.0 \u65b0\u589e\u7684\u914d\u7f6e\u53c2\u6570<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90,88],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"MySQL 8.0 \u589e\u52a0\u4e86\u8bb8\u591a\u65b0\u7684\u7279\u6027\u548c\u529f\u80fd\uff0c\u4e0e\u6b64\u540c\u65f6\u4e5f\u5f15\u5165\u4e86\u8bb8\u591a\u65b0\u7684\u914d\u7f6e\u53c2\u6570\uff0c\u672c\u6587\u6c47\u603b\u4e86MySQL 8.0 &hellip;","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/2067"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2067"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/2067\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2067"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}