MySQL Forums
Forum List  »  General

Re: How to check what is using memory in my mysql instance?
Posted by: Jeevan Patnaik
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)

Options: ReplyQuote


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.