With top: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 114529 mysql 20 0 8935968 6.3g 19416 S 0.3 83.4 55:17.12 mysqld Pmap : [test] root@VM05-03-001-014-00000617:~# pmap 114529 114529: /usr/sbin/mysqld --defaults-file=/mnt/mysql/conf/my.cnf 0000000000400000 54856K r-x-- mysqld 0000000003992000 1372K r---- mysqld 0000000003ae9000 3596K rw--- mysqld 0000000003e6c000 5296K rw--- [ anon ] 00000000054d0000 68140K rw--- [ anon ] 00007f6bcc000000 29660K rw--- [ anon ] 00007f6bcdcf7000 35876K ----- [ anon ] 00007f6bd4000000 23896K rw--- [ anon ] 00007f6bd5756000 41640K ----- [ anon ] 00007f6be4000000 132K rw--- [ anon ] 00007f6be4021000 65404K ----- [ anon ] 00007f6be8000000 132K rw--- [ anon ] 00007f6be8021000 65404K ----- [ anon ] 00007f6bec000000 65324K rw--- [ anon ] 00007f6beffcb000 212K ----- [ anon ] 00007f6bf4000000 132K rw--- [ anon ] 00007f6bf4021000 65404K ----- [ anon ] 00007f6bf8000000 31012K rw--- [ anon ] 00007f6bf9e49000 34524K ----- [ anon ] 00007f6c00000000 65324K rw--- [ anon ] 00007f6c03fcb000 212K ----- [ anon ] 00007f6c04000000 58384K rw--- [ anon ] 00007f6c07904000 7152K ----- [ anon ] 00007f6c08000000 65324K rw--- [ anon ] 00007f6c0bfcb000 212K ----- [ anon ] 00007f6c0c000000 65332K rw--- [ anon ] 00007f6c0ffcd000 204K ----- [ anon ] 00007f6c10000000 65508K rw--- [ anon ] 00007f6c13ff9000 28K ----- [ anon ] 00007f6c14000000 65508K rw--- [ anon ] 00007f6c17ff9000 28K ----- [ anon ] 00007f6c18000000 65504K rw--- [ anon ] 00007f6c1bff8000 32K ----- [ anon ] 00007f6c20000000 65380K rw--- [ anon ] 00007f6c23fd9000 156K ----- [ anon ] 00007f6c28000000 65496K rw--- [ anon ] 00007f6c2bff6000 40K ----- [ anon ] 00007f6c2c000000 65324K rw--- [ anon ] 00007f6c2ffcb000 212K ----- [ anon ] 00007f6c30000000 65508K rw--- [ anon ] 00007f6c33ff9000 28K ----- [ anon ] 00007f6c34000000 65332K rw--- [ anon ] 00007f6c37fcd000 204K ----- [ anon ] 00007f6c3c000000 65324K rw--- [ anon ] 00007f6c3ffcb000 212K ----- [ anon ] 00007f6c40000000 65324K rw--- [ anon ] 00007f6c43fcb000 212K ----- [ anon ] 00007f6c44000000 132K rw--- [ anon ] 00007f6c44021000 65404K ----- [ anon ] 00007f6c48000000 132K rw--- [ anon ] 00007f6c48021000 65404K ----- [ anon ] 00007f6c50000000 65324K rw--- [ anon ] 00007f6c53fcb000 212K ----- [ anon ] 00007f6c54000000 65420K rw--- [ anon ] 00007f6c57fe3000 116K ----- [ anon ] 00007f6c5c000000 65496K rw--- [ anon ] 00007f6c5fff6000 40K ----- [ anon ] 00007f6c64000000 65332K rw--- [ anon ] 00007f6c67fcd000 204K ----- [ anon ] 00007f6c68000000 65324K rw--- [ anon ] 00007f6c6bfcb000 212K ----- [ anon ] 00007f6c6c000000 63804K rw--- [ anon ] 00007f6c6fe4f000 1732K ----- [ anon ] 00007f6c70000000 65392K rw--- [ anon ] 00007f6c73fdc000 144K ----- [ anon ] 00007f6c74000000 65324K rw--- [ anon ] 00007f6c77fcb000 212K ----- [ anon ] 00007f6c78000000 65504K rw--- [ anon ] 00007f6c7bff8000 32K ----- [ anon ] 00007f6c7c000000 65324K rw--- [ anon ] 00007f6c7ffcb000 212K ----- [ anon ] 00007f6c80000000 65332K rw--- [ anon ] 00007f6c83fcd000 204K ----- [ anon ] 00007f6c84000000 65500K rw--- [ anon ] 00007f6c87ff7000 36K ----- [ anon ] 00007f6c88000000 65508K rw--- [ anon ] 00007f6c8bff9000 28K ----- [ anon ] 00007f6c8c000000 65508K rw--- [ anon ] 00007f6c8fff9000 28K ----- [ anon ] 00007f6c90000000 65324K rw--- [ anon ] 00007f6c93fcb000 212K ----- [ anon ] 00007f6c94000000 65340K rw--- [ anon ] 00007f6c97fcf000 196K ----- [ anon ] 00007f6c9c000000 65332K rw--- [ anon ] 00007f6c9ffcd000 204K ----- [ anon ] 00007f6ca0000000 65500K rw--- [ anon ] 00007f6ca3ff7000 36K ----- [ anon ] 00007f6ca4000000 65332K rw--- [ anon ] 00007f6ca7fcd000 204K ----- [ anon ] 00007f6ca8000000 65328K rw--- [ anon ] 00007f6cabfcc000 208K ----- [ anon ] 00007f6cac000000 64932K rw--- [ anon ] 00007f6caff69000 604K ----- [ anon ] 00007f6cb0000000 65336K rw--- [ anon ] 00007f6cb3fce000 200K ----- [ anon ] 00007f6cb4000000 60600K rw--- [ anon ] 00007f6cb7b2e000 4936K ----- [ anon ] 00007f6cb8000000 65340K rw--- [ anon ] 00007f6cbbfcf000 196K ----- [ anon ] 00007f6cbc000000 26688K rw--- [ anon ] 00007f6cbda10000 38848K ----- [ anon ] 00007f6cc0000000 4460K rw--- [ anon ] 00007f6cc045b000 61076K ----- [ anon ] 00007f6cc4000000 65324K rw--- [ anon ] 00007f6cc7fcb000 212K ----- [ anon ] 00007f6cc8000000 65512K rw--- [ anon ] 00007f6ccbffa000 24K ----- [ anon ] 00007f6ccc000000 65328K rw--- [ anon ] 00007f6ccffcc000 208K ----- [ anon ] 00007f6cd0000000 65496K rw--- [ anon ] 00007f6cd3ff6000 40K ----- [ anon ] 00007f6cd4000000 65328K rw--- [ anon ] 00007f6cd7fcc000 208K ----- [ anon ] 00007f6cd8000000 65508K rw--- [ anon ] 00007f6cdbff9000 28K ----- [ anon ] 00007f6cdc000000 65328K rw--- [ anon ] 00007f6cdffcc000 208K ----- [ anon ] 00007f6ce0000000 65332K rw--- [ anon ] 00007f6ce3fcd000 204K ----- [ anon ] 00007f6ce4000000 4472K rw--- [ anon ] 00007f6ce445e000 61064K ----- [ anon ] 00007f6ce8000000 58216K rw--- [ anon ] 00007f6ceb8da000 7320K ----- [ anon ] 00007f6cec000000 65380K rw--- [ anon ] 00007f6ceffd9000 156K ----- [ anon ] 00007f6cf0000000 62712K rw--- [ anon ] 00007f6cf3d3e000 2824K ----- [ anon ] 00007f6cf4000000 132K rw--- [ anon ] 00007f6cf4021000 65404K ----- [ anon ] 00007f6cf8000000 64812K rw--- [ anon ] 00007f6cfbf4b000 724K ----- [ anon ] 00007f6cfc000000 65324K rw--- [ anon ] 00007f6cfffcb000 212K ----- [ anon ] 00007f6d04000000 132K rw--- [ anon ] 00007f6d04021000 65404K ----- [ anon ] 00007f6d08000000 65500K rw--- [ anon ] 00007f6d0bff7000 36K ----- [ anon ] 00007f6d0c000000 58216K rw--- [ anon ] 00007f6d0f8da000 7320K ----- [ anon ] 00007f6d10000000 132K rw--- [ anon ] 00007f6d10021000 65404K ----- [ anon ] 00007f6d14000000 65528K rw--- [ anon ] 00007f6d17ffe000 8K ----- [ anon ] 00007f6d18000000 65360K rw--- [ anon ] 00007f6d1bfd4000 176K ----- [ anon ] 00007f6d1c000000 58568K rw--- [ anon ] 00007f6d1f932000 6968K ----- [ anon ] 00007f6d20000000 65452K rw--- [ anon ] 00007f6d23feb000 84K ----- [ anon ] 00007f6d24000000 65520K rw--- [ anon ] 00007f6d27ffc000 16K ----- [ anon ] 00007f6d28000000 65440K rw--- [ anon ] 00007f6d2bfe8000 96K ----- [ anon ] 00007f6d2c000000 132K rw--- [ anon ] 00007f6d2c021000 65404K ----- [ anon ] 00007f6d30000000 3476K rw--- [ anon ] 00007f6d30365000 62060K ----- [ anon ] 00007f6d34000000 132K rw--- [ anon ] 00007f6d34021000 65404K ----- [ anon ] 00007f6d38000000 132K rw--- [ anon ] 00007f6d38021000 65404K ----- [ anon ] 00007f6d3c000000 680K rw--- [ anon ] 00007f6d3c0aa000 64856K ----- [ anon ] 00007f6d40000000 132K rw--- [ anon ] 00007f6d40021000 65404K ----- [ anon ] 00007f6d44000000 952K rw--- [ anon ] 00007f6d440ee000 64584K ----- [ anon ] 00007f6d4c000000 1524K rw--- [ anon ] 00007f6d4c17d000 64012K ----- [ anon ] 00007f6d50000000 7596K rw--- [ anon ] 00007f6d5076b000 57940K ----- [ anon ] 00007f6d54000000 1672K rw--- [ anon ] 00007f6d541a2000 63864K ----- [ anon ] 00007f6d58ffa000 4K ----- [ anon ] 00007f6d58ffb000 8192K rw--- [ anon ] 00007f6d597fb000 4K ----- [ anon ] 00007f6d597fc000 8192K rw--- [ anon ] 00007f6d59ffc000 4K ----- [ anon ] 00007f6d59ffd000 8192K rw--- [ anon ] 00007f6d5a7fd000 4K ----- [ anon ] 00007f6d5a7fe000 8192K rw--- [ anon ] 00007f6d5affe000 4K ----- [ anon ] 00007f6d5afff000 8192K rw--- [ anon ] 00007f6d5b7ff000 4K ----- [ anon ] 00007f6d5b800000 8192K rw--- [ anon ] 00007f6d5c000000 8836K rw--- [ anon ] 00007f6d5c8a1000 56700K ----- [ anon ] 00007f6d600c8000 80K r-x-- libresolv-2.28.so 00007f6d600dc000 2044K ----- libresolv-2.28.so 00007f6d602db000 4K r---- libresolv-2.28.so 00007f6d602dc000 4K rw--- libresolv-2.28.so 00007f6d602dd000 8K rw--- [ anon ] 00007f6d602df000 4K ----- [ anon ] 00007f6d602e0000 8192K rw--- [ anon ] 00007f6d60ae0000 4K ----- [ anon ] 00007f6d60ae1000 8192K rw--- [ anon ] 00007f6d612e1000 4K ----- [ anon ] 00007f6d612e2000 8192K rw--- [ anon ] 00007f6d61ae2000 4K ----- [ anon ] 00007f6d61ae3000 8192K rw--- [ anon ] 00007f6d622e3000 4K ----- [ anon ] 00007f6d622e4000 8192K rw--- [ anon ] 00007f6d62ae4000 4K ----- [ anon ] 00007f6d62ae5000 8192K rw--- [ anon ] 00007f6d632e5000 4K ----- [ anon ] 00007f6d632e6000 8192K rw--- [ anon ] 00007f6d63ae6000 4K ----- [ anon ] 00007f6d63ae7000 8192K rw--- [ anon ] 00007f6d642e7000 4K ----- [ anon ] 00007f6d642e8000 8192K rw--- [ anon ] 00007f6d64ae8000 4K ----- [ anon ] 00007f6d64ae9000 8192K rw--- [ anon ] 00007f6d652e9000 4K ----- [ anon ] 00007f6d652ea000 8192K rw--- [ anon ] 00007f6d65aea000 4K ----- [ anon ] 00007f6d65aeb000 8192K rw--- [ anon ] 00007f6d662eb000 4K ----- [ anon ] 00007f6d662ec000 24580K rw--- [ anon ] 00007f6d67aed000 4K ----- [ anon ] 00007f6d67aee000 8192K rw--- [ anon ] 00007f6d682ee000 4K ----- [ anon ] 00007f6d682ef000 8192K rw--- [ anon ] 00007f6d68aef000 4K ----- [ anon ] 00007f6d68af0000 8192K rw--- [ anon ] 00007f6d692f0000 4K ----- [ anon ] 00007f6d692f1000 8192K rw--- [ anon ] 00007f6d69af1000 4K ----- [ anon ] 00007f6d69af2000 8192K rw--- [ anon ] 00007f6d6a2f2000 4K ----- [ anon ] 00007f6d6a2f3000 8192K rw--- [ anon ] 00007f6d6aaf3000 4K ----- [ anon ] 00007f6d6aaf4000 8192K rw--- [ anon ] 00007f6d6b2f4000 4K ----- [ anon ] 00007f6d6b2f5000 8192K rw--- [ anon ] 00007f6d6baf5000 4K ----- [ anon ] 00007f6d6baf6000 8192K rw--- [ anon ] 00007f6d6c2f6000 4K ----- [ anon ] 00007f6d6c2f7000 8192K rw--- [ anon ] 00007f6d6caf7000 4K ----- [ anon ] 00007f6d6caf8000 8192K rw--- [ anon ] 00007f6d6d2f8000 4K ----- [ anon ] 00007f6d6d2f9000 8192K rw--- [ anon ] 00007f6d6daf9000 4K ----- [ anon ] 00007f6d6dafa000 8192K rw--- [ anon ] 00007f6d6e2fa000 4K ----- [ anon ] 00007f6d6e2fb000 8192K rw--- [ anon ] 00007f6d6eafb000 4K ----- [ anon ] 00007f6d6eafc000 8192K rw--- [ anon ] 00007f6d6f2fc000 4K ----- [ anon ] 00007f6d6f2fd000 8192K rw--- [ anon ] 00007f6d6fafd000 4K ----- [ anon ] 00007f6d6fafe000 8192K rw--- [ anon ] 00007f6d702fe000 4K ----- [ anon ] 00007f6d702ff000 8192K rw--- [ anon ] 00007f6d70aff000 4K ----- [ anon ] 00007f6d70b00000 2020352K rw--- [ anon ] 00007f6dec000000 19984K rw--- [ anon ] 00007f6ded384000 45552K ----- [ anon ] 00007f6df0050000 4K ----- [ anon ] 00007f6df0051000 284K rw--- [ anon ] 00007f6df0098000 4K ----- [ anon ] 00007f6df0099000 284K rw--- [ anon ] 00007f6df00e0000 20K r-x-- libnss_dns-2.28.so 00007f6df00e5000 2048K ----- libnss_dns-2.28.so 00007f6df02e5000 4K r---- libnss_dns-2.28.so 00007f6df02e6000 4K rw--- libnss_dns-2.28.so 00007f6df02e7000 4K ----- [ anon ] 00007f6df02e8000 8192K rw--- [ anon ] 00007f6df0ae8000 4K ----- [ anon ] 00007f6df0ae9000 8192K rw--- [ anon ] 00007f6df12e9000 4K ----- [ anon ] 00007f6df12ea000 8192K rw--- [ anon ] 00007f6df1aea000 4K ----- [ anon ] 00007f6df1aeb000 8192K rw--- [ anon ] 00007f6df22eb000 4K ----- [ anon ] 00007f6df22ec000 8192K rw--- [ anon ] 00007f6df2aec000 4K ----- [ anon ] 00007f6df2aed000 8192K rw--- [ anon ] 00007f6df32ed000 4K ----- [ anon ] 00007f6df32ee000 13384K rw--- [ anon ] 00007f6df4000000 15540K rw--- [ anon ] 00007f6df4f2d000 49996K ----- [ anon ] 00007f6df8033000 44K r-x-- libnss_files-2.28.so 00007f6df803e000 2044K ----- libnss_files-2.28.so 00007f6df823d000 4K r---- libnss_files-2.28.so 00007f6df823e000 4K rw--- libnss_files-2.28.so 00007f6df823f000 15324K rw--- [ anon ] 00007f6df915f000 4K ----- [ anon ] 00007f6df9160000 284K rw--- [ anon ] 00007f6df91a7000 4K ----- [ anon ] 00007f6df91a8000 284K rw--- [ anon ] 00007f6df91ef000 4K ----- [ anon ] 00007f6df91f0000 284K rw--- [ anon ] 00007f6df9337000 168736K rw--- [ anon ] 00007f6e037ff000 4K ----- [ anon ] 00007f6e03800000 8192K rw--- [ anon ] 00007f6e04000000 15548K rw--- [ anon ] 00007f6e04f2f000 49988K ----- [ anon ] 00007f6e08000000 15824K rw--- [ anon ] 00007f6e08f74000 49712K ----- [ anon ] 00007f6e0c000000 65532K rw--- [ anon ] 00007f6e0ffff000 4K ----- [ anon ] 00007f6e1000a000 4K ----- [ anon ] 00007f6e1000b000 284K rw--- [ anon ] 00007f6e10052000 4K ----- [ anon ] 00007f6e10053000 284K rw--- [ anon ] 00007f6e1009a000 4K ----- [ anon ] 00007f6e1009b000 284K rw--- [ anon ] 00007f6e100e2000 4K ----- [ anon ] 00007f6e100e3000 4900K rw--- [ anon ] 00007f6e105ac000 4K ----- [ anon ] 00007f6e105ad000 8192K rw--- [ anon ] 00007f6e10dad000 4K ----- [ anon ] 00007f6e10dae000 8192K rw--- [ anon ] 00007f6e115ae000 4K ----- [ anon ] 00007f6e115af000 8192K rw--- [ anon ] 00007f6e11daf000 36K rw-s- [aio] (deleted) 00007f6e11db8000 36K rw-s- [aio] (deleted) 00007f6e11dc1000 36K rw-s- [aio] (deleted) 00007f6e11dca000 36K rw-s- [aio] (deleted) 00007f6e11dd3000 36K rw-s- [aio] (deleted) 00007f6e11ddc000 36K rw-s- [aio] (deleted) 00007f6e11de5000 36K rw-s- [aio] (deleted) 00007f6e11dee000 36K rw-s- [aio] (deleted) 00007f6e11df7000 36K rw-s- [aio] (deleted) 00007f6e11e00000 36K rw-s- [aio] (deleted) 00007f6e11e09000 36K rw-s- [aio] (deleted) 00007f6e11e12000 36K rw-s- [aio] (deleted) 00007f6e11e1b000 36K rw-s- [aio] (deleted) 00007f6e11e24000 796K rw--- [ anon ] 00007f6e11eeb000 36K rw-s- [aio] (deleted) 00007f6e11ef4000 36K rw-s- [aio] (deleted) 00007f6e11efd000 36K rw-s- [aio] (deleted) 00007f6e11f06000 36K rw-s- [aio] (deleted) 00007f6e11f0f000 36K rw-s- [aio] (deleted) 00007f6e11f18000 36K rw-s- [aio] (deleted) 00007f6e11f21000 36K rw-s- [aio] (deleted) 00007f6e11f2a000 36K rw-s- [aio] (deleted) 00007f6e11f33000 36K rw-s- [aio] (deleted) 00007f6e11f3c000 36K rw-s- [aio] (deleted) 00007f6e11f45000 36K rw-s- [aio] (deleted) 00007f6e11f4e000 36K rw-s- [aio] (deleted) 00007f6e11f57000 36K rw-s- [aio] (deleted) 00007f6e11f60000 11300K rw--- [ anon ] 00007f6e12a69000 4K ----- [ anon ] 00007f6e12a6a000 24712K rw--- [ anon ] 00007f6e1428c000 8212K r--s- passwd 00007f6e14a91000 32K r-x-- libnss_sss.so.2 00007f6e14a99000 2044K ----- libnss_sss.so.2 00007f6e14c98000 4K r---- libnss_sss.so.2 00007f6e14c99000 4K rw--- libnss_sss.so.2 00007f6e14c9a000 182844K rw--- [ anon ] 00007f6e1ff29000 88K r-x-- libz.so.1.2.11 00007f6e1ff3f000 2044K ----- libz.so.1.2.11 00007f6e2013e000 4K r---- libz.so.1.2.11 00007f6e2013f000 4K rw--- [ anon ] 00007f6e20140000 1764K r-x-- libc-2.28.so 00007f6e202f9000 2048K ----- libc-2.28.so 00007f6e204f9000 16K r---- libc-2.28.so 00007f6e204fd000 8K rw--- libc-2.28.so 00007f6e204ff000 16K rw--- [ anon ] 00007f6e20503000 92K r-x-- libgcc_s-8-20190507.so.1 00007f6e2051a000 2044K ----- libgcc_s-8-20190507.so.1 00007f6e20719000 4K r---- libgcc_s-8-20190507.so.1 00007f6e2071a000 4K rw--- libgcc_s-8-20190507.so.1 00007f6e2071b000 1540K r-x-- libm-2.28.so 00007f6e2089c000 2044K ----- libm-2.28.so 00007f6e20a9b000 4K r---- libm-2.28.so 00007f6e20a9c000 4K rw--- libm-2.28.so 00007f6e20a9d000 1560K r-x-- libstdc++.so.6.0.25 00007f6e20c23000 2044K ----- libstdc++.so.6.0.25 00007f6e20e22000 48K r---- libstdc++.so.6.0.25 00007f6e20e2e000 4K rw--- libstdc++.so.6.0.25 00007f6e20e2f000 12K rw--- [ anon ] 00007f6e20e32000 44K r-x-- libnuma.so.1.0.0 00007f6e20e3d000 2044K ----- libnuma.so.1.0.0 00007f6e2103c000 4K r---- libnuma.so.1.0.0 00007f6e2103d000 4K rw--- libnuma.so.1.0.0 00007f6e2103e000 8K r-x-- libaio.so.1.0.1 00007f6e21040000 2044K ----- libaio.so.1.0.1 00007f6e2123f000 4K r---- libaio.so.1.0.1 00007f6e21240000 4K rw--- [ anon ] 00007f6e21241000 12K r-x-- libdl-2.28.so 00007f6e21244000 2044K ----- libdl-2.28.so 00007f6e21443000 4K r---- libdl-2.28.so 00007f6e21444000 4K rw--- libdl-2.28.so 00007f6e21445000 2736K r-x-- libcrypto.so.1.1.1c 00007f6e216f1000 2044K ----- libcrypto.so.1.1.1c 00007f6e218f0000 172K r---- libcrypto.so.1.1.1c 00007f6e2191b000 16K rw--- libcrypto.so.1.1.1c 00007f6e2191f000 16K rw--- [ anon ] 00007f6e21923000 536K r-x-- libssl.so.1.1.1c 00007f6e219a9000 2048K ----- libssl.so.1.1.1c 00007f6e21ba9000 36K r---- libssl.so.1.1.1c 00007f6e21bb2000 16K rw--- libssl.so.1.1.1c 00007f6e21bb6000 4K rw--- [ anon ] 00007f6e21bb7000 28K r-x-- librt-2.28.so 00007f6e21bbe000 2048K ----- librt-2.28.so 00007f6e21dbe000 4K r---- librt-2.28.so 00007f6e21dbf000 4K rw--- librt-2.28.so 00007f6e21dc0000 128K r-x-- libcrypt.so.1.1.0 00007f6e21de0000 2044K ----- libcrypt.so.1.1.0 00007f6e21fdf000 4K r---- libcrypt.so.1.1.0 00007f6e21fe0000 36K rw--- [ anon ] 00007f6e21fe9000 572K r-x-- libprotobuf-lite.so.3.11.4 00007f6e22078000 2044K ----- libprotobuf-lite.so.3.11.4 00007f6e22277000 8K r---- libprotobuf-lite.so.3.11.4 00007f6e22279000 4K rw--- libprotobuf-lite.so.3.11.4 00007f6e2227a000 4K rw--- [ anon ] 00007f6e2227b000 108K r-x-- libpthread-2.28.so 00007f6e22296000 2044K ----- libpthread-2.28.so 00007f6e22495000 4K r---- libpthread-2.28.so 00007f6e22496000 4K rw--- libpthread-2.28.so 00007f6e22497000 16K rw--- [ anon ] 00007f6e2249b000 160K r-x-- ld-2.28.so 00007f6e224cb000 36K rw-s- [aio] (deleted) 00007f6e224d4000 36K rw-s- [aio] (deleted) 00007f6e224dd000 1916K rw--- [ anon ] 00007f6e226c3000 4K r---- ld-2.28.so 00007f6e226c4000 4K rw--- ld-2.28.so 00007f6e226c5000 4K rw--- [ anon ] 00007ffecdde0000 132K rw--- [ stack ] 00007ffecde8c000 12K r---- [ anon ] 00007ffecde8f000 8K r-x-- [ anon ] ffffffffff600000 4K r-x-- [ anon ] total 8935972K We have follow this documentation to try to understand where is consummed the memory: https://dev.mysql.com/doc/refman/8.0/en/memory-use.html Results: mysql> SELECT * FROM performance_schema.setup_instruments -> WHERE NAME LIKE '%memory%'; +--------------------------------------------------------------------------------+---------+-------+-------------------+------------+--------------------------------------------------------------------------------------------------+ | NAME | ENABLED | TIMED | PROPERTIES | VOLATILITY | DOCUMENTATION | +--------------------------------------------------------------------------------+---------+-------+-------------------+------------+--------------------------------------------------------------------------------------------------+ | memory/performance_schema/mutex_instances | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.mutex_instances | | memory/performance_schema/rwlock_instances | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.rwlock_instances | | memory/performance_schema/cond_instances | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.cond_instances | | memory/performance_schema/file_instances | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.file_instances | | memory/performance_schema/socket_instances | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.socket_instances | | memory/performance_schema/metadata_locks | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.metadata_locks | | memory/performance_schema/file_handle | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.file_handle | | memory/performance_schema/accounts | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.accounts | | memory/performance_schema/events_waits_summary_by_account_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_waits_summary_by_account_by_event_name | | memory/performance_schema/events_stages_summary_by_account_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_summary_by_account_by_event_name | | memory/performance_schema/events_statements_summary_by_account_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_account_by_event_name | | memory/performance_schema/events_transactions_summary_by_account_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_transactions_summary_by_account_by_event_name | | memory/performance_schema/events_errors_summary_by_account_by_error | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_errors_summary_by_account_by_error | | memory/performance_schema/memory_summary_by_account_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.memory_summary_by_account_by_event_name | | memory/performance_schema/events_stages_summary_global_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_summary_global_by_event_name | | memory/performance_schema/events_statements_summary_global_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_global_by_event_name | | memory/performance_schema/memory_summary_global_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.memory_summary_global_by_event_name | | memory/performance_schema/events_errors_summary_global_by_error | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_errors_summary_global_by_error | | memory/performance_schema/hosts | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.hosts | | memory/performance_schema/events_waits_summary_by_host_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_waits_summary_by_host_by_event_name | | memory/performance_schema/events_stages_summary_by_host_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_summary_by_host_by_event_name | | memory/performance_schema/events_statements_summary_by_host_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_host_by_event_name | | memory/performance_schema/events_transactions_summary_by_host_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_transactions_summary_by_host_by_event_name | | memory/performance_schema/events_errors_summary_by_host_by_error | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_errors_summary_by_host_by_error | | memory/performance_schema/memory_summary_by_host_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.memory_summary_by_host_by_event_name | | memory/performance_schema/threads | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.threads | | memory/performance_schema/events_waits_summary_by_thread_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_waits_summary_by_thread_by_event_name | | memory/performance_schema/events_stages_summary_by_thread_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_summary_by_thread_by_event_name | | memory/performance_schema/events_statements_summary_by_thread_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_thread_by_event_name | | memory/performance_schema/events_transactions_summary_by_thread_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_transactions_summary_by_thread_by_event_name | | memory/performance_schema/events_errors_summary_by_thread_by_error | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_errors_summary_by_thread_by_error | | memory/performance_schema/memory_summary_by_thread_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.memory_summary_by_thread_by_event_name | | memory/performance_schema/events_waits_history | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_waits_history | | memory/performance_schema/events_stages_history | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_history | | memory/performance_schema/events_statements_history | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_history | | memory/performance_schema/events_statements_history.digest_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_history, column digest_text | | memory/performance_schema/events_statements_history.sql_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_history, column sql_text | | memory/performance_schema/events_statements_current | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_current | | memory/performance_schema/events_statements_current.digest_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_current, column digest_text | | memory/performance_schema/events_statements_current.sql_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_current, column sql_text | | memory/performance_schema/events_transactions_history | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_transactions_history | | memory/performance_schema/session_connect_attrs | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.session_connect_attrs | | memory/performance_schema/users | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.users | | memory/performance_schema/events_waits_summary_by_user_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_waits_summary_by_user_by_event_name | | memory/performance_schema/events_stages_summary_by_user_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_summary_by_user_by_event_name | | memory/performance_schema/events_statements_summary_by_user_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_user_by_event_name | | memory/performance_schema/events_transactions_summary_by_user_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_transactions_summary_by_user_by_event_name | | memory/performance_schema/events_errors_summary_by_user_by_error | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_errors_summary_by_user_by_error | | memory/performance_schema/memory_summary_by_user_by_event_name | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.memory_summary_by_user_by_event_name | | memory/performance_schema/mutex_class | YES | NULL | global_statistics | 1 | Memory used for mutex instrument classes | | memory/performance_schema/rwlock_class | YES | NULL | global_statistics | 1 | Memory used for rwlock instrument classes | | memory/performance_schema/cond_class | YES | NULL | global_statistics | 1 | Memory used for cond instrument classes | | memory/performance_schema/thread_class | YES | NULL | global_statistics | 1 | Memory used for thread instrument classes | | memory/performance_schema/file_class | YES | NULL | global_statistics | 1 | Memory used for file instrument classes | | memory/performance_schema/socket_class | YES | NULL | global_statistics | 1 | Memory used for socket instrument classes | | memory/performance_schema/stage_class | YES | NULL | global_statistics | 1 | Memory used for stage instrument classes | | memory/performance_schema/statement_class | YES | NULL | global_statistics | 1 | Memory used for statement instrument classes | | memory/performance_schema/memory_class | YES | NULL | global_statistics | 1 | Memory used for memory instrument classes | | memory/performance_schema/setup_actors | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.setup_actors | | memory/performance_schema/setup_objects | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.setup_objects | | memory/performance_schema/events_statements_summary_by_digest | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_digest | | memory/performance_schema/events_statements_summary_by_digest.digest_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_digest, column digest_text | | memory/performance_schema/events_stages_history_long | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_stages_history_long | | memory/performance_schema/events_statements_history_long | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_history_long | | memory/performance_schema/events_statements_history_long.digest_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_history_long, column digest_text | | memory/performance_schema/events_statements_history_long.sql_text | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_history_long, column sql_text | | memory/performance_schema/events_transactions_history_long | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_transactions_history_long | | memory/performance_schema/events_waits_history_long | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_waits_history_long | | memory/performance_schema/table_handles | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.table_handles | | memory/performance_schema/table_shares | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.table_shares | | memory/performance_schema/table_io_waits_summary_by_index_usage | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.table_io_waits_summary_by_index_usage | | memory/performance_schema/table_lock_waits_summary_by_table | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.table_lock_waits_summary_by_table | | memory/performance_schema/events_statements_summary_by_program | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.events_statements_summary_by_program | | memory/performance_schema/prepared_statements_instances | YES | NULL | global_statistics | 1 | Memory used for table performance_schema.prepared_statements_instances | | memory/performance_schema/scalable_buffer | YES | NULL | global_statistics | 1 | Memory used for scalable buffers | | memory/sql/Locked_tables_list::m_locked_tables_root | YES | NULL | | 0 | NULL | | memory/sql/display_table_locks | YES | NULL | | 0 | NULL | | memory/sql/THD::transactions::mem_root | YES | NULL | | 0 | NULL | | memory/sql/Delegate::memroot | YES | NULL | | 0 | NULL | | memory/sql/sql_acl_mem | YES | NULL | global_statistics | 0 | NULL | | memory/sql/sql_acl_memex | YES | NULL | global_statistics | 0 | NULL | | memory/sql/acl_cache | YES | NULL | global_statistics | 0 | NULL | | memory/sql/acl_map_cache | YES | NULL | global_statistics | 0 | NULL | | memory/sql/thd::main_mem_root | YES | NULL | | 0 | NULL | | memory/sql/help | YES | NULL | | 0 | NULL | | memory/sql/TABLE_SHARE::mem_root | YES | NULL | global_statistics | 0 | NULL | | memory/sql/servers | YES | NULL | | 0 | NULL | | memory/sql/Prepared_statement_map | YES | NULL | | 0 | NULL | | memory/sql/Prepared_statement::main_mem_root | YES | NULL | | 0 | NULL | | memory/sql/THD::sp_cache | YES | NULL | | 0 | NULL | | memory/sql/sp_head::main_mem_root | YES | NULL | | 0 | NULL | | memory/sql/sp_head::execute_mem_root | YES | NULL | | 0 | NULL | | memory/sql/sp_head::call_mem_root | YES | NULL | | 0 | NULL | | memory/sql/table_mapping::m_mem_root | YES | NULL | | 0 | NULL | | memory/sql/QUICK_RANGE_SELECT::alloc | YES | NULL | | 0 | NULL | | memory/sql/QUICK_INDEX_MERGE_SELECT::alloc | YES | NULL | | 0 | NULL | | memory/sql/QUICK_ROR_INTERSECT_SELECT::alloc | YES | NULL | | 0 | NULL | | memory/sql/QUICK_ROR_UNION_SELECT::alloc | YES | NULL | | 0 | NULL | | memory/sql/QUICK_GROUP_MIN_MAX_SELECT::alloc | YES | NULL | | 0 | NULL | | memory/sql/test_quick_select | YES | NULL | | 0 | NULL | | memory/sql/prune_partitions::exec | YES | NULL | | 0 | NULL | | memory/sql/MYSQL_BIN_LOG::recover | YES | NULL | | 0 | NULL | | memory/sql/Blob_mem_storage::storage | YES | NULL | | 0 | NULL | | memory/sql/NAMED_ILINK::name | YES | NULL | | 0 | NULL | | memory/sql/String::value | YES | NULL | | 0 | NULL | | memory/sql/Sys_var_charptr::value | YES | NULL | | 0 | NULL | | memory/sql/Queue::queue_item | YES | NULL | | 0 | NULL | | memory/sql/THD::db | YES | NULL | | 0 | NULL | | memory/sql/user_var_entry | YES | NULL | | 0 | NULL | | memory/sql/Slave_job_group::group_relay_log_name | YES | NULL | | 0 | NULL | | memory/sql/binlog_cache_mngr | YES | NULL | | 0 | NULL | | memory/sql/Row_data_memory::memory | YES | NULL | | 0 | NULL | | memory/sql/Gtid_set::to_string | YES | NULL | | 0 | NULL | | memory/sql/Gtid_state::to_string | YES | NULL | | 0 | NULL | | memory/sql/Owned_gtids::to_string | YES | NULL | | 0 | NULL | | memory/sql/Log_event | YES | NULL | | 0 | NULL | | memory/sql/Filesort_info::merge | YES | NULL | | 0 | NULL | | memory/sql/Filesort_info::record_pointers | YES | NULL | | 0 | NULL | | memory/sql/Filesort_buffer::sort_keys | YES | NULL | | 0 | NULL | | memory/sql/handler::errmsgs | YES | NULL | global_statistics | 0 | NULL | | memory/sql/handlerton | YES | NULL | global_statistics | 0 | NULL | | memory/sql/XID | YES | NULL | | 0 | NULL | | memory/sql/host_cache::hostname | YES | NULL | global_statistics | 0 | NULL | | memory/sql/user_var_entry::value | YES | NULL | | 0 | NULL | | memory/sql/User_level_lock | YES | NULL | | 0 | NULL | | memory/sql/MYSQL_LOG::name | YES | NULL | global_statistics | 0 | NULL | | memory/sql/TC_LOG_MMAP::pages | YES | NULL | | 0 | NULL | | memory/sql/my_bitmap_map | YES | NULL | | 0 | NULL | | memory/sql/QUICK_RANGE_SELECT::mrr_buf_desc | YES | NULL | | 0 | NULL | | memory/sql/Event_queue_element_for_exec::names | YES | NULL | | 0 | NULL | | memory/sql/my_str_malloc | YES | NULL | | 0 | NULL | | memory/sql/MYSQL_BIN_LOG::basename | YES | NULL | global_statistics | 0 | NULL | | memory/sql/MYSQL_BIN_LOG::index | YES | NULL | global_statistics | 0 | NULL | | memory/sql/MYSQL_RELAY_LOG::basename | YES | NULL | global_statistics | 0 | NULL | | memory/sql/MYSQL_RELAY_LOG::index | YES | NULL | global_statistics | 0 | NULL | | memory/sql/rpl_filter memory | YES | NULL | | 0 | NULL | | memory/sql/errmsgs | YES | NULL | global_statistics | 0 | NULL | | memory/sql/Gis_read_stream::err_msg | YES | NULL | | 0 | NULL | | memory/sql/Geometry::ptr_and_wkb_data | YES | NULL | | 0 | NULL | | memory/sql/MYSQL_LOCK | YES | NULL | | 0 | NULL | | memory/sql/NET::buff | YES | NULL | | 0 | NULL | | memory/sql/NET::compress_packet | YES | NULL | | 0 | NULL | | memory/sql/Event_scheduler::scheduler_param | YES | NULL | global_statistics | 0 | NULL | | memory/sql/Gtid_set::Interval_chunk | YES | NULL | | 0 | NULL | | memory/sql/Owned_gtids::sidno_to_hash | YES | NULL | | 0 | NULL | | memory/sql/Sid_map::Node | YES | NULL | | 0 | NULL | | memory/sql/Gtid_state::group_commit_sidno_locks | YES | NULL | | 0 | NULL | | memory/sql/Mutex_cond_array::Mutex_cond | YES | NULL | | 0 | NULL | | memory/sql/TABLE_RULE_ENT | YES | NULL | | 0 | NULL | | memory/sql/Rpl_info_table | YES | NULL | | 0 | NULL | | memory/sql/Rpl_info_file::buffer | YES | NULL | | 0 | NULL | | memory/sql/db_worker_hash_entry | YES | NULL | | 0 | NULL | | memory/sql/rpl_slave::check_temp_dir | YES | NULL | | 0 | NULL | | memory/sql/SLAVE_INFO | YES | NULL | | 0 | NULL | | memory/sql/binlog_pos | YES | NULL | | 0 | NULL | | memory/sql/HASH_ROW_ENTRY | YES | NULL | | 0 | NULL | | memory/sql/binlog_statement_buffer | YES | NULL | | 0 | NULL | | memory/sql/partition_syntax_buffer | YES | NULL | | 0 | NULL | | memory/sql/READ_INFO | YES | NULL | | 0 | NULL | | memory/sql/JOIN_CACHE | YES | NULL | | 0 | NULL | | memory/sql/TABLE::sort_io_cache | YES | NULL | | 0 | NULL | | memory/sql/dd::column_statistics | YES | NULL | | 0 | NULL | | memory/sql/dd::default_values | YES | NULL | | 0 | NULL | | memory/sql/dd::import | YES | NULL | | 0 | NULL | | memory/sql/Unique::sort_buffer | YES | NULL | | 0 | NULL | | memory/sql/Unique::merge_buffer | YES | NULL | | 0 | NULL | | memory/sql/TABLE | YES | NULL | global_statistics | 0 | NULL | | memory/sql/LOG_name | YES | NULL | | 0 | NULL | | memory/sql/dd::String_type | YES | NULL | global_statistics | 0 | NULL | | memory/sql/ST_SCHEMA_TABLE | YES | NULL | | 0 | NULL | | memory/sql/PROFILE | YES | NULL | | 0 | NULL | | memory/sql/global_system_variables | YES | NULL | global_statistics | 0 | NULL | | memory/sql/THD::variables | YES | NULL | | 0 | NULL | | memory/sql/Shared_memory_name | YES | NULL | | 0 | NULL | | memory/sql/bison_stack | YES | NULL | | 0 | NULL | | memory/sql/THD::handler_tables_hash | YES | NULL | | 0 | NULL | | memory/sql/hash_index_key_buffer | YES | NULL | | 0 | NULL | | memory/sql/user_conn | YES | NULL | | 0 | NULL | | memory/sql/LOG_POS_COORD | YES | NULL | | 0 | NULL | | memory/sql/MPVIO_EXT::auth_info | YES | NULL | | 0 | NULL | | memory/sql/opt_bin_logname | YES | NULL | global_statistics | 0 | NULL | | memory/sql/READ_RECORD_cache | YES | NULL | | 0 | NULL | | memory/sql/Recovered_xa_transactions | YES | NULL | | 0 | NULL | | memory/sql/Quick_ranges | YES | NULL | | 0 | NULL | | memory/sql/File_query_log::name | YES | NULL | global_statistics | 0 | NULL | | memory/sql/thd_timer | YES | NULL | | 0 | NULL | | memory/sql/THD::Session_tracker | YES | NULL | | 0 | NULL | | memory/sql/THD::Session_sysvar_resource_manager | YES | NULL | | 0 | NULL | | memory/sql/show_slave_status_io_gtid_set | YES | NULL | | 0 | NULL | | memory/sql/write_set_extraction | YES | NULL | | 0 | NULL | | memory/sql/JSON | YES | NULL | | 0 | NULL | | memory/sql/log_error_loaded_services | YES | NULL | | 0 | NULL | | memory/sql/log_error_stack | YES | NULL | global_statistics | 0 | NULL | | memory/sql/histograms | YES | NULL | | 0 | NULL | | memory/sql/hash_join | YES | NULL | | 0 | NULL | | memory/client/mysql_options | YES | NULL | | 0 | NULL | | memory/client/MYSQL_DATA | YES | NULL | | 0 | NULL | | memory/client/MYSQL | YES | NULL | | 0 | NULL | | memory/client/MYSQL_RES | YES | NULL | | 0 | NULL | | memory/client/MYSQL_ROW | YES | NULL | | 0 | NULL | | memory/client/MYSQL_STATE_CHANGE_INFO | YES | NULL | | 0 | NULL | | memory/client/MYSQL_HANDSHAKE | YES | NULL | | 0 | NULL | | memory/vio/ssl_fd | YES | NULL | | 0 | NULL | | memory/vio/vio | YES | NULL | | 0 | NULL | | memory/vio/read_buffer | YES | NULL | | 0 | NULL | | memory/mysys/max_alloca | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/charset_file | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/charset_loader | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/lf_node | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/lf_dynarray | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/lf_slist | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/LIST | YES | NULL | | 0 | NULL | | memory/mysys/IO_CACHE | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/KEY_CACHE | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/SAFE_HASH_ENTRY | YES | NULL | | 0 | NULL | | memory/mysys/MY_TMPDIR::full_list | YES | NULL | | 0 | NULL | | memory/mysys/MY_BITMAP::bitmap | YES | NULL | | 0 | NULL | | memory/mysys/my_compress_alloc | YES | NULL | | 0 | NULL | | memory/mysys/my_err_head | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/my_file_info | YES | NULL | global_statistics | 0 | NULL | | memory/mysys/MY_DIR | YES | NULL | | 0 | NULL | | memory/mysys/DYNAMIC_STRING | YES | NULL | | 0 | NULL | | memory/mysys/TREE | YES | NULL | | 0 | NULL | | memory/sql/Event_basic::mem_root | YES | NULL | global_statistics | 0 | NULL | | memory/sql/root | YES | NULL | global_statistics | 0 | NULL | | memory/sql/load_env_plugins | YES | NULL | global_statistics | 0 | NULL | | memory/sql/MDL_context::acquire_locks | YES | NULL | | 0 | NULL | | memory/sql/Partition_share | YES | NULL | | 0 | NULL | | memory/sql/partition_sort_buffer | YES | NULL | | 0 | NULL | | memory/sql/Partition_admin | YES | NULL | | 0 | NULL | | memory/sql/MDL_context_backup_manager | YES | NULL | | 0 | NULL | | memory/sql/udf_mem | YES | NULL | global_statistics | 0 | NULL | | memory/mysqld_openssl/openssl_malloc | YES | NULL | | 0 | All memory used by openSSL | | memory/sql/plugin_mem_root | YES | NULL | global_statistics | 0 | NULL | | memory/sql/plugin_init_tmp | YES | NULL | | 0 | NULL | | memory/sql/plugin_int_mem_root | YES | NULL | | 0 | NULL | | memory/sql/mysql_plugin_dl | YES | NULL | global_statistics | 0 | NULL | | memory/sql/mysql_plugin | YES | NULL | global_statistics | 0 | NULL | | memory/sql/plugin_bookmark | YES | NULL | global_statistics | 0 | NULL | | memory/csv/TINA_SHARE | YES | NULL | global_statistics | 0 | NULL | | memory/csv/blobroot | YES | NULL | | 0 | NULL | | memory/csv/tina_set | YES | NULL | | 0 | NULL | | memory/csv/row | YES | NULL | | 0 | NULL | | memory/csv/Transparent_file | YES | NULL | | 0 | NULL | | memory/innodb/adaptive hash index | YES | NULL | | 0 | NULL | | memory/innodb/log and page archiver | YES | NULL | | 0 | NULL | | memory/innodb/buf_buf_pool | YES | NULL | global_statistics | 0 | NULL | | memory/innodb/buf_stat_per_index_t | YES | NULL | | 0 | NULL | | memory/innodb/clone | YES | NULL | | 0 | NULL | | memory/innodb/dict_stats_bg_recalc_pool_t | YES | NULL | | 0 | NULL | | memory/innodb/dict_stats_index_map_t | YES | NULL | | 0 | NULL | | memory/innodb/dict_stats_n_diff_on_level | YES | NULL | | 0 | NULL | | memory/innodb/other | YES | NULL | | 0 | NULL | | memory/innodb/partitioning | YES | NULL | | 0 | NULL | | memory/innodb/row_log_buf | YES | NULL | | 0 | NULL | | memory/innodb/row_merge_sort | YES | NULL | | 0 | NULL | | memory/innodb/std | YES | NULL | | 0 | NULL | | memory/innodb/trx_sys_t::rw_trx_ids | YES | NULL | | 0 | NULL | | memory/innodb/undo::Tablespaces | YES | NULL | | 0 | NULL | | memory/innodb/ut_lock_free_hash_t | YES | NULL | | 0 | NULL | | memory/innodb/api0api | YES | NULL | | 0 | NULL | | memory/innodb/api0misc | YES | NULL | | 0 | NULL | | memory/innodb/btr0btr | YES | NULL | | 0 | NULL | | memory/innodb/btr0bulk | YES | NULL | | 0 | NULL | | memory/innodb/btr0cur | YES | NULL | | 0 | NULL | | memory/innodb/btr0pcur | YES | NULL | | 0 | NULL | | memory/innodb/btr0sea | YES | NULL | | 0 | NULL | | memory/innodb/btr0types | YES | NULL | | 0 | NULL | | memory/innodb/buf | YES | NULL | | 0 | NULL | | memory/innodb/buf0buddy | YES | NULL | | 0 | NULL | | memory/innodb/buf0buf | YES | NULL | | 0 | NULL | | memory/innodb/buf0checksum | YES | NULL | | 0 | NULL | | memory/innodb/buf0dblwr | YES | NULL | | 0 | NULL | | memory/innodb/buf0dump | YES | NULL | | 0 | NULL | | memory/innodb/buf0flu | YES | NULL | | 0 | NULL | | memory/innodb/buf0lru | YES | NULL | | 0 | NULL | | memory/innodb/buf0rea | YES | NULL | | 0 | NULL | | memory/innodb/buf0stats | YES | NULL | | 0 | NULL | | memory/innodb/buf0types | YES | NULL | | 0 | NULL | | memory/innodb/checksum | YES | NULL | | 0 | NULL | | memory/innodb/crc32 | YES | NULL | | 0 | NULL | | memory/innodb/create | YES | NULL | | 0 | NULL | | memory/innodb/data0data | YES | NULL | | 0 | NULL | | memory/innodb/data0type | YES | NULL | | 0 | NULL | | memory/innodb/data0types | YES | NULL | | 0 | NULL | | memory/innodb/db0err | YES | NULL | | 0 | NULL | | memory/innodb/dict | YES | NULL | | 0 | NULL | | memory/innodb/dict0boot | YES | NULL | | 0 | NULL | | memory/innodb/dict0crea | YES | NULL | | 0 | NULL | | memory/innodb/dict0dd | YES | NULL | | 0 | NULL | | memory/innodb/dict0dict | YES | NULL | | 0 | NULL | | memory/innodb/dict0load | YES | NULL | | 0 | NULL | | memory/innodb/dict0mem | YES | NULL | | 0 | NULL | | memory/innodb/dict0priv | YES | NULL | | 0 | NULL | | memory/innodb/dict0sdi | YES | NULL | | 0 | NULL | | memory/innodb/dict0stats | YES | NULL | | 0 | NULL | | memory/innodb/dict0stats_bg | YES | NULL | | 0 | NULL | | memory/innodb/dict0types | YES | NULL | | 0 | NULL | | memory/innodb/dyn0buf | YES | NULL | | 0 | NULL | | memory/innodb/dyn0types | YES | NULL | | 0 | NULL | | memory/innodb/eval0eval | YES | NULL | | 0 | NULL | | memory/innodb/eval0proc | YES | NULL | | 0 | NULL | | memory/innodb/fil0fil | YES | NULL | | 0 | NULL | | memory/innodb/fil0types | YES | NULL | | 0 | NULL | | memory/innodb/file | YES | NULL | | 0 | NULL | | memory/innodb/fsp0file | YES | NULL | | 0 | NULL | | memory/innodb/fsp0fsp | YES | NULL | | 0 | NULL | | memory/innodb/fsp0space | YES | NULL | | 0 | NULL | | memory/innodb/fsp0sysspace | YES | NULL | | 0 | NULL | | memory/innodb/fsp0types | YES | NULL | | 0 | NULL | | memory/innodb/fts0ast | YES | NULL | | 0 | NULL | | memory/innodb/fts0blex | YES | NULL | | 0 | NULL | | memory/innodb/fts0config | YES | NULL | | 0 | NULL | | memory/innodb/fts0fts | YES | NULL | | 0 | NULL | | memory/innodb/fts0opt | YES | NULL | | 0 | NULL | | memory/innodb/fts0pars | YES | NULL | | 0 | NULL | | memory/innodb/fts0plugin | YES | NULL | | 0 | NULL | | memory/innodb/fts0priv | YES | NULL | | 0 | NULL | | memory/innodb/fts0que | YES | NULL | | 0 | NULL | | memory/innodb/fts0sql | YES | NULL | | 0 | NULL | | memory/innodb/fts0tlex | YES | NULL | | 0 | NULL | | memory/innodb/fts0tokenize | YES | NULL | | 0 | NULL | | memory/innodb/fts0types | YES | NULL | | 0 | NULL | | memory/innodb/fts0vlc | YES | NULL | | 0 | NULL | | memory/innodb/fut0fut | YES | NULL | | 0 | NULL | | memory/innodb/fut0lst | YES | NULL | | 0 | NULL | | memory/innodb/gis0geo | YES | NULL | | 0 | NULL | | memory/innodb/gis0rtree | YES | NULL | | 0 | NULL | | memory/innodb/gis0sea | YES | NULL | | 0 | NULL | | memory/innodb/gis0type | YES | NULL | | 0 | NULL | | memory/innodb/ha0ha | YES | NULL | | 0 | NULL | | memory/innodb/ha0storage | YES | NULL | | 0 | NULL | | memory/innodb/ha_innodb | YES | NULL | | 0 | NULL | | memory/innodb/ha_innopart | YES | NULL | | 0 | NULL | | memory/innodb/ha_prototypes | YES | NULL | | 0 | NULL | | memory/innodb/handler0alter | YES | NULL | | 0 | NULL | | memory/innodb/hash0hash | YES | NULL | | 0 | NULL | | memory/innodb/i_s | YES | NULL | | 0 | NULL | | memory/innodb/ib0mutex | YES | NULL | | 0 | NULL | | memory/innodb/ibuf0ibuf | YES | NULL | | 0 | NULL | | memory/innodb/ibuf0types | YES | NULL | | 0 | NULL | | memory/innodb/lexyy | YES | NULL | | 0 | NULL | | memory/innodb/lob0lob | YES | NULL | | 0 | NULL | | memory/innodb/lock0iter | YES | NULL | | 0 | NULL | | memory/innodb/lock0lock | YES | NULL | | 0 | NULL | | memory/innodb/lock0prdt | YES | NULL | | 0 | NULL | | memory/innodb/lock0priv | YES | NULL | | 0 | NULL | | memory/innodb/lock0types | YES | NULL | | 0 | NULL | | memory/innodb/lock0wait | YES | NULL | | 0 | NULL | | memory/innodb/log0log | YES | NULL | | 0 | NULL | | memory/innodb/log0recv | YES | NULL | | 0 | NULL | | memory/innodb/log0write | YES | NULL | | 0 | NULL | | memory/innodb/mach0data | YES | NULL | | 0 | NULL | | memory/innodb/mem | YES | NULL | | 0 | NULL | | memory/innodb/mem0mem | YES | NULL | | 0 | NULL | | memory/innodb/memory | YES | NULL | | 0 | NULL | | memory/innodb/mtr0log | YES | NULL | | 0 | NULL | | memory/innodb/mtr0mtr | YES | NULL | | 0 | NULL | | memory/innodb/mtr0types | YES | NULL | | 0 | NULL | | memory/innodb/os0atomic | YES | NULL | | 0 | NULL | | memory/innodb/os0event | YES | NULL | | 0 | NULL | | memory/innodb/os0file | YES | NULL | | 0 | NULL | | memory/innodb/os0numa | YES | NULL | | 0 | NULL | | memory/innodb/os0once | YES | NULL | | 0 | NULL | | memory/innodb/os0proc | YES | NULL | | 0 | NULL | | memory/innodb/os0thread | YES | NULL | | 0 | NULL | | memory/innodb/page | YES | NULL | | 0 | NULL | | memory/innodb/page0cur | YES | NULL | | 0 | NULL | | memory/innodb/page0page | YES | NULL | | 0 | NULL | | memory/innodb/page0size | YES | NULL | | 0 | NULL | | memory/innodb/page0types | YES | NULL | | 0 | NULL | | memory/innodb/page0zip | YES | NULL | | 0 | NULL | | memory/innodb/pars0grm | YES | NULL | | 0 | NULL | | memory/innodb/pars0lex | YES | NULL | | 0 | NULL | | memory/innodb/pars0opt | YES | NULL | | 0 | NULL | | memory/innodb/pars0pars | YES | NULL | | 0 | NULL | | memory/innodb/pars0sym | YES | NULL | | 0 | NULL | | memory/innodb/pars0types | YES | NULL | | 0 | NULL | | memory/innodb/que0que | YES | NULL | | 0 | NULL | | memory/innodb/que0types | YES | NULL | | 0 | NULL | | memory/innodb/read0read | YES | NULL | | 0 | NULL | | memory/innodb/read0types | YES | NULL | | 0 | NULL | | memory/innodb/rec | YES | NULL | | 0 | NULL | | memory/innodb/rem0cmp | YES | NULL | | 0 | NULL | | memory/innodb/rem0rec | YES | NULL | | 0 | NULL | | memory/innodb/rem0types | YES | NULL | | 0 | NULL | | memory/innodb/row0ext | YES | NULL | | 0 | NULL | | memory/innodb/row0ftsort | YES | NULL | | 0 | NULL | | memory/innodb/row0import | YES | NULL | | 0 | NULL | | memory/innodb/row0ins | YES | NULL | | 0 | NULL | | memory/innodb/row0log | YES | NULL | | 0 | NULL | | memory/innodb/row0merge | YES | NULL | | 0 | NULL | | memory/innodb/row0mysql | YES | NULL | | 0 | NULL | | memory/innodb/row0purge | YES | NULL | | 0 | NULL | | memory/innodb/row0quiesce | YES | NULL | | 0 | NULL | | memory/innodb/row0row | YES | NULL | | 0 | NULL | | memory/innodb/row0sel | YES | NULL | | 0 | NULL | | memory/innodb/row0types | YES | NULL | | 0 | NULL | | memory/innodb/row0uins | YES | NULL | | 0 | NULL | | memory/innodb/row0umod | YES | NULL | | 0 | NULL | | memory/innodb/row0undo | YES | NULL | | 0 | NULL | | memory/innodb/row0upd | YES | NULL | | 0 | NULL | | memory/innodb/row0vers | YES | NULL | | 0 | NULL | | memory/innodb/sess0sess | YES | NULL | | 0 | NULL | | memory/innodb/srv0conc | YES | NULL | | 0 | NULL | | memory/innodb/srv0mon | YES | NULL | | 0 | NULL | | memory/innodb/srv0srv | YES | NULL | | 0 | NULL | | memory/innodb/srv0start | YES | NULL | | 0 | NULL | | memory/innodb/srv0tmp | YES | NULL | | 0 | NULL | | memory/innodb/sync0arr | YES | NULL | | 0 | NULL | | memory/innodb/sync0debug | YES | NULL | | 0 | NULL | | memory/innodb/sync0policy | YES | NULL | | 0 | NULL | | memory/innodb/sync0sharded_rw | YES | NULL | | 0 | NULL | | memory/innodb/sync0rw | YES | NULL | | 0 | NULL | | memory/innodb/sync0sync | YES | NULL | | 0 | NULL | | memory/innodb/sync0types | YES | NULL | | 0 | NULL | | memory/innodb/trx0i_s | YES | NULL | | 0 | NULL | | memory/innodb/trx0purge | YES | NULL | | 0 | NULL | | memory/innodb/trx0rec | YES | NULL | | 0 | NULL | | memory/innodb/trx0roll | YES | NULL | | 0 | NULL | | memory/innodb/trx0rseg | YES | NULL | | 0 | NULL | | memory/innodb/trx0sys | YES | NULL | | 0 | NULL | | memory/innodb/trx0trx | YES | NULL | | 0 | NULL | | memory/innodb/trx0types | YES | NULL | | 0 | NULL | | memory/innodb/trx0undo | YES | NULL | | 0 | NULL | | memory/innodb/trx0xa | YES | NULL | | 0 | NULL | | memory/innodb/usr0sess | YES | NULL | | 0 | NULL | | memory/innodb/usr0types | YES | NULL | | 0 | NULL | | memory/innodb/ut | YES | NULL | | 0 | NULL | | memory/innodb/ut0byte | YES | NULL | | 0 | NULL | | memory/innodb/ut0counter | YES | NULL | | 0 | NULL | | memory/innodb/ut0crc32 | YES | NULL | | 0 | NULL | | memory/innodb/ut0dbg | YES | NULL | | 0 | NULL | | memory/innodb/ut0link_buf | YES | NULL | | 0 | NULL | | memory/innodb/ut0list | YES | NULL | | 0 | NULL | | memory/innodb/ut0lock_free_hash | YES | NULL | | 0 | NULL | | memory/innodb/ut0lst | YES | NULL | | 0 | NULL | | memory/innodb/ut0mem | YES | NULL | | 0 | NULL | | memory/innodb/ut0mutex | YES | NULL | | 0 | NULL | | memory/innodb/ut0new | YES | NULL | | 0 | NULL | | memory/innodb/ut0pool | YES | NULL | | 0 | NULL | | memory/innodb/ut0rbt | YES | NULL | | 0 | NULL | | memory/innodb/ut0rnd | YES | NULL | | 0 | NULL | | memory/innodb/ut0sort | YES | NULL | | 0 | NULL | | memory/innodb/ut0stage | YES | NULL | | 0 | NULL | | memory/innodb/ut0ut | YES | NULL | | 0 | NULL | | memory/innodb/ut0vec | YES | NULL | | 0 | NULL | | memory/innodb/ut0wqueue | YES | NULL | | 0 | NULL | | memory/innodb/zipdecompress | YES | NULL | | 0 | NULL | | memory/myisam/MYISAM_SHARE | YES | NULL | global_statistics | 0 | NULL | | memory/myisam/MI_INFO | YES | NULL | | 0 | NULL | | memory/myisam/MI_INFO::ft1_to_ft2 | YES | NULL | | 0 | NULL | | memory/myisam/MI_INFO::bulk_insert | YES | NULL | | 0 | NULL | | memory/myisam/record_buffer | YES | NULL | | 0 | NULL | | memory/myisam/FTB | YES | NULL | | 0 | NULL | | memory/myisam/FT_INFO | YES | NULL | | 0 | NULL | | memory/myisam/FTPARSER_PARAM | YES | NULL | | 0 | NULL | | memory/myisam/ft_memroot | YES | NULL | | 0 | NULL | | memory/myisam/ft_stopwords | YES | NULL | | 0 | NULL | | memory/myisam/MI_SORT_PARAM | YES | NULL | | 0 | NULL | | memory/myisam/MI_SORT_PARAM::wordroot | YES | NULL | | 0 | NULL | | memory/myisam/SORT_FT_BUF | YES | NULL | | 0 | NULL | | memory/myisam/SORT_KEY_BLOCKS | YES | NULL | | 0 | NULL | | memory/myisam/filecopy | YES | NULL | | 0 | NULL | | memory/myisam/SORT_INFO::buffer | YES | NULL | | 0 | NULL | | memory/myisam/MI_DECODE_TREE | YES | NULL | | 0 | NULL | | memory/myisam/MYISAM_SHARE::decode_tables | YES | NULL | | 0 | NULL | | memory/myisam/preload_buffer | YES | NULL | | 0 | NULL | | memory/myisam/stPageList::pages | YES | NULL | | 0 | NULL | | memory/myisam/keycache_thread_var | YES | NULL | | 0 | NULL | | memory/myisam/QUEUE | YES | NULL | | 0 | NULL | | memory/memory/HP_SHARE | YES | NULL | | 0 | NULL | | memory/memory/HP_INFO | YES | NULL | | 0 | NULL | | memory/memory/HP_PTRS | YES | NULL | | 0 | NULL | | memory/memory/HP_KEYDEF | YES | NULL | | 0 | NULL | | memory/myisammrg/MYRG_INFO | YES | NULL | | 0 | NULL | | memory/myisammrg/children | YES | NULL | | 0 | NULL | | memory/temptable/physical_disk | YES | NULL | | 0 | NULL | | memory/temptable/physical_ram | YES | NULL | global_statistics | 0 | NULL | | memory/archive/FRM | YES | NULL | | 0 | NULL | | memory/archive/record_buffer | YES | NULL | | 0 | NULL | | memory/blackhole/blackhole_share | YES | NULL | global_statistics | 0 | NULL | | memory/component_sys_vars/component_system_variables | YES | NULL | | 0 | NULL | | memory/sql/tz_storage | YES | NULL | global_statistics | 0 | NULL | | memory/sql/servers_cache | YES | NULL | global_statistics | 0 | NULL | | memory/sql/Relay_log_info::mts_coor | YES | NULL | | 0 | NULL | +--------------------------------------------------------------------------------+---------+-------+-------------------+------------+--------------------------------------------------------------------------------------------------+ 486 rows in set (0.01 sec) mysql> SELECT * FROM performance_schema.memory_summary_global_by_event_name -> WHERE EVENT_NAME LIKE 'memory/innodb/buf_buf_pool'\G *************************** 1. row *************************** EVENT_NAME: memory/innodb/buf_buf_pool COUNT_ALLOC: 16 COUNT_FREE: 0 SUM_NUMBER_OF_BYTES_ALLOC: 2197815296 SUM_NUMBER_OF_BYTES_FREE: 0 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 16 HIGH_COUNT_USED: 16 LOW_NUMBER_OF_BYTES_USED: 0 CURRENT_NUMBER_OF_BYTES_USED: 2197815296 HIGH_NUMBER_OF_BYTES_USED: 2197815296 1 row in set (0.00 sec) mysql> SELECT * FROM sys.memory_global_by_current_bytes -> WHERE event_name LIKE 'memory/innodb/buf_buf_pool'\G *************************** 1. row *************************** event_name: memory/innodb/buf_buf_pool current_count: 16 current_alloc: 2.05 GiB current_avg_alloc: 131.00 MiB high_count: 16 high_alloc: 2.05 GiB high_avg_alloc: 131.00 MiB 1 row in set (0.00 sec) mysql> SELECT SUBSTRING_INDEX(event_name,'/',2) AS -> code_area, FORMAT_BYTES(SUM(current_alloc)) -> AS current_alloc -> FROM sys.x$memory_global_by_current_bytes -> GROUP BY SUBSTRING_INDEX(event_name,'/',2) -> ORDER BY SUM(current_alloc) DESC; +---------------------------+---------------+ | code_area | current_alloc | +---------------------------+---------------+ | memory/innodb | 2.20 GiB | | memory/performance_schema | 218.42 MiB | | memory/sql | 22.89 MiB | | memory/mysys | 17.14 MiB | | memory/temptable | 1.00 MiB | | memory/mysqld_openssl | 338.27 KiB | | memory/csv | 9.84 KiB | | memory/vio | 1.05 KiB | | memory/myisam | 696 bytes | | memory/blackhole | 88 bytes | +---------------------------+---------------+ 10 rows in set (0.00 sec) For us, all these values are normal and we don't understand where is consummed the memory... As explained, no activity on the server: mysql> show processlist; +-----+---------------------+------------------------------------------+------+-------------+---------+---------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+---------------------+------------------------------------------+------+-------------+---------+---------------------------------------------------------------+------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1034206 | Waiting on empty queue | NULL | | 8 | replication | slave.domain.com:42510 | NULL | Binlog Dump | 1034189 | Master has sent all binlog to slave; waiting for more updates | NULL | | 583 | root | localhost | NULL | Query | 0 | starting | show processlist | +-----+---------------------+------------------------------------------+------+-------------+---------+---------------------------------------------------------------+------------------+ 3 rows in set (0.00 sec) The server configuration: [mysqld] default-authentication-plugin = mysql_native_password character-set-server = utf8mb4 user = mysql port = 3306 socket = /mnt/mysql/run/mysqld.sock pid-file = /mnt/mysql/run/mysqld.pid log-error = /mnt/mysql/log/mysqld.err basedir = /usr datadir = /mnt/mysql/data tmpdir = /mnt/mysql/tmp skip-external-locking key_buffer_size = 16M max_allowed_packet = 100M table_open_cache = 1000 table_definition_cache = 1000 sort_buffer_size = 20M net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M join_buffer_size = 256K lc_messages_dir = /usr/share/mysql lc_messages = en_GB sql-mode = "traditional" secure_file_priv = /mnt/temporaryDataExported/ explicit_defaults_for_timestamp = 1 # 'max_heap_table_size' and 'tmp_table_size' values must be identical max_heap_table_size = 2G tmp_table_size = 2G # back_log = 50 + (max_connections / 5) back_log = 120 max_connections = 350 max_connect_errors = 100 slow_query_log = 1 slow_query_log_file = /mnt/mysql/log/mysql-slow.log long_query_time = 60 # log-queries-not-using-indexes log-slow-admin-statements thread_cache_size = 2000 bind-address = 10.10.1.10 # read_only = 1 server-id = 617 sync_binlog = 1 log-bin = mywebsite log-bin-index = mywebsiteindex relay-log = mywebsiterelay relay-log-index = mywebsiterelayindex binlog_format = MIXED binlog_checksum = CRC32 binlog-row-event-max-size = 8192 binlog_expire_logs_seconds = 432000 sync_master_info = 10000 master_info_repository = TABLE sync_relay_log = 10000 sync_relay_log_info = 10000 relay_log_info_repository = TABLE gtid_mode = OFF flush_time = 0 innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:50M:autoextend:max:50G # we keep this at around 25% of of innodb_buffer_pool_size. sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) innodb_log_file_size = 500M # this is the default, increase it if you have very large transactions going on innodb_log_buffer_size = 8M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_io_capacity = 200 innodb_autoextend_increment = 64 innodb_buffer_pool_instances = 8 innodb_checksum_algorithm = CRC32 innodb_concurrency_tickets = 5000 innodb_file_per_table = 1 innodb_old_blocks_time = 1000 innodb_old_blocks_pct = 37 ##### innodb_open_files = -1 innodb_stats_on_metadata = 0 innodb_read_io_threads = 12 innodb_write_io_threads = 12 mysqlx = 0 mysqlx_socket = /mnt/mysql/run/mysqlx.sock [isamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M #[myisamchk] #key_buffer_size = 20M #sort_buffer_size = 20M #read_buffer_size = 2M #write_buffer_size = 2M