Re: How to check what is using memory in my mysql instance?
Posted by: Jeevan Patnaik
Date: February 14, 2022 04:27AM
Date: February 14, 2022 04:27AM
Jeevan Patnaik Wrote:
-------------------------------------------------------
> 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?
i.e,. MySQL reports 9.x GB in sys.memory_global_total:
mysql> select * from memory_global_total;
+-----------------+
| total_allocated |
+-----------------+
| 9.08 GiB |
+-----------------+
whereas ps reports 15.x G
# ps -o rss,command -C mysqld
RSS COMMAND
15823320 /sbin/mysqld
I think it's not part of OS buffers/cache as well, as when I sum overall rss usage of all processes that are running, it is almost equal to memory used (i..e, memory with OS buffers and cache excluded)
-------------------------------------------------------
> 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?
i.e,. MySQL reports 9.x GB in sys.memory_global_total:
mysql> select * from memory_global_total;
+-----------------+
| total_allocated |
+-----------------+
| 9.08 GiB |
+-----------------+
whereas ps reports 15.x G
# ps -o rss,command -C mysqld
RSS COMMAND
15823320 /sbin/mysqld
I think it's not part of OS buffers/cache as well, as when I sum overall rss usage of all processes that are running, it is almost equal to memory used (i..e, memory with OS buffers and cache excluded)
Subject
Written By
Posted
Re: How to check what is using memory in my mysql instance?
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.