How to check what is using memory in my mysql instance?
Posted by: Jeevan Patnaik
Date: February 14, 2022 04:19AM
Date: February 14, 2022 04:19AM
Hi,
MySQL 8 - Memory usage reported in RSS is much higher than the innodb buffer pool and global memory reported by MySQL.
MySQL RSS - 15925484 KB ~ 15 GB
But MySQL reports less:
+--------------------------------------------------------------------------------+---------------+---------------+-------------------+------------+-------------+----------------+
| event_name | current_count | current_alloc | current_avg_alloc | high_count | high_alloc | high_avg_alloc |
+--------------------------------------------------------------------------------+---------------+---------------+-------------------+------------+-------------+----------------+
| memory/innodb/buf_buf_pool | 64 | 8.19 GiB | 131.00 MiB | 64 | 8.19 GiB | 131.00 MiB |
| memory/innodb/hash0hash | 32 | 229.71 MiB | 7.18 MiB | 32 | 229.71 MiB | 7.18 MiB |
| memory/sql/TABLE | 23618 | 87.64 MiB | 3.80 KiB | 23624 | 88.14 MiB | 3.82 KiB |
| memory/innodb/memory | 22461 | 54.46 MiB | 2.48 KiB | 54212 | 430.33 MiB | 8.13 KiB |
| memory/performance_schema/events_statements_summary_by_digest | 1 | 39.67 MiB | 39.67 MiB | 1 | 39.67 MiB | 39.67 MiB |
| memory/performance_schema/table_handles | 4 | 36.25 MiB | 9.06 MiB | 4 | 36.25 MiB | 9.06 MiB |
| memory/performance_schema/events_errors_summary_by_thread_by_error | 771 | 34.82 MiB | 46.24 KiB | 771 | 34.82 MiB | 46.24 KiB |
| memory/temptable/physical_ram | 30 | 30.00 MiB | 1.00 MiB | 218 | 1.03 GiB | 4.84 MiB |
| memory/performance_schema/events_statements_summary_by_thread_by_event_name | 3 | 29.38 MiB | 9.79 MiB | 3 | 29.38 MiB | 9.79 MiB |
| memory/innodb/ut0link_buf | 2 | 24.00 MiB | 12.00 MiB | 2 | 24.00 MiB | 12.00 MiB |
| memory/performance_schema/memory_summary_by_thread_by_event_name | 3 | 23.73 MiB | 7.91 MiB | 3 | 23.73 MiB | 7.91 MiB |
| memory/innodb/lock0lock | 9799 | 21.24 MiB | 2.22 KiB | 9799 | 21.24 MiB | 2.22 KiB |
| memory/innodb/buf0dblwr | 600 | 19.52 MiB | 33.31 KiB | 600 | 26.85 MiB | 45.82 KiB |
| memory/innodb/row0sel | 369 | 17.16 MiB | 47.63 KiB | 724 | 54.32 MiB | 76.83 KiB |
| memory/performance_schema/events_statements_history_long | 1 | 13.89 MiB | 13.89 MiB | 1 | 13.89 MiB | 13.89 MiB |
| memory/performance_schema/events_waits_summary_by_thread_by_event_name | 3 | 12.98 MiB | 4.33 MiB | 3 | 12.98 MiB | 4.33 MiB |
| memory/performance_schema/events_statements_history | 3 | 10.66 MiB | 3.55 MiB | 3 | 10.66 MiB | 3.55 MiB |
| memory/performance_schema/events_statements_current | 3 | 10.66 MiB | 3.55 MiB | 3 | 10.66 MiB | 3.55 MiB |
| memory/innodb/ut0new | 6 | 10.08 MiB | 1.68 MiB | 6 | 10.08 MiB | 1.68 MiB |
| memory/sql/String::value | 1685 | 9.84 MiB | 5.98 KiB | 525547 | 211.59 MiB | 422 bytes |
| memory/performance_schema/events_statements_summary_by_digest.digest_text | 1 | 9.77 MiB | 9.77 MiB | 1 | 9.77 MiB | 9.77 MiB |
| memory/performance_schema/events_statements_history_long.digest_text | 1 | 9.77 MiB | 9.77 MiB | 1 | 9.77 MiB | 9.77 MiB |
| memory/performance_schema/events_statements_history_long.sql_text | 1 | 9.77 MiB | 9.77 MiB | 1 | 9.77 MiB | 9.77 MiB |
| memory/mysys/KEY_CACHE | 3 | 8.00 MiB | 2.67 MiB | 3 | 8.00 MiB | 2.67 MiB |
| memory/sql/TABLE_SHARE::mem_root | 2549 | 7.94 MiB | 3.19 KiB | 2554 | 7.96 MiB | 3.19 KiB |
| memory/performance_schema/events_statements_history.digest_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/performance_schema/events_statements_history.sql_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/performance_schema/events_statements_current.digest_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/performance_schema/events_statements_current.sql_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/innodb/sync0arr | 2 | 6.25 MiB | 3.13 MiB | 2 | 6.25 MiB | 3.13 MiB |
| memory/performance_schema/events_errors_summary_by_account_by_error | 129 | 5.80 MiB | 46.06 KiB | 129 | 5.80 MiB | 46.06 KiB |
| memory/performance_schema/events_errors_summary_by_host_by_error | 129 | 5.80 MiB | 46.06 KiB | 129 | 5.80 MiB | 46.06 KiB |
| memory/performance_schema/events_errors_summary_by_user_by_error | 129 | 5.80 MiB | 46.06 KiB | 129 | 5.80 MiB | 46.06 KiB |
| memory/sql/log_sink_pfs | 1 | 5.00 MiB | 5.00 MiB | 2 | 5.02 MiB | 2.51 MiB |
| memory/performance_schema/events_statements_summary_by_account_by_event_name | 1 | 4.90 MiB | 4.90 MiB | 1 | 4.90 MiB | 4.90 MiB |
| memory/performance_schema/events_statements_summary_by_host_by_event_name | 1 | 4.90 MiB | 4.90 MiB | 1 | 4.90 MiB | 4.90 MiB |
| memory/performance_schema/events_statements_summary_by_user_by_event_name | 1 | 4.90 MiB | 4.90 MiB | 1 | 4.90 MiB | 4.90 MiB |
| memory/innodb/ha_innodb | 3556 | 4.43 MiB | 1.28 KiB | 4269 | 6.01 MiB | 1.44 KiB |
| memory/sql/NET::buff | 32 | 4.35 MiB | 139.13 KiB | 109259 | 1.67 GiB | 16.01 KiB |
| memory/performance_schema/events_stages_summary_by_thread_by_event_name | 3 | 4.10 MiB | 1.37 MiB | 3 | 4.10 MiB | 1.37 MiB |
| memory/innodb/ut0pool | 1 | 4.00 MiB | 4.00 MiB | 1 | 4.00 MiB | 4.00 MiB |
| memory/performance_schema/table_shares | 1 | 4.00 MiB | 4.00 MiB | 1 | 4.00 MiB | 4.00 MiB |
| memory/performance_schema/memory_summary_by_account_by_event_name | 1 | 3.96 MiB | 3.96 MiB | 1 | 3.96 MiB | 3.96 MiB |
| memory/performance_schema/memory_summary_by_host_by_event_name | 1 | 3.96 MiB | 3.96 MiB | 1 | 3.96 MiB | 3.96 MiB |
| memory/performance_schema/memory_summary_by_user_by_event_name | 1 | 3.96 MiB | 3.96 MiB | 1 | 3.96 MiB | 3.96 MiB |
| memory/performance_schema/events_transactions_history_long | 1 | 3.28 MiB | 3.28 MiB | 1 | 3.28 MiB | 3.28 MiB |
| memory/performance_schema/threads | 3 | 3.14 MiB | 1.05 MiB | 3 | 3.14 MiB | 1.05 MiB |
| memory/sql/dd::String_type | 53698 | 2.86 MiB | 55 bytes | 53762 | 2.87 MiB | 56 bytes |
| memory/performance_schema/file_instances | 1 | 2.75 MiB | 2.75 MiB | 1 | 2.75 MiB | 2.75 MiB |
| memory/performance_schema/table_io_waits_summary_by_index_usage | 1 | 2.75 MiB | 2.75 MiB | 1 | 2.75 MiB | 2.75 MiB |
| memory/innodb/os0file | 134 | 2.60 MiB | 19.90 KiB | 141 | 4.31 MiB | 31.28 KiB |
| memory/performance_schema/events_transactions_history | 3 | 2.52 MiB | 860.00 KiB | 3 | 2.52 MiB | 860.00 KiB |
| memory/mysqld_openssl/openssl_malloc | 6051 | 2.31 MiB | 400 bytes | 82589568 | 35.52 GiB | 461 bytes |
| memory/performance_schema/mutex_instances | 18 | 2.25 MiB | 128.00 KiB | 18 | 2.25 MiB | 128.00 KiB |
| memory/performance_schema/events_waits_summary_by_account_by_event_name | 1 | 2.16 MiB | 2.16 MiB | 1 | 2.16 MiB | 2.16 MiB |
| memory/performance_schema/events_waits_summary_by_host_by_event_name | 1 | 2.16 MiB | 2.16 MiB | 1 | 2.16 MiB | 2.16 MiB |
| memory/performance_schema/events_waits_summary_by_user_by_event_name | 1 | 2.16 MiB | 2.16 MiB | 1 | 2.16 MiB | 2.16 MiB |
| memory/mysys/IO_CACHE | 201 | 2.09 MiB | 10.63 KiB | 1737 | 18.34 MiB | 10.81 KiB |
| memory/performance_schema/events_waits_history_long | 1 | 1.68 MiB | 1.68 MiB | 1 | 1.68 MiB | 1.68 MiB |
| memory/performance_schema/metadata_locks | 3 | 1.50 MiB | 512.00 KiB | 3 | 1.50 MiB | 512.00 KiB |
| memory/innodb/trx0trx | 4899 | 1.35 MiB | 288 bytes | 4899 | 1.35 MiB | 288 bytes |
| memory/performance_schema/table_lock_waits_summary_by_table | 1 | 1.34 MiB | 1.34 MiB | 1 | 1.34 MiB | 1.34 MiB |
| memory/performance_schema/events_waits_history | 3 | 1.29 MiB | 440.00 KiB | 3 | 1.29 MiB | 440.00 KiB |
| memory/performance_schema/events_stages_history_long | 1 | 1015.62 KiB | 1015.62 KiB | 1 | 1015.62 KiB | 1015.62 KiB |
| memory/sql/sp_head::main_mem_root | 68 | 911.71 KiB | 13.41 KiB | 68 | 911.71 KiB | 13.41 KiB |
| memory/mysys/lf_node | 4278 | 851.48 KiB | 203 bytes | 4278 | 851.48 KiB | 203 bytes |
| memory/innodb/read0read | 1025 | 805.72 KiB | 804 bytes | 1161 | 846.73 KiB | 746 bytes |
| memory/performance_schema/events_stages_history | 3 | 780.00 KiB | 260.00 KiB | 3 | 780.00 KiB | 260.00 KiB |
| memory/performance_schema/events_stages_summary_by_account_by_event_name | 1 | 700.00 KiB | 700.00 KiB | 1 | 700.00 KiB | 700.00 KiB |
| memory/performance_schema/events_stages_summary_by_host_by_event_name | 1 | 700.00 KiB | 700.00 KiB | 1 | 700.00 KiB | 700.00 KiB |
| memory/performance_schema/events_stages_summary_by_user_by_event_name | 1 | 700.00 KiB | 700.00 KiB | 1 | 700.00 KiB | 700.00 KiB |
| memory/sql/thd::main_mem_root | 40 | 581.31 KiB | 14.53 KiB | 4746 | 122.54 MiB | 26.44 KiB |
| memory/performance_schema/rwlock_instances | 4 | 512.00 KiB | 128.00 KiB | 4 | 512.00 KiB | 128.00 KiB |
| memory/performance_schema/events_statements_summary_by_program | 1 | 448.00 KiB | 448.00 KiB | 1 | 448.00 KiB | 448.00 KiB |
| memory/performance_schema/session_connect_attrs | 3 | 384.00 KiB | 128.00 KiB | 3 | 384.00 KiB | 128.00 KiB |
| memory/sql/plugin_mem_root | 65 | 302.40 KiB | 4.65 KiB | 65 | 302.40 KiB | 4.65 KiB |
| memory/innodb/rem0rec | 3188 | 285.66 KiB | 91 bytes | 29593 | 1.48 MiB | 52 bytes |
| memory/performance_schema/file_handle | 1 | 256.00 KiB | 256.00 KiB | 1 | 256.00 KiB | 256.00 KiB |
| memory/mysys/lf_dynarray | 40 | 206.75 KiB | 5.17 KiB | 40 | 206.75 KiB | 5.17 KiB |
| memory/innodb/trx0undo | 589 | 202.47 KiB | 352 bytes | 1045 | 359.22 KiB | 352 bytes |
| memory/innodb/btr0pcur | 1865 | 189.25 KiB | 103 bytes | 2157 | 220.13 KiB | 104 bytes |
| memory/performance_schema/socket_instances | 2 | 160.00 KiB | 80.00 KiB | 2 | 160.00 KiB | 80.00 KiB |
| memory/performance_schema/events_errors_summary_global_by_error | 1 | 150.25 KiB | 150.25 KiB | 1 | 150.25 KiB | 150.25 KiB |
| memory/innodb/fsp0file | 1 | 128.03 KiB | 128.03 KiB | 3 | 256.10 KiB | 85.37 KiB |
| memory/performance_schema/accounts | 1 | 112.00 KiB | 112.00 KiB | 1 | 112.00 KiB | 112.00 KiB |
| memory/innodb/trx0rseg | 388 | 105.62 KiB | 278 bytes | 388 | 105.62 KiB | 278 bytes |
| memory/mysys/lf_slist | 3280 | 102.50 KiB | 32 bytes | 3280 | 102.50 KiB | 32 bytes |
| memory/performance_schema/hosts | 1 | 96.00 KiB | 96.00 KiB | 1 | 96.00 KiB | 96.00 KiB |
| memory/performance_schema/memory_class | 1 | 84.38 KiB | 84.38 KiB | 1 | 84.38 KiB | 84.38 KiB |
| memory/innodb/fil0fil | 234 | 84.09 KiB | 368 bytes | 250 | 8.40 MiB | 34.39 KiB |
| memory/performance_schema/users | 1 | 80.00 KiB | 80.00 KiB | 1 | 80.00 KiB | 80.00 KiB |
| memory/innodb/buf0buf | 1 | 75.53 KiB | 75.53 KiB | 3 | 80.80 KiB | 26.93 KiB |
| memory/performance_schema/mutex_class | 1 | 75.00 KiB | 75.00 KiB | 1 | 75.00 KiB | 75.00 KiB |
| memory/performance_schema/events_transactions_summary_by_thread_by_event_name | 3 | 66.00 KiB | 22.00 KiB | 3 | 66.00 KiB | 22.00 KiB |
| memory/performance_schema/cond_instances | 4 | 64.00 KiB | 16.00 KiB | 4 | 64.00 KiB | 16.00 KiB |
| memory/performance_schema/setup_actors | 1 | 64.00 KiB | 64.00 KiB | 1 | 64.00 KiB | 64.00 KiB |
| memory/innodb/ut_lock_free_hash_t | 519 | 56.38 KiB | 111 bytes | 519 | 72.35 KiB | 142 bytes |
| memory/performance_schema/setup_objects | 1 | 56.00 KiB | 56.00 KiB | 1 | 56.00 KiB | 56.00 KiB |
| memory/innodb/mem0mem | 761 | 44.97 KiB | 60 bytes | 902 | 51.12 KiB | 58 bytes |
| memory/innodb/dict0dict | 284 | 44.95 KiB | 162 bytes | 290 | 46.49 KiB | 164 bytes |
| memory/performance_schema/stage_class | 1 | 43.75 KiB | 43.75 KiB | 1 | 43.75 KiB | 43.75 KiB |
| memory/sql/errmsgs | 1 | 41.40 KiB | 41.40 KiB | 1 | 41.40 KiB | 41.40 KiB |
| memory/performance_schema/statement_class | 1 | 40.88 KiB | 40.88 KiB | 1 | 40.88 KiB | 40.88 KiB |
| memory/performance_schema/events_statements_summary_global_by_event_name | 1 | 39.17 KiB | 39.17 KiB | 1 | 39.17 KiB | 39.17 KiB |
| memory/mysys/TREE | 3 | 38.02 KiB | 12.67 KiB | 39 | 740.18 KiB | 18.98 KiB |
| memory/innodb/log0log | 3 | 32.16 KiB | 10.72 KiB | 3 | 32.16 KiB | 10.72 KiB |
| memory/sql/tz_storage | 1 | 32.01 KiB | 32.01 KiB | 1 | 32.01 KiB | 32.01 KiB |
| memory/sql/Filesort_buffer::sort_keys | 1 | 32.00 KiB | 32.00 KiB | 866 | 48.11 MiB | 56.89 KiB |
| memory/performance_schema/memory_summary_global_by_event_name | 1 | 31.64 KiB | 31.64 KiB | 1 | 31.64 KiB | 31.64 KiB |
| memory/sql/binlog_cache_mngr | 33 | 29.65 KiB | 920 bytes | 288 | 258.75 KiB | 920 bytes |
| memory/performance_schema/cond_class | 1 | 25.00 KiB | 25.00 KiB | 1 | 25.00 KiB | 25.00 KiB |
| memory/performance_schema/file_class | 1 | 25.00 KiB | 25.00 KiB | 1 | 25.00 KiB | 25.00 KiB |
| memory/performance_schema/thread_class | 1 | 18.75 KiB | 18.75 KiB | 1 | 18.75 KiB | 18.75 KiB |
| memory/sql/LOG_POS_COORD | 33 | 16.53 KiB | 513 bytes | 288 | 144.28 KiB | 513 bytes |
| memory/innodb/lexyy | 3 | 16.17 KiB | 5.39 KiB | 3 | 16.17 KiB | 5.39 KiB |
| memory/performance_schema/rwlock_class | 1 | 15.00 KiB | 15.00 KiB | 1 | 15.00 KiB | 15.00 KiB |
| memory/innodb/sync0sharded_rw | 1 | 12.03 KiB | 12.03 KiB | 1 | 12.03 KiB | 12.03 KiB |
| memory/performance_schema/events_transactions_summary_by_account_by_event_name | 1 | 11.00 KiB | 11.00 KiB | 1 | 11.00 KiB | 11.00 KiB |
| memory/performance_schema/events_transactions_summary_by_host_by_event_name | 1 | 11.00 KiB | 11.00 KiB | 1 | 11.00 KiB | 11.00 KiB |
| memory/performance_schema/events_transactions_summary_by_user_by_event_name | 1 | 11.00 KiB | 11.00 KiB | 1 | 11.00 KiB | 11.00 KiB |
| memory/csv/Transparent_file | 2 | 8.00 KiB | 4.00 KiB | 2 | 8.00 KiB | 4.00 KiB |
| memory/sql/handlerton | 10 | 7.73 KiB | 792 bytes | 10 | 7.73 KiB | 792 bytes |
| memory/sql/THD::Session_tracker | 143 | 5.85 KiB | 41 bytes | 1420485 | 56.79 MiB | 41 bytes |
| memory/performance_schema/events_stages_summary_global_by_event_name | 1 | 5.47 KiB | 5.47 KiB | 1 | 5.47 KiB | 5.47 KiB |
| memory/performance_schema/scalable_buffer | 48 | 5.02 KiB | 107 bytes | 48 | 5.02 KiB | 107 bytes |
| memory/sql/THD::variables | 34 | 4.25 KiB | 128 bytes | 471 | 58.88 KiB | 128 bytes |
| memory/performance_schema/socket_class | 1 | 3.12 KiB | 3.12 KiB | 1 | 3.12 KiB | 3.12 KiB |
| memory/sql/sql_acl_mem | 6 | 2.75 KiB | 469 bytes | 7 | 2.78 KiB | 406 bytes |
| memory/mysqlx/objects | 14 | 2.61 KiB | 190 bytes | 14 | 2.61 KiB | 190 bytes |
| memory/sql/THD::Session_sysvar_resource_manager | 33 | 2.16 KiB | 67 bytes | 218629 | 11.78 MiB | 56 bytes |
| memory/innodb/trx_sys_t::rw_trx_ids | 1 | 2.03 KiB | 2.03 KiB | 3 | 3.59 KiB | 1.20 KiB |
| memory/sql/Prepared_statement_map | 22 | 1.89 KiB | 88 bytes | 884 | 75.97 KiB | 88 bytes |
| memory/csv/TINA_SHARE | 5 | 1.79 KiB | 366 bytes | 5 | 1.79 KiB | 366 bytes |
| memory/sql/sql_acl_memex | 10 | 1.62 KiB | 165 bytes | 10 | 1.62 KiB | 165 bytes |
| memory/innodb/adaptive hash index | 11 | 1.48 KiB | 137 bytes | 11 | 1.48 KiB | 137 bytes |
| memory/sql/udf_mem | 10 | 1.34 KiB | 137 bytes | 10 | 1.34 KiB | 137 bytes |
| memory/sql/ST_SCHEMA_TABLE | 26 | 1.22 KiB | 48 bytes | 26 | 1.22 KiB | 48 bytes |
| memory/sql/acl_cache | 30 | 1.19 KiB | 40 bytes | 30 | 1.19 KiB | 40 bytes |
| memory/innodb/undo::Tablespaces | 3 | 1.16 KiB | 394 bytes | 3 | 1.16 KiB | 394 bytes |
| memory/innodb/dict_stats_bg_recalc_pool_t | 2 | 1.09 KiB | 560 bytes | 2 | 1.09 KiB | 560 bytes |
| memory/innodb/trx0purge | 6 | 974 bytes | 162 bytes | 7 | 1.02 KiB | 149 bytes |
| memory/sql/user_var_entry | 11 | 968 bytes | 88 bytes | 442 | 37.98 KiB | 88 bytes |
| memory/sql/User_level_lock | 11 | 968 bytes | 88 bytes | 442 | 37.98 KiB | 88 bytes |
| memory/sql/THD::handler_tables_hash | 11 | 968 bytes | 88 bytes | 442 | 37.98 KiB | 88 bytes |
| memory/innodb/srv0srv | 3 | 904 bytes | 301 bytes | 3 | 904 bytes | 301 bytes |
| memory/innodb/buf0flu | 2 | 784 bytes | 392 bytes | 2 | 784 bytes | 392 bytes |
| memory/sql/plugin_bookmark | 17 | 752 bytes | 44 bytes | 17 | 776 bytes | 45 bytes |
| memory/sql/handler::errmsgs | 1 | 720 bytes | 720 bytes | 1 | 720 bytes | 720 bytes |
| memory/myisam/ft_stopwords | 1 | 696 bytes | 696 bytes | 1 | 696 bytes | 696 bytes |
| memory/innodb/log and page archiver | 3 | 672 bytes | 224 bytes | 4 | 825 bytes | 206 bytes |
| memory/innodb/trx0sys | 1 | 592 bytes | 592 bytes | 1 | 592 bytes | 592 bytes |
| memory/mysys/my_file_info | 36 | 582 bytes | 16 bytes | 291 | 4.04 KiB | 14 bytes |
| memory/sql/mysql_plugin | 1 | 512 bytes | 512 bytes | 2 | 768 bytes | 384 bytes |
| memory/innodb/log0recv | 1 | 408 bytes | 408 bytes | 3 | 2.00 MiB | 683.15 KiB |
| memory/sql/THD::sp_cache | 8 | 312 bytes | 39 bytes | 8 | 312 bytes | 39 bytes |
| memory/sql/TABLE::sort_io_cache | 1 | 304 bytes | 304 bytes | 367 | 108.95 KiB | 304 bytes |
| memory/sql/global_system_variables | 2 | 256 bytes | 128 bytes | 3 | 320 bytes | 106 bytes |
| memory/innodb/clone | 1 | 256 bytes | 256 bytes | 1 | 256 bytes | 256 bytes |
| memory/sql/Event_scheduler::scheduler_param | 1 | 240 bytes | 240 bytes | 2 | 256 bytes | 128 bytes |
| memory/sql/Sid_map::Node | 4 | 236 bytes | 59 bytes | 9 | 676 bytes | 75 bytes |
| memory/sql/THD::db | 34 | 235 bytes | 6 bytes | 466 | 3.18 KiB | 6 bytes |
| memory/sql/Mutex_cond_array::Mutex_cond | 2 | 208 bytes | 104 bytes | 2 | 208 bytes | 104 bytes |
| memory/sql/log_error_stack | 6 | 166 bytes | 27 bytes | 131 | 164.17 KiB | 1.25 KiB |
| memory/innodb/trx0i_s | 1 | 160 bytes | 160 bytes | 1 | 160 bytes | 160 bytes |
| memory/innodb/buf_stat_per_index_t | 2 | 152 bytes | 76 bytes | 2 | 152 bytes | 76 bytes |
| memory/mysys/my_err_head | 6 | 144 bytes | 24 bytes | 6 | 144 bytes | 24 bytes |
| memory/innodb/ibuf0ibuf | 1 | 144 bytes | 144 bytes | 1 | 144 bytes | 144 bytes |
| memory/sql/root | 1 | 136 bytes | 136 bytes | 1 | 136 bytes | 136 bytes |
| memory/sql/Rpl_info_table | 6 | 102 bytes | 17 bytes | 6 | 102 bytes | 17 bytes |
| memory/innodb/usr0sess | 2 | 96 bytes | 48 bytes | 2 | 96 bytes | 48 bytes |
| memory/innodb/ut0wqueue | 1 | 96 bytes | 96 bytes | 1 | 96 bytes | 96 bytes |
| memory/sql/host_cache::hostname | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/Owned_gtids::sidno_to_hash | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/db_worker_hash_entry | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/user_conn | 1 | 88 bytes | 88 bytes | 66737 | 4.17 MiB | 65 bytes |
| memory/blackhole/blackhole_share | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/servers_cache | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/innodb/pars0lex | 1 | 64 bytes | 64 bytes | 1 | 64 bytes | 64 bytes |
| memory/sql/File_query_log::name | 2 | 57 bytes | 28 bytes | 2 | 57 bytes | 28 bytes |
| memory/sql/MYSQL_LOCK | 1 | 48 bytes | 48 bytes | 847 | 32.25 KiB | 38 bytes |
| memory/innodb/ut0list | 1 | 48 bytes | 48 bytes | 1 | 48 bytes | 48 bytes |
| memory/sql/MYSQL_RELAY_LOG::index | 1 | 42 bytes | 42 bytes | 1 | 42 bytes | 42 bytes |
| memory/mysys/MY_BITMAP::bitmap | 10 | 40 bytes | 4 bytes | 878 | 3.43 KiB | 4 bytes |
| memory/sql/MYSQL_RELAY_LOG::basename | 1 | 36 bytes | 36 bytes | 1 | 36 bytes | 36 bytes |
| memory/sql/MYSQL_BIN_LOG::index | 1 | 32 bytes | 32 bytes | 1 | 32 bytes | 32 bytes |
| memory/sql/MYSQL_LOG::name | 1 | 26 bytes | 26 bytes | 2 | 52 bytes | 26 bytes |
| memory/sql/MYSQL_BIN_LOG::basename | 1 | 26 bytes | 26 bytes | 1 | 26 bytes | 26 bytes |
| memory/sql/opt_bin_logname | 1 | 26 bytes | 26 bytes | 1 | 26 bytes | 26 bytes |
| memory/vio/ssl_fd | 2 | 16 bytes | 8 bytes | 2 | 16 bytes | 8 bytes |
| memory/mysys/MY_TMPDIR::full_list | 2 | 13 bytes | 6 bytes | 2 | 13 bytes | 6 bytes |
| memory/sql/NAMED_ILINK::name | 1 | 8 bytes | 8 bytes | 1 | 8 bytes | 8 bytes |
+--------------------------------------------------------------------------------+---------------+---------------+-------------------+------------+-------------+----------------+
What else can I check to findout where it's using that much memory?
MySQL 8 - Memory usage reported in RSS is much higher than the innodb buffer pool and global memory reported by MySQL.
MySQL RSS - 15925484 KB ~ 15 GB
But MySQL reports less:
+--------------------------------------------------------------------------------+---------------+---------------+-------------------+------------+-------------+----------------+
| event_name | current_count | current_alloc | current_avg_alloc | high_count | high_alloc | high_avg_alloc |
+--------------------------------------------------------------------------------+---------------+---------------+-------------------+------------+-------------+----------------+
| memory/innodb/buf_buf_pool | 64 | 8.19 GiB | 131.00 MiB | 64 | 8.19 GiB | 131.00 MiB |
| memory/innodb/hash0hash | 32 | 229.71 MiB | 7.18 MiB | 32 | 229.71 MiB | 7.18 MiB |
| memory/sql/TABLE | 23618 | 87.64 MiB | 3.80 KiB | 23624 | 88.14 MiB | 3.82 KiB |
| memory/innodb/memory | 22461 | 54.46 MiB | 2.48 KiB | 54212 | 430.33 MiB | 8.13 KiB |
| memory/performance_schema/events_statements_summary_by_digest | 1 | 39.67 MiB | 39.67 MiB | 1 | 39.67 MiB | 39.67 MiB |
| memory/performance_schema/table_handles | 4 | 36.25 MiB | 9.06 MiB | 4 | 36.25 MiB | 9.06 MiB |
| memory/performance_schema/events_errors_summary_by_thread_by_error | 771 | 34.82 MiB | 46.24 KiB | 771 | 34.82 MiB | 46.24 KiB |
| memory/temptable/physical_ram | 30 | 30.00 MiB | 1.00 MiB | 218 | 1.03 GiB | 4.84 MiB |
| memory/performance_schema/events_statements_summary_by_thread_by_event_name | 3 | 29.38 MiB | 9.79 MiB | 3 | 29.38 MiB | 9.79 MiB |
| memory/innodb/ut0link_buf | 2 | 24.00 MiB | 12.00 MiB | 2 | 24.00 MiB | 12.00 MiB |
| memory/performance_schema/memory_summary_by_thread_by_event_name | 3 | 23.73 MiB | 7.91 MiB | 3 | 23.73 MiB | 7.91 MiB |
| memory/innodb/lock0lock | 9799 | 21.24 MiB | 2.22 KiB | 9799 | 21.24 MiB | 2.22 KiB |
| memory/innodb/buf0dblwr | 600 | 19.52 MiB | 33.31 KiB | 600 | 26.85 MiB | 45.82 KiB |
| memory/innodb/row0sel | 369 | 17.16 MiB | 47.63 KiB | 724 | 54.32 MiB | 76.83 KiB |
| memory/performance_schema/events_statements_history_long | 1 | 13.89 MiB | 13.89 MiB | 1 | 13.89 MiB | 13.89 MiB |
| memory/performance_schema/events_waits_summary_by_thread_by_event_name | 3 | 12.98 MiB | 4.33 MiB | 3 | 12.98 MiB | 4.33 MiB |
| memory/performance_schema/events_statements_history | 3 | 10.66 MiB | 3.55 MiB | 3 | 10.66 MiB | 3.55 MiB |
| memory/performance_schema/events_statements_current | 3 | 10.66 MiB | 3.55 MiB | 3 | 10.66 MiB | 3.55 MiB |
| memory/innodb/ut0new | 6 | 10.08 MiB | 1.68 MiB | 6 | 10.08 MiB | 1.68 MiB |
| memory/sql/String::value | 1685 | 9.84 MiB | 5.98 KiB | 525547 | 211.59 MiB | 422 bytes |
| memory/performance_schema/events_statements_summary_by_digest.digest_text | 1 | 9.77 MiB | 9.77 MiB | 1 | 9.77 MiB | 9.77 MiB |
| memory/performance_schema/events_statements_history_long.digest_text | 1 | 9.77 MiB | 9.77 MiB | 1 | 9.77 MiB | 9.77 MiB |
| memory/performance_schema/events_statements_history_long.sql_text | 1 | 9.77 MiB | 9.77 MiB | 1 | 9.77 MiB | 9.77 MiB |
| memory/mysys/KEY_CACHE | 3 | 8.00 MiB | 2.67 MiB | 3 | 8.00 MiB | 2.67 MiB |
| memory/sql/TABLE_SHARE::mem_root | 2549 | 7.94 MiB | 3.19 KiB | 2554 | 7.96 MiB | 3.19 KiB |
| memory/performance_schema/events_statements_history.digest_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/performance_schema/events_statements_history.sql_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/performance_schema/events_statements_current.digest_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/performance_schema/events_statements_current.sql_text | 3 | 7.50 MiB | 2.50 MiB | 3 | 7.50 MiB | 2.50 MiB |
| memory/innodb/sync0arr | 2 | 6.25 MiB | 3.13 MiB | 2 | 6.25 MiB | 3.13 MiB |
| memory/performance_schema/events_errors_summary_by_account_by_error | 129 | 5.80 MiB | 46.06 KiB | 129 | 5.80 MiB | 46.06 KiB |
| memory/performance_schema/events_errors_summary_by_host_by_error | 129 | 5.80 MiB | 46.06 KiB | 129 | 5.80 MiB | 46.06 KiB |
| memory/performance_schema/events_errors_summary_by_user_by_error | 129 | 5.80 MiB | 46.06 KiB | 129 | 5.80 MiB | 46.06 KiB |
| memory/sql/log_sink_pfs | 1 | 5.00 MiB | 5.00 MiB | 2 | 5.02 MiB | 2.51 MiB |
| memory/performance_schema/events_statements_summary_by_account_by_event_name | 1 | 4.90 MiB | 4.90 MiB | 1 | 4.90 MiB | 4.90 MiB |
| memory/performance_schema/events_statements_summary_by_host_by_event_name | 1 | 4.90 MiB | 4.90 MiB | 1 | 4.90 MiB | 4.90 MiB |
| memory/performance_schema/events_statements_summary_by_user_by_event_name | 1 | 4.90 MiB | 4.90 MiB | 1 | 4.90 MiB | 4.90 MiB |
| memory/innodb/ha_innodb | 3556 | 4.43 MiB | 1.28 KiB | 4269 | 6.01 MiB | 1.44 KiB |
| memory/sql/NET::buff | 32 | 4.35 MiB | 139.13 KiB | 109259 | 1.67 GiB | 16.01 KiB |
| memory/performance_schema/events_stages_summary_by_thread_by_event_name | 3 | 4.10 MiB | 1.37 MiB | 3 | 4.10 MiB | 1.37 MiB |
| memory/innodb/ut0pool | 1 | 4.00 MiB | 4.00 MiB | 1 | 4.00 MiB | 4.00 MiB |
| memory/performance_schema/table_shares | 1 | 4.00 MiB | 4.00 MiB | 1 | 4.00 MiB | 4.00 MiB |
| memory/performance_schema/memory_summary_by_account_by_event_name | 1 | 3.96 MiB | 3.96 MiB | 1 | 3.96 MiB | 3.96 MiB |
| memory/performance_schema/memory_summary_by_host_by_event_name | 1 | 3.96 MiB | 3.96 MiB | 1 | 3.96 MiB | 3.96 MiB |
| memory/performance_schema/memory_summary_by_user_by_event_name | 1 | 3.96 MiB | 3.96 MiB | 1 | 3.96 MiB | 3.96 MiB |
| memory/performance_schema/events_transactions_history_long | 1 | 3.28 MiB | 3.28 MiB | 1 | 3.28 MiB | 3.28 MiB |
| memory/performance_schema/threads | 3 | 3.14 MiB | 1.05 MiB | 3 | 3.14 MiB | 1.05 MiB |
| memory/sql/dd::String_type | 53698 | 2.86 MiB | 55 bytes | 53762 | 2.87 MiB | 56 bytes |
| memory/performance_schema/file_instances | 1 | 2.75 MiB | 2.75 MiB | 1 | 2.75 MiB | 2.75 MiB |
| memory/performance_schema/table_io_waits_summary_by_index_usage | 1 | 2.75 MiB | 2.75 MiB | 1 | 2.75 MiB | 2.75 MiB |
| memory/innodb/os0file | 134 | 2.60 MiB | 19.90 KiB | 141 | 4.31 MiB | 31.28 KiB |
| memory/performance_schema/events_transactions_history | 3 | 2.52 MiB | 860.00 KiB | 3 | 2.52 MiB | 860.00 KiB |
| memory/mysqld_openssl/openssl_malloc | 6051 | 2.31 MiB | 400 bytes | 82589568 | 35.52 GiB | 461 bytes |
| memory/performance_schema/mutex_instances | 18 | 2.25 MiB | 128.00 KiB | 18 | 2.25 MiB | 128.00 KiB |
| memory/performance_schema/events_waits_summary_by_account_by_event_name | 1 | 2.16 MiB | 2.16 MiB | 1 | 2.16 MiB | 2.16 MiB |
| memory/performance_schema/events_waits_summary_by_host_by_event_name | 1 | 2.16 MiB | 2.16 MiB | 1 | 2.16 MiB | 2.16 MiB |
| memory/performance_schema/events_waits_summary_by_user_by_event_name | 1 | 2.16 MiB | 2.16 MiB | 1 | 2.16 MiB | 2.16 MiB |
| memory/mysys/IO_CACHE | 201 | 2.09 MiB | 10.63 KiB | 1737 | 18.34 MiB | 10.81 KiB |
| memory/performance_schema/events_waits_history_long | 1 | 1.68 MiB | 1.68 MiB | 1 | 1.68 MiB | 1.68 MiB |
| memory/performance_schema/metadata_locks | 3 | 1.50 MiB | 512.00 KiB | 3 | 1.50 MiB | 512.00 KiB |
| memory/innodb/trx0trx | 4899 | 1.35 MiB | 288 bytes | 4899 | 1.35 MiB | 288 bytes |
| memory/performance_schema/table_lock_waits_summary_by_table | 1 | 1.34 MiB | 1.34 MiB | 1 | 1.34 MiB | 1.34 MiB |
| memory/performance_schema/events_waits_history | 3 | 1.29 MiB | 440.00 KiB | 3 | 1.29 MiB | 440.00 KiB |
| memory/performance_schema/events_stages_history_long | 1 | 1015.62 KiB | 1015.62 KiB | 1 | 1015.62 KiB | 1015.62 KiB |
| memory/sql/sp_head::main_mem_root | 68 | 911.71 KiB | 13.41 KiB | 68 | 911.71 KiB | 13.41 KiB |
| memory/mysys/lf_node | 4278 | 851.48 KiB | 203 bytes | 4278 | 851.48 KiB | 203 bytes |
| memory/innodb/read0read | 1025 | 805.72 KiB | 804 bytes | 1161 | 846.73 KiB | 746 bytes |
| memory/performance_schema/events_stages_history | 3 | 780.00 KiB | 260.00 KiB | 3 | 780.00 KiB | 260.00 KiB |
| memory/performance_schema/events_stages_summary_by_account_by_event_name | 1 | 700.00 KiB | 700.00 KiB | 1 | 700.00 KiB | 700.00 KiB |
| memory/performance_schema/events_stages_summary_by_host_by_event_name | 1 | 700.00 KiB | 700.00 KiB | 1 | 700.00 KiB | 700.00 KiB |
| memory/performance_schema/events_stages_summary_by_user_by_event_name | 1 | 700.00 KiB | 700.00 KiB | 1 | 700.00 KiB | 700.00 KiB |
| memory/sql/thd::main_mem_root | 40 | 581.31 KiB | 14.53 KiB | 4746 | 122.54 MiB | 26.44 KiB |
| memory/performance_schema/rwlock_instances | 4 | 512.00 KiB | 128.00 KiB | 4 | 512.00 KiB | 128.00 KiB |
| memory/performance_schema/events_statements_summary_by_program | 1 | 448.00 KiB | 448.00 KiB | 1 | 448.00 KiB | 448.00 KiB |
| memory/performance_schema/session_connect_attrs | 3 | 384.00 KiB | 128.00 KiB | 3 | 384.00 KiB | 128.00 KiB |
| memory/sql/plugin_mem_root | 65 | 302.40 KiB | 4.65 KiB | 65 | 302.40 KiB | 4.65 KiB |
| memory/innodb/rem0rec | 3188 | 285.66 KiB | 91 bytes | 29593 | 1.48 MiB | 52 bytes |
| memory/performance_schema/file_handle | 1 | 256.00 KiB | 256.00 KiB | 1 | 256.00 KiB | 256.00 KiB |
| memory/mysys/lf_dynarray | 40 | 206.75 KiB | 5.17 KiB | 40 | 206.75 KiB | 5.17 KiB |
| memory/innodb/trx0undo | 589 | 202.47 KiB | 352 bytes | 1045 | 359.22 KiB | 352 bytes |
| memory/innodb/btr0pcur | 1865 | 189.25 KiB | 103 bytes | 2157 | 220.13 KiB | 104 bytes |
| memory/performance_schema/socket_instances | 2 | 160.00 KiB | 80.00 KiB | 2 | 160.00 KiB | 80.00 KiB |
| memory/performance_schema/events_errors_summary_global_by_error | 1 | 150.25 KiB | 150.25 KiB | 1 | 150.25 KiB | 150.25 KiB |
| memory/innodb/fsp0file | 1 | 128.03 KiB | 128.03 KiB | 3 | 256.10 KiB | 85.37 KiB |
| memory/performance_schema/accounts | 1 | 112.00 KiB | 112.00 KiB | 1 | 112.00 KiB | 112.00 KiB |
| memory/innodb/trx0rseg | 388 | 105.62 KiB | 278 bytes | 388 | 105.62 KiB | 278 bytes |
| memory/mysys/lf_slist | 3280 | 102.50 KiB | 32 bytes | 3280 | 102.50 KiB | 32 bytes |
| memory/performance_schema/hosts | 1 | 96.00 KiB | 96.00 KiB | 1 | 96.00 KiB | 96.00 KiB |
| memory/performance_schema/memory_class | 1 | 84.38 KiB | 84.38 KiB | 1 | 84.38 KiB | 84.38 KiB |
| memory/innodb/fil0fil | 234 | 84.09 KiB | 368 bytes | 250 | 8.40 MiB | 34.39 KiB |
| memory/performance_schema/users | 1 | 80.00 KiB | 80.00 KiB | 1 | 80.00 KiB | 80.00 KiB |
| memory/innodb/buf0buf | 1 | 75.53 KiB | 75.53 KiB | 3 | 80.80 KiB | 26.93 KiB |
| memory/performance_schema/mutex_class | 1 | 75.00 KiB | 75.00 KiB | 1 | 75.00 KiB | 75.00 KiB |
| memory/performance_schema/events_transactions_summary_by_thread_by_event_name | 3 | 66.00 KiB | 22.00 KiB | 3 | 66.00 KiB | 22.00 KiB |
| memory/performance_schema/cond_instances | 4 | 64.00 KiB | 16.00 KiB | 4 | 64.00 KiB | 16.00 KiB |
| memory/performance_schema/setup_actors | 1 | 64.00 KiB | 64.00 KiB | 1 | 64.00 KiB | 64.00 KiB |
| memory/innodb/ut_lock_free_hash_t | 519 | 56.38 KiB | 111 bytes | 519 | 72.35 KiB | 142 bytes |
| memory/performance_schema/setup_objects | 1 | 56.00 KiB | 56.00 KiB | 1 | 56.00 KiB | 56.00 KiB |
| memory/innodb/mem0mem | 761 | 44.97 KiB | 60 bytes | 902 | 51.12 KiB | 58 bytes |
| memory/innodb/dict0dict | 284 | 44.95 KiB | 162 bytes | 290 | 46.49 KiB | 164 bytes |
| memory/performance_schema/stage_class | 1 | 43.75 KiB | 43.75 KiB | 1 | 43.75 KiB | 43.75 KiB |
| memory/sql/errmsgs | 1 | 41.40 KiB | 41.40 KiB | 1 | 41.40 KiB | 41.40 KiB |
| memory/performance_schema/statement_class | 1 | 40.88 KiB | 40.88 KiB | 1 | 40.88 KiB | 40.88 KiB |
| memory/performance_schema/events_statements_summary_global_by_event_name | 1 | 39.17 KiB | 39.17 KiB | 1 | 39.17 KiB | 39.17 KiB |
| memory/mysys/TREE | 3 | 38.02 KiB | 12.67 KiB | 39 | 740.18 KiB | 18.98 KiB |
| memory/innodb/log0log | 3 | 32.16 KiB | 10.72 KiB | 3 | 32.16 KiB | 10.72 KiB |
| memory/sql/tz_storage | 1 | 32.01 KiB | 32.01 KiB | 1 | 32.01 KiB | 32.01 KiB |
| memory/sql/Filesort_buffer::sort_keys | 1 | 32.00 KiB | 32.00 KiB | 866 | 48.11 MiB | 56.89 KiB |
| memory/performance_schema/memory_summary_global_by_event_name | 1 | 31.64 KiB | 31.64 KiB | 1 | 31.64 KiB | 31.64 KiB |
| memory/sql/binlog_cache_mngr | 33 | 29.65 KiB | 920 bytes | 288 | 258.75 KiB | 920 bytes |
| memory/performance_schema/cond_class | 1 | 25.00 KiB | 25.00 KiB | 1 | 25.00 KiB | 25.00 KiB |
| memory/performance_schema/file_class | 1 | 25.00 KiB | 25.00 KiB | 1 | 25.00 KiB | 25.00 KiB |
| memory/performance_schema/thread_class | 1 | 18.75 KiB | 18.75 KiB | 1 | 18.75 KiB | 18.75 KiB |
| memory/sql/LOG_POS_COORD | 33 | 16.53 KiB | 513 bytes | 288 | 144.28 KiB | 513 bytes |
| memory/innodb/lexyy | 3 | 16.17 KiB | 5.39 KiB | 3 | 16.17 KiB | 5.39 KiB |
| memory/performance_schema/rwlock_class | 1 | 15.00 KiB | 15.00 KiB | 1 | 15.00 KiB | 15.00 KiB |
| memory/innodb/sync0sharded_rw | 1 | 12.03 KiB | 12.03 KiB | 1 | 12.03 KiB | 12.03 KiB |
| memory/performance_schema/events_transactions_summary_by_account_by_event_name | 1 | 11.00 KiB | 11.00 KiB | 1 | 11.00 KiB | 11.00 KiB |
| memory/performance_schema/events_transactions_summary_by_host_by_event_name | 1 | 11.00 KiB | 11.00 KiB | 1 | 11.00 KiB | 11.00 KiB |
| memory/performance_schema/events_transactions_summary_by_user_by_event_name | 1 | 11.00 KiB | 11.00 KiB | 1 | 11.00 KiB | 11.00 KiB |
| memory/csv/Transparent_file | 2 | 8.00 KiB | 4.00 KiB | 2 | 8.00 KiB | 4.00 KiB |
| memory/sql/handlerton | 10 | 7.73 KiB | 792 bytes | 10 | 7.73 KiB | 792 bytes |
| memory/sql/THD::Session_tracker | 143 | 5.85 KiB | 41 bytes | 1420485 | 56.79 MiB | 41 bytes |
| memory/performance_schema/events_stages_summary_global_by_event_name | 1 | 5.47 KiB | 5.47 KiB | 1 | 5.47 KiB | 5.47 KiB |
| memory/performance_schema/scalable_buffer | 48 | 5.02 KiB | 107 bytes | 48 | 5.02 KiB | 107 bytes |
| memory/sql/THD::variables | 34 | 4.25 KiB | 128 bytes | 471 | 58.88 KiB | 128 bytes |
| memory/performance_schema/socket_class | 1 | 3.12 KiB | 3.12 KiB | 1 | 3.12 KiB | 3.12 KiB |
| memory/sql/sql_acl_mem | 6 | 2.75 KiB | 469 bytes | 7 | 2.78 KiB | 406 bytes |
| memory/mysqlx/objects | 14 | 2.61 KiB | 190 bytes | 14 | 2.61 KiB | 190 bytes |
| memory/sql/THD::Session_sysvar_resource_manager | 33 | 2.16 KiB | 67 bytes | 218629 | 11.78 MiB | 56 bytes |
| memory/innodb/trx_sys_t::rw_trx_ids | 1 | 2.03 KiB | 2.03 KiB | 3 | 3.59 KiB | 1.20 KiB |
| memory/sql/Prepared_statement_map | 22 | 1.89 KiB | 88 bytes | 884 | 75.97 KiB | 88 bytes |
| memory/csv/TINA_SHARE | 5 | 1.79 KiB | 366 bytes | 5 | 1.79 KiB | 366 bytes |
| memory/sql/sql_acl_memex | 10 | 1.62 KiB | 165 bytes | 10 | 1.62 KiB | 165 bytes |
| memory/innodb/adaptive hash index | 11 | 1.48 KiB | 137 bytes | 11 | 1.48 KiB | 137 bytes |
| memory/sql/udf_mem | 10 | 1.34 KiB | 137 bytes | 10 | 1.34 KiB | 137 bytes |
| memory/sql/ST_SCHEMA_TABLE | 26 | 1.22 KiB | 48 bytes | 26 | 1.22 KiB | 48 bytes |
| memory/sql/acl_cache | 30 | 1.19 KiB | 40 bytes | 30 | 1.19 KiB | 40 bytes |
| memory/innodb/undo::Tablespaces | 3 | 1.16 KiB | 394 bytes | 3 | 1.16 KiB | 394 bytes |
| memory/innodb/dict_stats_bg_recalc_pool_t | 2 | 1.09 KiB | 560 bytes | 2 | 1.09 KiB | 560 bytes |
| memory/innodb/trx0purge | 6 | 974 bytes | 162 bytes | 7 | 1.02 KiB | 149 bytes |
| memory/sql/user_var_entry | 11 | 968 bytes | 88 bytes | 442 | 37.98 KiB | 88 bytes |
| memory/sql/User_level_lock | 11 | 968 bytes | 88 bytes | 442 | 37.98 KiB | 88 bytes |
| memory/sql/THD::handler_tables_hash | 11 | 968 bytes | 88 bytes | 442 | 37.98 KiB | 88 bytes |
| memory/innodb/srv0srv | 3 | 904 bytes | 301 bytes | 3 | 904 bytes | 301 bytes |
| memory/innodb/buf0flu | 2 | 784 bytes | 392 bytes | 2 | 784 bytes | 392 bytes |
| memory/sql/plugin_bookmark | 17 | 752 bytes | 44 bytes | 17 | 776 bytes | 45 bytes |
| memory/sql/handler::errmsgs | 1 | 720 bytes | 720 bytes | 1 | 720 bytes | 720 bytes |
| memory/myisam/ft_stopwords | 1 | 696 bytes | 696 bytes | 1 | 696 bytes | 696 bytes |
| memory/innodb/log and page archiver | 3 | 672 bytes | 224 bytes | 4 | 825 bytes | 206 bytes |
| memory/innodb/trx0sys | 1 | 592 bytes | 592 bytes | 1 | 592 bytes | 592 bytes |
| memory/mysys/my_file_info | 36 | 582 bytes | 16 bytes | 291 | 4.04 KiB | 14 bytes |
| memory/sql/mysql_plugin | 1 | 512 bytes | 512 bytes | 2 | 768 bytes | 384 bytes |
| memory/innodb/log0recv | 1 | 408 bytes | 408 bytes | 3 | 2.00 MiB | 683.15 KiB |
| memory/sql/THD::sp_cache | 8 | 312 bytes | 39 bytes | 8 | 312 bytes | 39 bytes |
| memory/sql/TABLE::sort_io_cache | 1 | 304 bytes | 304 bytes | 367 | 108.95 KiB | 304 bytes |
| memory/sql/global_system_variables | 2 | 256 bytes | 128 bytes | 3 | 320 bytes | 106 bytes |
| memory/innodb/clone | 1 | 256 bytes | 256 bytes | 1 | 256 bytes | 256 bytes |
| memory/sql/Event_scheduler::scheduler_param | 1 | 240 bytes | 240 bytes | 2 | 256 bytes | 128 bytes |
| memory/sql/Sid_map::Node | 4 | 236 bytes | 59 bytes | 9 | 676 bytes | 75 bytes |
| memory/sql/THD::db | 34 | 235 bytes | 6 bytes | 466 | 3.18 KiB | 6 bytes |
| memory/sql/Mutex_cond_array::Mutex_cond | 2 | 208 bytes | 104 bytes | 2 | 208 bytes | 104 bytes |
| memory/sql/log_error_stack | 6 | 166 bytes | 27 bytes | 131 | 164.17 KiB | 1.25 KiB |
| memory/innodb/trx0i_s | 1 | 160 bytes | 160 bytes | 1 | 160 bytes | 160 bytes |
| memory/innodb/buf_stat_per_index_t | 2 | 152 bytes | 76 bytes | 2 | 152 bytes | 76 bytes |
| memory/mysys/my_err_head | 6 | 144 bytes | 24 bytes | 6 | 144 bytes | 24 bytes |
| memory/innodb/ibuf0ibuf | 1 | 144 bytes | 144 bytes | 1 | 144 bytes | 144 bytes |
| memory/sql/root | 1 | 136 bytes | 136 bytes | 1 | 136 bytes | 136 bytes |
| memory/sql/Rpl_info_table | 6 | 102 bytes | 17 bytes | 6 | 102 bytes | 17 bytes |
| memory/innodb/usr0sess | 2 | 96 bytes | 48 bytes | 2 | 96 bytes | 48 bytes |
| memory/innodb/ut0wqueue | 1 | 96 bytes | 96 bytes | 1 | 96 bytes | 96 bytes |
| memory/sql/host_cache::hostname | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/Owned_gtids::sidno_to_hash | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/db_worker_hash_entry | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/user_conn | 1 | 88 bytes | 88 bytes | 66737 | 4.17 MiB | 65 bytes |
| memory/blackhole/blackhole_share | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/sql/servers_cache | 1 | 88 bytes | 88 bytes | 1 | 88 bytes | 88 bytes |
| memory/innodb/pars0lex | 1 | 64 bytes | 64 bytes | 1 | 64 bytes | 64 bytes |
| memory/sql/File_query_log::name | 2 | 57 bytes | 28 bytes | 2 | 57 bytes | 28 bytes |
| memory/sql/MYSQL_LOCK | 1 | 48 bytes | 48 bytes | 847 | 32.25 KiB | 38 bytes |
| memory/innodb/ut0list | 1 | 48 bytes | 48 bytes | 1 | 48 bytes | 48 bytes |
| memory/sql/MYSQL_RELAY_LOG::index | 1 | 42 bytes | 42 bytes | 1 | 42 bytes | 42 bytes |
| memory/mysys/MY_BITMAP::bitmap | 10 | 40 bytes | 4 bytes | 878 | 3.43 KiB | 4 bytes |
| memory/sql/MYSQL_RELAY_LOG::basename | 1 | 36 bytes | 36 bytes | 1 | 36 bytes | 36 bytes |
| memory/sql/MYSQL_BIN_LOG::index | 1 | 32 bytes | 32 bytes | 1 | 32 bytes | 32 bytes |
| memory/sql/MYSQL_LOG::name | 1 | 26 bytes | 26 bytes | 2 | 52 bytes | 26 bytes |
| memory/sql/MYSQL_BIN_LOG::basename | 1 | 26 bytes | 26 bytes | 1 | 26 bytes | 26 bytes |
| memory/sql/opt_bin_logname | 1 | 26 bytes | 26 bytes | 1 | 26 bytes | 26 bytes |
| memory/vio/ssl_fd | 2 | 16 bytes | 8 bytes | 2 | 16 bytes | 8 bytes |
| memory/mysys/MY_TMPDIR::full_list | 2 | 13 bytes | 6 bytes | 2 | 13 bytes | 6 bytes |
| memory/sql/NAMED_ILINK::name | 1 | 8 bytes | 8 bytes | 1 | 8 bytes | 8 bytes |
+--------------------------------------------------------------------------------+---------------+---------------+-------------------+------------+-------------+----------------+
What else can I check to findout where it's using that much memory?
Subject
Written By
Posted
February 14, 2022 04:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.