Mariadb
MariaDB 10.5.8 記憶體洩漏 (MyISAM) 在主伺服器上而不是從伺服器上
我們最近將一個遺留應用程序從 Amazon Linux 上的 MySQL 5.5 遷移到 Amazon Linux 2 上的 MariaDB 10.5.8（最新，來自官方儲存庫）。“硬體”從 m3.large 實例變為 m5.large 實例（兩個 8GB RAM，2 個 CPU）。
該應用程序對其 18G 數據集的絕大多數使用 MyISAM 表。
遷移中沒有更改任何 MariaDB 配置選項；應用程序和配置設置與舊伺服器相同（愉快地執行了數月/數年而沒有洩漏）
升級後，我們看到 mariadbd RSS 線性增長，直到 OOM 被核心殺死。從伺服器啟動到該點大約需要 48 小時：
上面的圖顯示了主，下面的圖顯示了複製從屬（它似乎沒有表現出這種洩漏；或者至少慢得多，慢得多）。主伺服器回答使用者的查詢。無論如何，它都不是“高負載”應用程序；它在我們一直在使用的中等功率的實例上執行良好。
數據通過轉儲/恢復傳輸到新伺服器；我們沒有嘗試複製和升級 MySQL 數據文件。
主伺服器 mysqltuner 的輸出、配置和顯示全域狀態如下：
調諧器
# perl mysqltuner.pl >> MySQLTuner 1.7.20 - Major Hayden <major@mhtx.net> [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 10.5.8-MariaDB-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE [--] Data in MyISAM tables: 17.1G (Tables: 169) [--] Data in InnoDB tables: 3.5M (Tables: 10) [--] Data in MEMORY tables: 0B (Tables: 5) [OK] Total fragmented tables: 0 -------- Analysis Performance Metrics -------------------------------------------------------------- [--] innodb_stats_on_metadata: OFF [OK] No stat updates during querying INFORMATION_SCHEMA. -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 1d 1h 24m 53s (29M q [325.984 qps], 1M conn, TX: 21G, RX: 7G) [--] Reads / Writes: 59% / 41% [--] Binary logging is enabled (GTID MODE: OFF) [--] Physical Memory : 7.5G [--] Max MySQL memory : 8.8G [--] Other process memory: 0B [--] Total buffers: 1.3G global + 50.7M per thread (150 max threads) [--] P_S Max memory usage: 72B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 5.4G (72.66% of installed RAM) [!!] Maximum possible memory usage: 8.8G (116.85% of installed RAM) [!!] Overall possible memory usage with other process exceeded memory [OK] Slow queries: 0% (11/29M) [OK] Highest usage of available connections: 55% (83/150) [OK] Aborted connections: 0.00% (0/1810983) [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance [!!] Query cache may be disabled by default due to mutex contention. [OK] Query cache efficiency: 43.7% (9M cached / 21M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 245K sorts) [!!] Joins performed without indexes: 513 [!!] Temporary tables created on disk: 72% (45K on disk / 62K total) [OK] Thread cache hit rate: 99% (3K created / 1M connections) [OK] Table cache hit rate: 37% (350 open / 928 opened) [OK] table_definition_cache(400) is upper than number of tables(375) [OK] Open file limit used: 1% (526/32K) [OK] Table locks acquired immediately: 99% (10M immediate / 11M locks) [OK] Binlog cache memory access: 100.00% (18402 Memory / 18402 Total) -------- Performance schema ------------------------------------------------------------------------ [--] Memory used by P_S: 72B [--] Sys schema isn't installed. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is enabled. [--] Thread Pool Size: 2 thread(s). [--] Using default value is good enough for your version (10.5.8-MariaDB-log) -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 40.7% (437M used / 1B cache) [OK] Key buffer size / total MyISAM indexes: 1.0G/4.0G [OK] Read Key buffer hit rate: 100.0% (809M cached / 259K reads) [!!] Write Key buffer hit rate: 77.1% (58M cached / 44M writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [--] InnoDB Thread Concurrency: 0 [OK] InnoDB File per table is activated [OK] InnoDB buffer pool / data size: 16.0M/3.5M [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (200 %): 32.0M * 1/16.0M should be equal to 25% [--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s) [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances [OK] InnoDB Read buffer efficiency: 99.90% (507276 hits/ 507766 total) [!!] InnoDB Write Log efficiency: 7109.49% (54672 hits/ 769 total) [OK] InnoDB log waits: 0.00% (0 waits / 55441 writes) -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is enabled. [OK] Aria pagecache size / total Aria indexes: 128.0M/336.0K [OK] Aria pagecache hit rate: 96.3% (1M cached / 45K reads) -------- TokuDB Metrics ---------------------------------------------------------------------------- [--] TokuDB is disabled. -------- XtraDB Metrics ---------------------------------------------------------------------------- [--] XtraDB is disabled. -------- Galera Metrics ---------------------------------------------------------------------------- [--] Galera is disabled. -------- Replication Metrics ----------------------------------------------------------------------- [--] Galera Synchronous replication: NO [--] This server is acting as master for 2 server(s). [--] Binlog format: ROW [--] XA support enabled: ON [--] Semi synchronous replication Master: OFF [--] Semi synchronous replication Slave: OFF [--] No replication setup for this server or replication not started. -------- Recommendations --------------------------------------------------------------------------- Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_size (=0) query_cache_type (=0) join_buffer_size (> 16.0M, or always use indexes with JOINs) tmp_table_size (> 128M) max_heap_table_size (> 128M) innodb_log_file_size should be (=4M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.配置
--port=3306 \ --slave-sql-verify-checksum=0 \ --user=wmysql \ --log-slave-updates=1 \ --slave-net-timeout=60 \ --wait_timeout=31536000 \ --interactive_timeout=31536000 \ --key-buffer-size=1024M \ --query_cache_size=64M \ --query-cache-limit=256000 \ --thread_cache_size=16 \ --table_open_cache=2000 \ --master-retry-count=120960 \ --max-connections=150 \ --max-allowed-packet=32M \ --open-files-limit=2048 \ --ft-min-word-len=2 \ --binlog-format=ROW \ --binlog_annotate_row_events=OFF \ --join_buffer_size=16M \ --sql-mode=NO_ENGINE_SUBSTITUTION \ --character-set-server=utf8 \ --collation-server=utf8_general_ci \ --performance_schema=1 \ --tmp_table_size=128M \ --max_heap_table_size=128M \ --sync-binlog=0 \ --sync-relay-log=0 \ --sync-relay-log-info=0 \ --sync-master-info=0 \ --innodb_buffer_pool_size=16M \ --innodb_log_file_size=32M \ --innodb-flush-log-at-trx-commit=2 \ --innodb-flush-neighbors=0 \ --innodb-flush-method=O_DIRECT \顯示全球狀態
Variable_name Value Aborted_clients 15 Aborted_connects 0 Aborted_connects_preauth 0 Access_denied_errors 0 Acl_column_grants 0 Acl_database_grants 35 Acl_function_grants 0 Acl_procedure_grants 0 Acl_package_spec_grants 0 Acl_package_body_grants 0 Acl_proxy_users 2 Acl_role_grants 0 Acl_roles 0 Acl_table_grants 3 Acl_users 23 Aria_pagecache_blocks_not_flushed 0 Aria_pagecache_blocks_unused 15644 Aria_pagecache_blocks_used 15 Aria_pagecache_read_requests 1228921 Aria_pagecache_reads 45270 Aria_pagecache_write_requests 90307 Aria_pagecache_writes 90241 Aria_transaction_log_syncs 69 Binlog_commits 7261991 Binlog_group_commits 7261607 Binlog_group_commit_trigger_count 0 Binlog_group_commit_trigger_lock_wait 0 Binlog_group_commit_trigger_timeout 0 Binlog_snapshot_file mysql-bin.000019 Binlog_snapshot_position 47873714 Binlog_bytes_written 4776990821 Binlog_cache_disk_use 0 Binlog_cache_use 18446 Binlog_stmt_cache_disk_use 10353 Binlog_stmt_cache_use 7243545 Busy_time 0.000000 Bytes_received 7982669592 Bytes_sent 22995831502 Column_compressions 0 Column_decompressions 0 Com_admin_commands 1545 Com_alter_db 0 Com_alter_db_upgrade 0 Com_alter_event 0 Com_alter_function 0 Com_alter_procedure 0 Com_alter_server 0 Com_alter_sequence 0 Com_alter_table 0 Com_alter_tablespace 0 Com_alter_user 0 Com_analyze 0 Com_assign_to_keycache 0 Com_backup 0 Com_backup_lock 0 Com_begin 0 Com_binlog 0 Com_call_procedure 0 Com_change_db 6026654 Com_change_master 1 Com_check 0 Com_checksum 0 Com_commit 0 Com_compound_sql 0 Com_create_db 0 Com_create_event 0 Com_create_function 0 Com_create_index 0 Com_create_package 0 Com_create_package_body 0 Com_create_procedure 0 Com_create_role 0 Com_create_sequence 0 Com_create_server 0 Com_create_table 26 Com_create_temporary_table 0 Com_create_trigger 0 Com_create_udf 0 Com_create_user 0 Com_create_view 0 Com_dealloc_sql 0 Com_delete 24955 Com_delete_multi 18 Com_do 0 Com_drop_db 0 Com_drop_event 0 Com_drop_function 0 Com_drop_index 0 Com_drop_procedure 0 Com_drop_package 0 Com_drop_package_body 0 Com_drop_role 0 Com_drop_server 0 Com_drop_sequence 0 Com_drop_table 3 Com_drop_temporary_table 0 Com_drop_trigger 0 Com_drop_user 0 Com_drop_view 0 Com_empty_query 0 Com_execute_immediate 0 Com_execute_sql 0 Com_flush 13 Com_get_diagnostics 0 Com_grant 0 Com_grant_role 0 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 4002047 Com_insert_select 0 Com_install_plugin 0 Com_kill 5 Com_load 0 Com_lock_tables 3 Com_multi 0 Com_optimize 0 Com_preload_keys 0 Com_prepare_sql 0 Com_purge 0 Com_purge_before_date 9 Com_release_savepoint 0 Com_rename_table 0 Com_rename_user 0 Com_repair 0 Com_replace 11590 Com_replace_select 0 Com_reset 3 Com_resignal 0 Com_revoke 0 Com_revoke_all 0 Com_revoke_role 0 Com_rollback 0 Com_rollback_to_savepoint 0 Com_savepoint 0 Com_select 11954173 Com_set_option 1825129 Com_show_authors 0 Com_show_binlog_events 0 Com_show_binlogs 0 Com_show_charsets 0 Com_show_collations 0 Com_show_contributors 0 Com_show_create_db 0 Com_show_create_event 0 Com_show_create_func 0 Com_show_create_package 0 Com_show_create_package_body 0 Com_show_create_proc 0 Com_show_create_table 144 Com_show_create_trigger 24 Com_show_create_user 0 Com_show_databases 28 Com_show_engine_logs 0 Com_show_engine_mutex 0 Com_show_engine_status 33 Com_show_errors 0 Com_show_events 0 Com_show_explain 0 Com_show_fields 45938 Com_show_function_status 0 Com_show_generic 0 Com_show_grants 0 Com_show_keys 0 Com_show_binlog_status 0 Com_show_open_tables 4 Com_show_package_status 0 Com_show_package_body_status 0 Com_show_plugins 0 Com_show_privileges 0 Com_show_procedure_status 0 Com_show_processlist 45 Com_show_profile 0 Com_show_profiles 0 Com_show_relaylog_events 0 Com_show_slave_hosts 5 Com_show_slave_status 8 Com_show_status 1569 Com_show_storage_engines 6 Com_show_table_status 72 Com_show_tables 29 Com_show_triggers 0 Com_show_variables 41 Com_show_warnings 0 Com_shutdown 0 Com_signal 0 Com_start_all_slaves 0 Com_start_slave 0 Com_stmt_close 0 Com_stmt_execute 0 Com_stmt_fetch 0 Com_stmt_prepare 0 Com_stmt_reprepare 0 Com_stmt_reset 0 Com_stmt_send_long_data 0 Com_stop_all_slaves 0 Com_stop_slave 2 Com_truncate 0 Com_uninstall_plugin 0 Com_unlock_tables 3 Com_update 4186198 Com_update_multi 0 Com_xa_commit 0 Com_xa_end 0 Com_xa_prepare 0 Com_xa_recover 0 Com_xa_rollback 0 Com_xa_start 0 Compression OFF Connection_errors_accept 0 Connection_errors_internal 0 Connection_errors_max_connections 0 Connection_errors_peer_address 0 Connection_errors_select 0 Connection_errors_tcpwrap 0 Connections 1815529 Cpu_time 0.000000 Created_tmp_disk_tables 45259 Created_tmp_files 14 Created_tmp_tables 62403 Delayed_errors 0 Delayed_insert_threads 1 Delayed_writes 16379090 Delete_scan 59 Empty_queries 2026190 Executed_events 0 Executed_triggers 55791 Feature_application_time_periods 0 Feature_check_constraint 2 Feature_custom_aggregate_functions 0 Feature_delay_key_write 0 Feature_dynamic_columns 0 Feature_fulltext 18 Feature_gis 0 Feature_insert_returning 0 Feature_invisible_columns 0 Feature_json 141092 Feature_locale 0 Feature_subquery 185 Feature_system_versioning 0 Feature_timezone 3 Feature_trigger 74 Feature_window_functions 0 Feature_xml 0 Handler_commit 7302836 Handler_delete 39212 Handler_discover 160 Handler_external_lock 0 Handler_icp_attempts 11736079 Handler_icp_match 7983082 Handler_mrr_init 0 Handler_mrr_key_refills 0 Handler_mrr_rowid_refills 0 Handler_prepare 36892 Handler_read_first 11129 Handler_read_key 237983167 Handler_read_last 0 Handler_read_next 318575614 Handler_read_prev 297124 Handler_read_retry 0 Handler_read_rnd 15437152 Handler_read_rnd_deleted 643 Handler_read_rnd_next 380643982 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_tmp_delete 0 Handler_tmp_update 49715399 Handler_tmp_write 21116241 Handler_update 9560539 Handler_write 16850465 Innodb_adaptive_hash_hash_searches 0 Innodb_adaptive_hash_non_hash_searches 103195 Innodb_background_log_sync 91679 Innodb_buffered_aio_submitted 1 Innodb_buffer_pool_dump_status Innodb_buffer_pool_load_status Buffer pool(s) load completed at 201215 22:57:36 Innodb_buffer_pool_resize_status Innodb_buffer_pool_load_incomplete OFF Innodb_buffer_pool_pages_data 629 Innodb_buffer_pool_bytes_data 10305536 Innodb_buffer_pool_pages_dirty 274 Innodb_buffer_pool_bytes_dirty 4489216 Innodb_buffer_pool_pages_flushed 478 Innodb_buffer_pool_pages_free 379 Innodb_buffer_pool_pages_made_not_young 0 Innodb_buffer_pool_pages_made_young 0 Innodb_buffer_pool_pages_misc 0 Innodb_buffer_pool_pages_old 252 Innodb_buffer_pool_pages_total 1008 Innodb_buffer_pool_pages_lru_flushed 0 Innodb_buffer_pool_read_ahead_rnd 0 Innodb_buffer_pool_read_ahead 0 Innodb_buffer_pool_read_ahead_evicted 0 Innodb_buffer_pool_read_requests 508730 Innodb_buffer_pool_reads 490 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 132317 Innodb_checkpoint_age 3223475 Innodb_checkpoint_max_age 26469643 Innodb_data_fsyncs 18722 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 8044544 Innodb_data_reads 517 Innodb_data_writes 56062 Innodb_data_written 7831749 Innodb_dblwr_pages_written 197 Innodb_dblwr_writes 9 Innodb_deadlocks 0 Innodb_history_list_length 11 Innodb_ibuf_discarded_delete_marks 0 Innodb_ibuf_discarded_deletes 0 Innodb_ibuf_discarded_inserts 0 Innodb_ibuf_free_list 0 Innodb_ibuf_merged_delete_marks 0 Innodb_ibuf_merged_deletes 0 Innodb_ibuf_merged_inserts 8 Innodb_ibuf_merges 1 Innodb_ibuf_segment_size 2 Innodb_ibuf_size 1 Innodb_log_waits 0 Innodb_log_write_requests 769 Innodb_log_writes 55573 Innodb_lsn_current 3860567584 Innodb_lsn_flushed 3860567584 Innodb_lsn_last_checkpoint 3857344109 Innodb_master_thread_active_loops 18381 Innodb_master_thread_idle_loops 73300 Innodb_max_trx_id 22692107 Innodb_mem_adaptive_hash 0 Innodb_mem_dictionary 162336 Innodb_os_log_fsyncs 18678 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 37634048 Innodb_page_size 16384 Innodb_pages_created 139 Innodb_pages_read 490 Innodb_pages_written 477 Innodb_row_lock_current_waits 0 Innodb_row_lock_time 0 Innodb_row_lock_time_avg 0 Innodb_row_lock_time_max 0 Innodb_row_lock_waits 0 Innodb_rows_deleted 46 Innodb_rows_inserted 81 Innodb_rows_read 93598 Innodb_rows_updated 18340 Innodb_system_rows_deleted 2 Innodb_system_rows_inserted 0 Innodb_system_rows_read 5 Innodb_system_rows_updated 0 Innodb_num_open_files 16 Innodb_truncated_status_writes 0 Innodb_available_undo_logs 128 Innodb_undo_truncations 0 Innodb_page_compression_saved 0 Innodb_num_index_pages_written 0 Innodb_num_non_index_pages_written 0 Innodb_num_pages_page_compressed 0 Innodb_num_page_compressed_trim_op 0 Innodb_num_pages_page_decompressed 0 Innodb_num_pages_page_compression_error 0 Innodb_num_pages_encrypted 0 Innodb_num_pages_decrypted 0 Innodb_have_lz4 OFF Innodb_have_lzo OFF Innodb_have_lzma ON Innodb_have_bzip2 OFF Innodb_have_snappy OFF Innodb_have_punch_hole ON Innodb_defragment_compression_failures 0 Innodb_defragment_failures 0 Innodb_defragment_count 0 Innodb_instant_alter_column 0 Innodb_onlineddl_rowlog_rows 0 Innodb_onlineddl_rowlog_pct_used 0 Innodb_onlineddl_pct_progress 0 Innodb_secondary_index_triggered_cluster_reads 21438 Innodb_secondary_index_triggered_cluster_reads_avoided 0 Innodb_encryption_rotation_pages_read_from_cache 0 Innodb_encryption_rotation_pages_read_from_disk 0 Innodb_encryption_rotation_pages_modified 0 Innodb_encryption_rotation_pages_flushed 0 Innodb_encryption_rotation_estimated_iops 0 Innodb_encryption_key_rotation_list_length 0 Innodb_encryption_n_merge_blocks_encrypted 0 Innodb_encryption_n_merge_blocks_decrypted 0 Innodb_encryption_n_rowlog_blocks_encrypted 0 Innodb_encryption_n_rowlog_blocks_decrypted 0 Innodb_encryption_n_temp_blocks_encrypted 0 Innodb_encryption_n_temp_blocks_decrypted 0 Innodb_encryption_num_key_requests 0 Key_blocks_not_flushed 0 Key_blocks_unused 619823 Key_blocks_used 686117 Key_blocks_warm 17 Key_read_requests 811218000 Key_reads 259373 Key_write_requests 58441964 Key_writes 45075438 Last_query_cost 0.000000 Master_gtid_wait_count 0 Master_gtid_wait_time 0 Master_gtid_wait_timeouts 0 Max_statement_time_exceeded 0 Max_used_connections 83 Memory_used 346709208 Memory_used_initial 272257208 Not_flushed_delayed_rows 0 Open_files 526 Open_streams 4 Open_table_definitions 295 Open_tables 350 Opened_files 185495 Opened_plugin_libraries 0 Opened_table_definitions 663 Opened_tables 928 Opened_views 3135 Performance_schema_accounts_lost 0 Performance_schema_cond_classes_lost 0 Performance_schema_cond_instances_lost 0 Performance_schema_digest_lost 0 Performance_schema_file_classes_lost 0 Performance_schema_file_handles_lost 0 Performance_schema_file_instances_lost 0 Performance_schema_hosts_lost 0 Performance_schema_index_stat_lost 0 Performance_schema_locker_lost 0 Performance_schema_memory_classes_lost 0 Performance_schema_metadata_lock_lost 0 Performance_schema_mutex_classes_lost 0 Performance_schema_mutex_instances_lost 0 Performance_schema_nested_statement_lost 0 Performance_schema_prepared_statements_lost 0 Performance_schema_program_lost 0 Performance_schema_rwlock_classes_lost 0 Performance_schema_rwlock_instances_lost 0 Performance_schema_session_connect_attrs_lost 0 Performance_schema_socket_classes_lost 0 Performance_schema_socket_instances_lost 0 Performance_schema_stage_classes_lost 0 Performance_schema_statement_classes_lost 0 Performance_schema_table_handles_lost 0 Performance_schema_table_instances_lost 0 Performance_schema_table_lock_stat_lost 0 Performance_schema_thread_classes_lost 0 Performance_schema_thread_instances_lost 0 Performance_schema_users_lost 0 Prepared_stmt_count 0 Qcache_free_blocks 923 Qcache_free_memory 63638200 Qcache_hits 9275958 Qcache_inserts 2669842 Qcache_lowmem_prunes 0 Qcache_not_cached 7782 Qcache_queries_in_cache 1987 Qcache_total_blocks 4955 Queries 29949837 Questions 29893779 Rows_read 805140712 Rows_sent 66360601 Rows_tmp_read 81983757 Rpl_semi_sync_master_clients 0 Rpl_semi_sync_master_get_ack 0 Rpl_semi_sync_master_net_avg_wait_time 0 Rpl_semi_sync_master_net_wait_time 0 Rpl_semi_sync_master_net_waits 0 Rpl_semi_sync_master_no_times 0 Rpl_semi_sync_master_no_tx 0 Rpl_semi_sync_master_request_ack 0 Rpl_semi_sync_master_status OFF Rpl_semi_sync_master_timefunc_failures 0 Rpl_semi_sync_master_tx_avg_wait_time 0 Rpl_semi_sync_master_tx_wait_time 0 Rpl_semi_sync_master_tx_waits 0 Rpl_semi_sync_master_wait_pos_backtraverse 0 Rpl_semi_sync_master_wait_sessions 0 Rpl_semi_sync_master_yes_tx 0 Rpl_semi_sync_slave_send_ack 0 Rpl_semi_sync_slave_status OFF Rpl_status AUTH_MASTER Rpl_transactions_multi_engine 0 Select_full_join 515 Select_full_range_join 77 Select_range 718961 Select_range_check 0 Select_scan 59837 Slave_connections 13 Slave_heartbeat_period 30.000 Slave_open_temp_tables 0 Slave_received_heartbeats 0 Slave_retried_transactions 0 Slave_running OFF Slave_skipped_errors 0 Slaves_connected 2 Slaves_running 0 Slow_launch_threads 0 Slow_queries 11 Sort_merge_passes 0 Sort_priority_queue_sorts 186158 Sort_range 242712 Sort_rows 16675942 Sort_scan 3692 Ssl_accept_renegotiates 0 Ssl_accepts 0 Ssl_callback_cache_hits 0 Ssl_cipher Ssl_cipher_list Ssl_client_connects 0 Ssl_connect_renegotiates 0 Ssl_ctx_verify_depth 0 Ssl_ctx_verify_mode 0 Ssl_default_timeout 0 Ssl_finished_accepts 0 Ssl_finished_connects 0 Ssl_server_not_after Ssl_server_not_before Ssl_session_cache_hits 0 Ssl_session_cache_misses 0 Ssl_session_cache_mode NONE Ssl_session_cache_overflows 0 Ssl_session_cache_size 0 Ssl_session_cache_timeouts 0 Ssl_sessions_reused 0 Ssl_used_session_cache_entries 0 Ssl_verify_depth 0 Ssl_verify_mode 0 Ssl_version Subquery_cache_hit 0 Subquery_cache_miss 138 Syncs 289 Table_locks_immediate 11018596 Table_locks_waited 31754 Table_open_cache_active_instances 1 Table_open_cache_hits 7609867 Table_open_cache_misses 11910 Table_open_cache_overflows 0 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threadpool_idle_threads 0 Threadpool_threads 0 Threads_cached 15 Threads_connected 48 Threads_created 3049 Threads_running 4 Transactions_gtid_foreign_engine 0 Transactions_multi_engine 0 Update_scan 1 Uptime 91711 Uptime_since_flush_status 91711 wsrep 0 wsrep_applier_thread_count 0 wsrep_cluster_capabilities wsrep_cluster_conf_id 18446744073709551615 wsrep_cluster_size 0 wsrep_cluster_state_uuid wsrep_cluster_status Disconnected wsrep_connected OFF wsrep_local_bf_aborts 0 wsrep_local_index 18446744073709551615 wsrep_provider_capabilities wsrep_provider_name wsrep_provider_vendor wsrep_provider_version wsrep_ready OFF wsrep_rollbacker_thread_count 0 wsrep_thread_count 0
經過堆分析器的一些工作後，我確定我們使用INSERT DELAYED導致由於MariaDB 錯誤而導致記憶體洩漏。禁用 INSERT DELAYED 是一種有效的緩解措施。
每秒速率 = RPS
為您的 my.cnf 考慮的建議
$$ mysqld $$部分
log_error=master-server-name-error.log # to document startup confirmation and later errors REMOVE thread_cache_size to allow MariaDB default to be used and reduce threads_created join_buffer_size=1M # from 16M for this per connection RAM request key_cache_age_threshold=7200 # from 300 seconds age out and reduce key_reads RPS of ~ 3 key_cache_division_limit=50 # from 100 for WARM/COLD cache key_cache_block_size=16384 # to conserve CPU cycles for management of cache還有其他幾個領域需要調整。有關其他建議，請查看配置文件、網路配置文件以獲取聯繫資訊和免費下載的實用程序腳本以幫助進行性能調整。節日快樂。注意安全。