The loadtest is performed by update items on node1 with 4 rounds of tests by calling Mem_Test_main(100000); Node1 after 1st round (Mem up to 45.6%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | root | memory/sql/sp_head::execute_mem_root | 20000204 | 163041663008 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 20000030 | 81120121680 | | NULL | memory/innodb/mem0mem | 357785 | 2903711480 | | root | memory/sql/String::value | 30000496 | 2239333968 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | root | memory/innodb/std | 10000205 | 800007376 | | NULL | memory/innodb/rem0rec | 10000022 | 400001372 | | root | memory/innodb/btr0pcur | 10000000 | 400000000 | | root | memory/memory/HP_PTRS | 201 | 176350992 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | root | memory/sql/thd::main_mem_root | 201 | 3918360 | | NULL | memory/sql/thd::main_mem_root | 456 | 3231112 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | root | memory/innodb/mem0mem | 220 | 788034 | | root | memory/sql/THD::variables | 630 | 735840 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | root | memory/memory/HP_INFO | 176 | 207480 | | root | memory/sql/sp_head::main_mem_root | 15 | 204184 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.003 sec) Node2 after 1st round (Mem up to 55.1%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | NULL | memory/innodb/mem0mem | 359535 | 2906204066 | | NULL | memory/sql/thd::main_mem_root | 9352 | 1694834920 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | NULL | memory/innodb/std | 10000374 | 800055904 | | NULL | memory/innodb/rem0rec | 10000019 | 400001156 | | NULL | memory/innodb/btr0pcur | 10000004 | 400000260 | | root | memory/memory/HP_PTRS | 280 | 239528520 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | root | memory/sql/thd::main_mem_root | 263 | 6231192 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | root | memory/sql/THD::variables | 862 | 1006816 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | NULL | memory/innodb/trx0trx | 1490 | 417032 | | NULL | memory/sql/table_mapping::m_mem_root | 192 | 329216 | | root | memory/memory/HP_INFO | 242 | 297640 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 60 | 243360 | | root | memory/sql/user_var_entry | 862 | 220416 | | root | memory/memory/HP_SHARE | 484 | 207256 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.003 sec) Node1 after 2nd round (Mem up to 50.5%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | root | memory/sql/sp_head::execute_mem_root | 40000408 | 326083326016 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 40000060 | 162240243360 | | NULL | memory/innodb/mem0mem | 715185 | 5806767480 | | root | memory/sql/String::value | 60000848 | 4478580128 | | root | memory/innodb/std | 20000405 | 1600013776 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | NULL | memory/innodb/rem0rec | 20000022 | 800001372 | | root | memory/innodb/btr0pcur | 20000000 | 800000000 | | root | memory/memory/HP_PTRS | 350 | 305437368 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | root | memory/sql/thd::main_mem_root | 330 | 7025784 | | NULL | memory/sql/thd::main_mem_root | 456 | 3231112 | | root | memory/innodb/mem0mem | 420 | 1511234 | | root | memory/sql/THD::variables | 1086 | 1268448 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | root | memory/memory/HP_INFO | 304 | 362664 | | root | memory/sql/user_var_entry | 1086 | 277376 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.002 sec) Node2 after 2nd round (Mem up to 56.1%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | NULL | memory/innodb/mem0mem | 717176 | 5809996226 | | NULL | memory/sql/thd::main_mem_root | 18252 | 3386438920 | | NULL | memory/innodb/std | 20000617 | 1600064208 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | NULL | memory/innodb/rem0rec | 20000020 | 800001196 | | NULL | memory/innodb/btr0pcur | 20000004 | 800000260 | | root | memory/memory/HP_PTRS | 354 | 307788168 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | root | memory/sql/thd::main_mem_root | 313 | 7048392 | | root | memory/sql/THD::variables | 1124 | 1312832 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | NULL | memory/sql/table_mapping::m_mem_root | 232 | 494016 | | NULL | memory/innodb/trx0trx | 1490 | 417032 | | root | memory/memory/HP_INFO | 312 | 373400 | | root | memory/sql/user_var_entry | 1124 | 287488 | | NULL | memory/sql/THD::variables | 237 | 275776 | | root | memory/memory/HP_SHARE | 624 | 259816 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.003 sec) Node1 after 3rd round (Mem up to 51.6%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | root | memory/sql/sp_head::execute_mem_root | 60000612 | 489124989024 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 60000120 | 243360486720 | | NULL | memory/innodb/mem0mem | 1072585 | 8709823480 | | root | memory/sql/String::value | 90001468 | 6717833600 | | root | memory/innodb/std | 30000605 | 2400020176 | | NULL | memory/innodb/rem0rec | 30000022 | 1200001372 | | root | memory/innodb/btr0pcur | 30000000 | 1200000000 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | root | memory/memory/HP_PTRS | 586 | 504953288 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | root | memory/sql/thd::main_mem_root | 535 | 12569256 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | NULL | memory/sql/thd::main_mem_root | 456 | 3231112 | | root | memory/innodb/mem0mem | 621 | 2234666 | | root | memory/sql/THD::variables | 1816 | 2121088 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | root | memory/memory/HP_INFO | 501 | 611000 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | root | memory/sql/user_var_entry | 1816 | 464256 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.003 sec) Node2 after 3rd round (Mem up to 54.8%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | NULL | memory/innodb/mem0mem | 1074800 | 8713780994 | | NULL | memory/sql/thd::main_mem_root | 27152 | 5078042920 | | NULL | memory/innodb/std | 30000841 | 2400071376 | | NULL | memory/innodb/rem0rec | 30000020 | 1200001196 | | NULL | memory/innodb/btr0pcur | 30000004 | 1200000260 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | root | memory/memory/HP_PTRS | 589 | 506258136 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | root | memory/sql/thd::main_mem_root | 527 | 12617016 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | root | memory/sql/THD::variables | 1852 | 2163136 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | root | memory/memory/HP_INFO | 509 | 621736 | | NULL | memory/sql/table_mapping::m_mem_root | 256 | 592896 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 120 | 486720 | | root | memory/sql/user_var_entry | 1852 | 473728 | | root | memory/memory/HP_SHARE | 1018 | 433648 | | NULL | memory/innodb/trx0trx | 1490 | 417032 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.004 sec) Node1 after 4th round (Mem up to 48.2%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | root | memory/sql/sp_head::execute_mem_root | 72837152 | 593768463104 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 72836528 | 295424957568 | | NULL | memory/innodb/mem0mem | 1297747 | 10538748760 | | root | memory/sql/String::value | 109256164 | 8154716408 | | root | memory/innodb/std | 36418937 | 2913480592 | | root | memory/innodb/btr0pcur | 36418204 | 1456728160 | | NULL | memory/innodb/rem0rec | 36300022 | 1452001372 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | root | memory/memory/HP_PTRS | 631 | 546536648 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | root | memory/sql/thd::main_mem_root | 565 | 13059576 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | NULL | memory/sql/thd::main_mem_root | 456 | 3231112 | | root | memory/innodb/mem0mem | 752 | 2704978 | | root | memory/sql/THD::variables | 1982 | 2314976 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | root | memory/memory/HP_INFO | 543 | 656456 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | root | memory/sql/user_var_entry | 1982 | 506752 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.002 sec) Node2 after 4th round (Mem up to 51.1%) MariaDB [(none)]> select USER, EVENT_NAME, COUNT_ALLOC, SUM_NUMBER_OF_BYTES_ALLOC from performance_schema.memory_summary_by_user_by_event_name where SUM_NUMBER_OF_BYTES_ALLOC order by SUM_NUMBER_OF_BYTES_ALLOC desc limit 20; +-----------------------+----------------------------------------+-------------+---------------------------+ | USER | EVENT_NAME | COUNT_ALLOC | SUM_NUMBER_OF_BYTES_ALLOC | +-----------------------+----------------------------------------+-------------+---------------------------+ | NULL | memory/innodb/mem0mem | 1432400 | 11617560194 | | NULL | memory/sql/thd::main_mem_root | 36052 | 6769646920 | | NULL | memory/innodb/std | 40001041 | 3200077776 | | NULL | memory/innodb/rem0rec | 40000020 | 1600001196 | | NULL | memory/innodb/btr0pcur | 40000004 | 1600000260 | | NULL | memory/innodb/buf_buf_pool | 8 | 1073741824 | | root | memory/memory/HP_PTRS | 664 | 575101784 | | gcis_gcisdba_testdb01 | memory/memory/HP_PTRS | 37 | 25648528 | | NULL | memory/sql/XID | 1 | 19922944 | | root | memory/sql/thd::main_mem_root | 579 | 13466904 | | NULL | memory/innodb/hash0hash | 7 | 8319664 | | root | memory/sql/THD::variables | 2126 | 2483168 | | gcis_gcisdba_testdb01 | memory/sql/thd::main_mem_root | 52 | 1160200 | | root | memory/memory/HP_INFO | 580 | 698232 | | NULL | memory/sql/table_mapping::m_mem_root | 256 | 592896 | | root | memory/sql/user_var_entry | 2126 | 543872 | | NULL | memory/sql/THD::transactions::mem_root | 129 | 531480 | | root | memory/memory/HP_SHARE | 1160 | 486816 | | root | memory/sql/QUICK_RANGE_SELECT::alloc | 120 | 486720 | | NULL | memory/innodb/trx0trx | 1490 | 417032 | +-----------------------+----------------------------------------+-------------+---------------------------+ 20 rows in set (0.003 sec)