# MySql using 309G, sys.memory\_global\_by\_current\_bytes reports 193G. Possible memory leak? **URL:** \ **Category:** MySQL & MariaDB\ **Tags:** mysql, percona\ **Created:** [June 19, 2023, 6:08pm UTC](https://forums.percona.com/t/mysql-using-309g-sys-memory-global-by-current-bytes-reports-193g-possible-memory-leak/22936 "2023-06-19T18:08:20Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![FrankD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/frankd/32/16105_2.png) [@FrankD](https://forums.percona.com/u/FrankD)\ **Post date:** [June 19, 2023, 6:08pm UTC](https://forums.percona.com/t/mysql-using-309g-sys-memory-global-by-current-bytes-reports-193g-possible-memory-leak/22936/1 "2023-06-19T18:08:20Z")
Top command gives PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2680 mysql 20 0 **309.1g 240.0g** 9556 S 167.4 95.3 166954:03 **mysqld** Version is: [fdelisle@prod-tc-db-224 ~]$ rpm -qa|grep mysql php-mysqlnd-7.3.33-8.el7.remi.x86\_64 [fdelisle@prod-tc-db-224 ~]$ rpm -qa|grep percona percona-toolkit-3.5.2-2.el7.x86\_64 percona-server-client-8.0.31-23.1.el7.x86\_64 percona-release-1.0-27.noarch percona-server-shared-8.0.31-23.1.el7.x86\_64 percona-icu-data-files-8.0.31-23.1.el7.x86\_64 percona-server-shared-compat-8.0.31-23.1.el7.x86\_64 percona-server-server-8.0.31-23.1.el7.x86\_64 kernel is: 3.10.0-1160.88.1.el7.x86\_64 Centos 7.9.2009 mysql\> SELECT event\_name, current\_alloc FROM sys.memory\_global\_by\_current\_bytes; ±-------------------------------------------------------------------------------±--------------+ | event\_name | current\_alloc | ±-------------------------------------------------------------------------------±--------------+ | memory/innodb/buf\_buf\_pool | 98.16 GiB | | memory/innodb/memory | 61.82 GiB | | memory/innodb/os0event | 6.90 GiB | | memory/performance\_schema/table\_io\_waits\_summary\_by\_index\_usage | 5.15 GiB | | memory/performance\_schema/table\_shares | 4.81 GiB | | memory/sql/TABLE\_SHARE::mem\_root | 3.87 GiB | | memory/performance\_schema/file\_instances | 3.29 GiB | | memory/innodb/dict0dict | 1.78 GiB | | memory/performance\_schema/table\_lock\_waits\_summary\_by\_table | 1.61 GiB | | memory/innodb/std | 1.55 GiB | | memory/innodb/buf0buf | 945.94 MiB | | memory/mysys/lf\_node | 703.37 MiB | | memory/mysys/lf\_slist | 702.31 MiB | | memory/innodb/ut\_lock\_free\_hash\_t | 512.25 MiB | | memory/innodb/mem0mem | 410.75 MiB | | memory/mysys/lf\_dynarray | 131.77 MiB | | memory/innodb/log\_buffer\_memory | 128.00 MiB | | memory/sql/TABLE | 123.18 MiB | | memory/performance\_schema/events\_errors\_summary\_by\_account\_by\_error | 90.43 MiB | | memory/performance\_schema/events\_errors\_summary\_by\_host\_by\_error | 90.43 MiB | | memory/performance\_schema/rwlock\_instances | 88.00 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_account\_by\_event\_name | 83.79 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_host\_by\_event\_name | 83.79 MiB | | memory/performance\_schema/table\_handles | 81.56 MiB | | memory/performance\_schema/mutex\_instances | 80.55 MiB | | memory/performance\_schema/memory\_summary\_by\_account\_by\_event\_name | 65.21 MiB | | memory/performance\_schema/memory\_summary\_by\_host\_by\_event\_name | 65.21 MiB | | memory/sql/dd::String\_type | 56.45 MiB | | memory/performance\_schema/events\_errors\_summary\_by\_thread\_by\_error | 51.67 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_thread\_by\_event\_name | 47.88 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_digest | 40.28 MiB | | memory/performance\_schema/memory\_summary\_by\_thread\_by\_event\_name | 37.27 MiB | | memory/performance\_schema/events\_waits\_summary\_by\_account\_by\_event\_name | 36.31 MiB | | memory/performance\_schema/events\_waits\_summary\_by\_host\_by\_event\_name | 36.31 MiB | | memory/sql/dd::objects | 34.66 MiB | | memory/sql/THD::main\_mem\_root | 26.15 MiB | | memory/innodb/ut0link\_buf | 24.00 MiB | | memory/innodb/lock0lock | 21.40 MiB | | memory/performance\_schema/events\_waits\_summary\_by\_thread\_by\_event\_name | 20.75 MiB | | memory/innodb/ha\_innodb | 18.43 MiB | | memory/sql/NET::buff | 17.39 MiB | | memory/temptable/physical\_ram | 15.00 MiB | | memory/performance\_schema/events\_statements\_history | 14.69 MiB | | memory/performance\_schema/events\_statements\_current | 14.69 MiB | | memory/performance\_schema/events\_statements\_history\_long | 14.34 MiB | | memory/performance\_schema/metadata\_locks | 12.50 MiB | | memory/innodb/fil0fil | 10.79 MiB | | memory/performance\_schema/events\_statements\_history.digest\_text | 10.00 MiB | | memory/performance\_schema/events\_statements\_history.sql\_text | 10.00 MiB | | memory/performance\_schema/events\_statements\_current.digest\_text | 10.00 MiB | | memory/performance\_schema/events\_statements\_current.sql\_text | 10.00 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_digest.digest\_text | 9.77 MiB | | memory/performance\_schema/events\_statements\_history\_long.digest\_text | 9.77 MiB | | memory/performance\_schema/events\_statements\_history\_long.sql\_text | 9.77 MiB | | memory/performance\_schema/events\_stages\_summary\_by\_account\_by\_event\_name | 9.57 MiB | | memory/performance\_schema/events\_stages\_summary\_by\_host\_by\_event\_name | 9.57 MiB | | memory/mysys/KEY\_CACHE | 8.00 MiB | | memory/innodb/sync0arr | 7.03 MiB | | memory/performance\_schema/events\_errors\_summary\_by\_user\_by\_error | 6.46 MiB | | memory/sql/dd::infrastructure | 6.38 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_user\_by\_event\_name | 5.99 MiB | | memory/innodb/row0sel | 5.76 MiB | | memory/performance\_schema/events\_stages\_summary\_by\_thread\_by\_event\_name | 5.47 MiB | | memory/sql/log\_sink\_pfs | 5.00 MiB | | memory/mysys/IO\_CACHE | 4.81 MiB | | memory/performance\_schema/memory\_summary\_by\_user\_by\_event\_name | 4.66 MiB | | memory/innodb/read0read | 4.48 MiB | | memory/performance\_schema/threads | 4.31 MiB | | memory/innodb/ut0pool | 4.00 MiB | | memory/performance\_schema/events\_statements\_summary\_by\_program | 3.44 MiB | | memory/performance\_schema/events\_transactions\_history | 3.36 MiB | | memory/performance\_schema/events\_transactions\_history\_long | 3.28 MiB | | memory/innodb/os0file | 2.62 MiB | | memory/performance\_schema/events\_waits\_summary\_by\_user\_by\_event\_name | 2.59 MiB | | memory/innodb/trx0trx | 2.23 MiB | | memory/performance\_schema/prepared\_statements\_instances | 1.94 MiB | | memory/performance\_schema/events\_waits\_history | 1.72 MiB | | memory/performance\_schema/events\_waits\_history\_long | 1.68 MiB | | memory/performance\_schema/accounts | 1.64 MiB | | memory/performance\_schema/hosts | 1.42 MiB | | memory/sql/acl\_cache | 1.22 MiB | | memory/performance\_schema/events\_stages\_history | 1.02 MiB | | memory/performance\_schema/events\_stages\_history\_long | 1015.62 KiB | | memory/sql/String::value | 916.30 KiB | | memory/performance\_schema/scalable\_buffer | 728.42 KiB | | memory/performance\_schema/events\_stages\_summary\_by\_user\_by\_event\_name | 700.00 KiB | | memory/performance\_schema/session\_connect\_attrs | 512.00 KiB | | memory/performance\_schema/socket\_instances | 312.00 KiB | | memory/sql/plugin\_mem\_root | 304.75 KiB | | memory/performance\_schema/file\_handle | 256.00 KiB | | memory/innodb/trx0i\_s | 192.18 KiB | | memory/innodb/trx0undo | 188.12 KiB | | memory/innodb/rem0rec | 185.28 KiB | | memory/performance\_schema/cond\_instances | 180.00 KiB | | memory/innodb/buf0dblwr | 170.09 KiB | | memory/performance\_schema/events\_errors\_summary\_global\_by\_error | 164.62 KiB | | memory/performance\_schema/events\_transactions\_summary\_by\_account\_by\_event\_name | 154.00 KiB | | memory/performance\_schema/events\_transactions\_summary\_by\_host\_by\_event\_name | 154.00 KiB | | memory/mysqld\_openssl/openssl\_malloc | 132.34 KiB | | memory/innodb/btr0pcur | 122.69 KiB | | memory/performance\_schema/memory\_class | 99.38 KiB | | memory/innodb/trx0rseg | 93.59 KiB | | memory/performance\_schema/events\_transactions\_summary\_by\_thread\_by\_event\_name | 88.00 KiB | | memory/performance\_schema/mutex\_class | 87.50 KiB | | memory/innodb/dict0mem | 85.20 KiB | | memory/performance\_schema/users | 80.00 KiB | | memory/performance\_schema/setup\_actors | 64.00 KiB | | memory/innodb/trx0sys | 61.10 KiB | | memory/performance\_schema/setup\_objects | 56.00 KiB | | memory/performance\_schema/events\_statements\_summary\_global\_by\_event\_name | 47.88 KiB | | memory/innodb/log0log | 47.23 KiB | | memory/sql/errmsgs::server | 45.35 KiB | | memory/performance\_schema/stage\_class | 43.75 KiB | | memory/performance\_schema/statement\_class | 42.56 KiB | | memory/mysys/TREE | 38.14 KiB | | memory/performance\_schema/cond\_class | 37.50 KiB | | memory/performance\_schema/memory\_summary\_global\_by\_event\_name | 37.27 KiB | | memory/innodb/dict\_stats\_bg\_recalc\_pool\_t | 32.09 KiB | | memory/sql/tz\_storage | 32.05 KiB | | memory/sql/Filesort\_buffer::sort\_keys | 32.03 KiB | | memory/performance\_schema/thread\_class | 25.00 KiB | | memory/performance\_schema/file\_class | 25.00 KiB | | memory/sql/binlog\_cache\_mngr | 24.97 KiB | | memory/performance\_schema/rwlock\_class | 17.50 KiB | | memory/innodb/lexyy | 16.17 KiB | | memory/innodb/sync0debug | 15.90 KiB | | memory/innodb/sync0sharded\_rw | 11.53 KiB | | memory/sql/THD::Session\_tracker | 11.26 KiB | | memory/performance\_schema/events\_transactions\_summary\_by\_user\_by\_event\_name | 11.00 KiB | | memory/sql/handlerton::objects | 9.06 KiB | | memory/sql/LOG\_POS\_COORD | 9.05 KiB | | memory/csv/Transparent\_file | 8.06 KiB | | memory/innodb/trx\_sys\_t::rw\_trx\_ids | 8.03 KiB | | memory/innodb/srv0tmp | 7.72 KiB | | memory/sql/sql\_acl\_mem | 7.12 KiB | | memory/performance\_schema/events\_stages\_summary\_global\_by\_event\_name | 5.47 KiB | | memory/sql/THD::variables | 5.03 KiB | | memory/sql/udf\_mem | 3.80 KiB | | memory/sql/THD::Session\_sysvar\_resource\_manager | 3.48 KiB | | memory/performance\_schema/socket\_class | 3.12 KiB | | memory/mysqlx/objects | 3.11 KiB | | memory/sql/plugin\_bookmark | 3.02 KiB | | memory/sql/Prepared\_statement::infrastructure | 2.81 KiB | | memory/mysys/MY\_BITMAP::bitmap | 2.11 KiB | | memory/sql/ST\_SCHEMA\_TABLE | 2.03 KiB | | memory/sql/sql\_acl\_memex | 1.76 KiB | | memory/innodb/srv0srv | 1.54 KiB | | memory/innodb/trx0purge | 1.50 KiB | | memory/innodb/adaptive hash index | 1.41 KiB | | memory/sql/user\_var\_entry | 1.41 KiB | | memory/sql/User\_level\_lock | 1.41 KiB | | memory/sql/THD::handler\_tables\_hash | 1.41 KiB | | memory/innodb/buf0flu | 1.20 KiB | | memory/innodb/undo::Tablespaces | 1.16 KiB | | memory/vio/vio | 1.09 KiB | | memory/sql/THD::db | 1.07 KiB | | memory/csv/TINA\_SHARE | 1.03 KiB | | memory/sql/errmsgs::handler | 760 bytes | | memory/myisam/ft\_stopwords | 728 bytes | | memory/innodb/log and page archiver | 680 bytes | | memory/sql/user\_conn | 666 bytes | | memory/sql/db\_worker\_hash\_entry | 600 bytes | | memory/sql/mysql\_plugin | 544 bytes | | memory/mysys/my\_err\_head | 504 bytes | | memory/mysys/my\_file\_info | 480 bytes | | memory/sql/global\_system\_variables | 448 bytes | | memory/innodb/log0recv | 424 bytes | | memory/sql/log\_error::stack | 374 bytes | | memory/sql/Sid\_map::Node | 364 bytes | | memory/sql/TABLE::sort\_io\_cache | 336 bytes | | memory/sql/Rpl\_info\_table | 294 bytes | | memory/sql/Event\_scheduler::scheduler\_param | 272 bytes | | memory/sql/Mutex\_cond\_array::Mutex\_cond | 272 bytes | | memory/innodb/clone | 256 bytes | | memory/sql/MYSQL\_LOCK | 208 bytes | | memory/sql/File\_query\_log::name | 181 bytes | | memory/sql/root | 176 bytes | | memory/innodb/buf\_stat\_per\_index\_t | 152 bytes | | memory/innodb/ibuf0ibuf | 144 bytes | | memory/sql/host\_cache::hostname | 120 bytes | | memory/sql/Owned\_gtids::sidno\_to\_hash | 120 bytes | | memory/sql/userstat\_table\_stats | 120 bytes | | memory/sql/userstat\_index\_stats | 120 bytes | | memory/sql/userstat\_user\_stats | 120 bytes | | memory/sql/userstat\_thread\_stats | 120 bytes | | memory/sql/userstat\_client\_stats | 120 bytes | | memory/blackhole/blackhole\_share | 120 bytes | | memory/sql/servers\_cache | 120 bytes | | memory/mysys/MY\_TMPDIR::full\_list | 111 bytes | | memory/innodb/ut0wqueue | 104 bytes | | memory/sql/MYSQL\_RELAY\_LOG::index | 100 bytes | | memory/innodb/usr0sess | 96 bytes | | memory/sql/MYSQL\_RELAY\_LOG::basename | 94 bytes | | memory/sql/LOG::file\_name | 93 bytes | | memory/sql/MYSQL\_BIN\_LOG::index | 87 bytes | | memory/sql/MYSQL\_LOG::name | 81 bytes | | memory/sql/MYSQL\_BIN\_LOG::basename | 81 bytes | | memory/sql/opt\_bin\_logname | 81 bytes | | memory/vio/ssl\_fd | 80 bytes | | memory/innodb/sync0types | 48 bytes | | memory/innodb/ut0list | 48 bytes | ±-------------------------------------------------------------------------------±--------------+ 201 rows in set (0.06 sec) ---
**Author:** ![FrankD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/frankd/32/16105_2.png) [@FrankD](https://forums.percona.com/u/FrankD)\ **Post date:** [June 20, 2023, 2:45pm UTC](https://forums.percona.com/t/mysql-using-309g-sys-memory-global-by-current-bytes-reports-193g-possible-memory-leak/22936/2 "2023-06-20T14:45:27Z")
[fdelisle@prod-tc-db-224 ~]$ cat /etc/my.cnf [mysql] default-character-set=utf8mb4 socket = /mnt/disks/tapclicks-data/mysql-data/mysqld.sock [client] socket=/mnt/disks/tapclicks-data/mysql-data/mysqld.sock [mysqld\_safe] socket = /mnt/disks/tapclicks-data/mysql-data/mysqld.sock malloc-lib=/usr/lib64/libjemalloc.so.1 [mysqld] # # \* Basic Settings # Master server-id = 224 pid-file = /mnt/disks/tapclicks-data/mysql-data/mysqld.pid socket = /mnt/disks/tapclicks-data/mysql-data/mysqld.sock port = 3306 basedir = /usr/ datadir = /mnt/disks/tapclicks-data/mysql-data tmpdir = /mnt/disks/tapclicks-data/mysql-tmpdir log\_error = /mnt/disks/tapclicks-data/mysql-logs/stg-tapclicks-app-db.err lc\_messages\_dir = /usr/share/mysql-8.0/ bind-address = 0.0.0.0 log\_error\_verbosity = 3 skip-name-resolve default\_authentication\_plugin=mysql\_native\_password #skip-grant-tables # # \* Fine Tuning # wait\_timeout = 86400 # REPLICATION relay-log-recovery = 1 master-info-repository = TABLE relay-log-info-repository = TABLE expire\_logs\_days = 3 #gtid\_mode = OFF\_PERMISSIVE binlog\_cache\_size = 262144 binlog\_row\_image = MINIMAL log\_statements\_unsafe\_for\_binlog = 0 log\_bin = /mnt/disks/tapclicks-data/mysql-binlog/mysql-bin log\_bin\_index = /mnt/disks/tapclicks-data/mysql-binlog/mysql-bin.index sync\_binlog = 1000 max\_binlog\_size = 100M binlog\_format = MIXED log\_bin\_trust\_function\_creators = 1 skip\_replica\_start replica\_skip\_errors = 1062,1032 # GENERAL default-storage-engine = InnoDB default-time-zone = ‘+00:00’ sql\_mode = NO\_ENGINE\_SUBSTITUTION connect\_timeout = 86400 interactive\_timeout = 86400 collation-server = utf8mb4\_0900\_ai\_ci character-set-server = utf8mb4 group\_concat\_max\_len = 65000 lock\_wait\_timeout = 600 # SAFETY max-connect-errors = 32000 #skip-name-resolve ## Cause problem with PMM Client innodb = FORCE max\_allowed\_packet = 512M # CACHES AND LIMITS open-files-limit = 1000000 table-definition-cache = 150000 table-open-cache = 150000 table\_open\_cache\_instances = 32 tablespace\_definition\_cache = 100000 schema\_definition\_cache = 1000 read\_rnd\_buffer\_size = 64M range\_optimizer\_max\_mem\_size = 32M regexp\_time\_limit = 1024 # \* InnoDB # default\_storage\_engine = InnoDB innodb-flush-method = fsync innodb\_redo\_log\_capacity=32G innodb-file-per-table = 1 innodb\_strict\_mode = 0 innodb\_monitor\_enable = all innodb\_io\_capacity = 1000 innodb\_io\_capacity\_max = 5000 innodb\_log\_buffer\_size = 128M innodb\_log\_write\_ahead\_size = 4096 innodb\_stats\_persistent\_sample\_pages = 1000 innodb\_sync\_array\_size = 16 innodb\_open\_files = 400000 innodb\_log\_compressed\_pages = OFF transaction-isolation = READ-COMMITTED innodb\_online\_alter\_log\_max\_size = 2G innodb\_print\_lock\_wait\_timeout\_info = ON # LOGGING long\_query\_time = 20 slow-query-log = 1 log\_output = TABLE performance\_schema = 1 # innodb\_force\_recovery ## DYNAMIC innodb\_buffer\_pool\_instances = 16 # 8 or 16 if 16+ cpu max\_heap\_table\_size = 256M #1/1000 memory sort\_buffer\_size = 256M #1/1000 memory tmp\_table\_size = 2560M # 1% memory temptable\_max\_ram = 25600M # 10% memory max-connections = 1600 # nb cpu \* 100 min 800 innodb-buffer-pool-size = 96G # 40-60% pool size max\_user\_connections=1550 ---
**Author:** ![FrankD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/frankd/32/16105_2.png) [@FrankD](https://forums.percona.com/u/FrankD)\ **Post date:** [June 20, 2023, 2:47pm UTC](https://forums.percona.com/t/mysql-using-309g-sys-memory-global-by-current-bytes-reports-193g-possible-memory-leak/22936/3 "2023-06-20T14:47:13Z")
select from sys.memory\_global\_by\_current\_bytes. gives 193 Gig total used Pmap gives: pmap 2680 2680: /usr/sbin/mysqld … total 324069700K Well over the 193 Gig sys.memory\_global\_by\_current\_bytes reports .