+---------------------+-----+----------------+ | now() | cnt | tot_cur_mb | +---------------------+-----+----------------+ | 2026-10-06 09:46:46 | 268 | 38172.16715717 | +---------------------+-----+----------------+ 1 row in set (0.001 sec) Bye -------------- select thread_id, event_name, HIGH_NUMBER_OF_BYTES_USED/1024/1024 hi_mb, current_number_of_bytes_used/1024/1024 cur_mb from performance_schema.memory_summary_by_thread_by_event_name where current_number_of_bytes_used >= 0.001 order by current_number_of_bytes_used desc limit 1000 -------------- +-----------+----------------------------------------+----------------+----------------+ | thread_id | event_name | hi_mb | cur_mb | +-----------+----------------------------------------+----------------+----------------+ | 211334 | memory/sql/thd::main_mem_root | 29920.22085571 | 29920.22085571 | | 1 | memory/innodb/buf_buf_pool | 8192.00000000 | 8192.00000000 | | 1 | memory/innodb/hash0hash | 51.12756348 | 51.12756348 | | 22 | memory/innodb/trx0undo | 0.55615234 | 0.55615234 | | 19 | memory/innodb/trx0undo | 0.55563354 | 0.55563354 | | 23 | memory/innodb/trx0undo | 0.55537415 | 0.55537415 | | 21 | memory/innodb/trx0undo | 0.55433655 | 0.55433655 | | 18 | memory/innodb/trx0undo | 0.55433655 | 0.55433655 | | 20 | memory/innodb/trx0undo | 0.55174255 | 0.55174255 | | 4 | memory/innodb/trx0undo | 0.55018616 | 0.55018616 | | 24 | memory/innodb/trx0undo | 0.54992676 | 0.54992676 | | 33575 | memory/innodb/row0sel | 0.48342133 | 0.48342133 | | 211886 | memory/sql/thd::main_mem_root | 0.34678650 | 0.34678650 | | 211886 | memory/innodb/row0sel | 0.30695343 | 0.30695343 | | 33457 | memory/innodb/row0sel | 0.23930359 | 0.23930359 | | 194191 | memory/sql/sp_head::main_mem_root | 0.22628784 | 0.22628784 | | 200245 | memory/sql/sp_head::main_mem_root | 0.21060181 | 0.21060181 | | 200244 | memory/sql/sp_head::main_mem_root | 0.21060181 | 0.21060181 | | 195552 | memory/sql/sp_head::main_mem_root | 0.21060181 | 0.21060181 | | 1 | memory/innodb/mem0mem | 0.14580441 | 0.11331081 | | 1 | memory/sql/THD::variables | 0.07363892 | 0.07141113 | | 1 | memory/innodb/buf0buf | 0.06252289 | 0.06252289 | | 212032 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03216553 | | 195574 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 24 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 195550 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195545 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 180025 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 180027 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195530 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195551 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195531 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 33575 | memory/sql/thd::main_mem_root | 0.12487793 | 0.03121948 | | 195543 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195575 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 179945 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 152336 | memory/sql/thd::main_mem_root | 0.06243896 | 0.03121948 | | 180666 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 180280 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195570 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195549 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195532 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195529 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 22 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 200245 | memory/sql/thd::main_mem_root | 0.80032349 | 0.03121948 | | 20 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 195572 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 183827 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 200244 | memory/sql/thd::main_mem_root | 0.80032349 | 0.03121948 | | 18 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 19 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 195548 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195563 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 196907 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195552 | memory/sql/thd::main_mem_root | 0.80737305 | 0.03121948 | | 195571 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195528 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 33457 | memory/sql/thd::main_mem_root | 0.06243896 | 0.03121948 | | 195533 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 197576 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 21 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 195546 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195573 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 183828 | memory/sql/thd::main_mem_root | 0.06243896 | 0.03121948 | | 195534 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195564 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195540 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195538 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195579 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 180173 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195565 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 4 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 179831 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195566 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 3 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 194191 | memory/sql/thd::main_mem_root | 0.80032349 | 0.03121948 | | 195567 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195578 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195576 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 23 | memory/sql/thd::main_mem_root | 0.03121948 | 0.03121948 | | 195569 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 180663 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195577 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195535 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195542 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195568 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 180662 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 195537 | memory/sql/thd::main_mem_root | 0.03216553 | 0.03121948 | | 33457 | memory/sql/String::value | 0.03144836 | 0.03083801 | | 211886 | memory/sql/sp_head::main_mem_root | 0.02346802 | 0.02346802 | | 1 | memory/sql/plugin_int_mem_root | 0.02325439 | 0.02325439 | | 179590 | memory/sql/thd::main_mem_root | 0.01940155 | 0.01940155 | | 4 | memory/innodb/mem0mem | 0.03677368 | 0.01802063 | | 22 | memory/innodb/mem0mem | 0.02040100 | 0.01802063 | | 211049 | memory/sql/thd::main_mem_root | 0.01763916 | 0.01763916 | | 211886 | memory/sql/String::value | 0.01665497 | 0.01665497 | | 13 | memory/innodb/mem0mem | 0.04899597 | 0.01650238 | | 1 | memory/sql/Prepared_statement_map | 0.01660156 | 0.01611328 | | 180027 | memory/sql/String::value | 0.01600647 | 0.01590729 | | 180025 | memory/sql/String::value | 0.01600647 | 0.01590729 | | 1 | memory/innodb/lexyy | 0.01578808 | 0.01578808 | | 212032 | memory/sql/String::value | 0.01568604 | 0.01568604 | | 33457 | memory/sql/sp_head::main_mem_root | 0.01568604 | 0.01568604 | | 33575 | memory/sql/String::value | 0.01799774 | 0.01564789 | | 195572 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 211770 | memory/sql/String::value | 0.01563263 | 0.01563263 | | 195578 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195570 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 180666 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 183827 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 180662 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195577 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 180280 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 152336 | memory/sql/String::value | 0.01763916 | 0.01563263 | | 180663 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195564 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 196907 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195563 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 194191 | memory/sql/String::value | 0.01778412 | 0.01563263 | | 195576 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 179831 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195565 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195579 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195569 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195573 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195566 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195571 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 180173 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195574 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195552 | memory/sql/String::value | 0.01778412 | 0.01563263 | | 195567 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195575 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195568 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 183828 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195548 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195535 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195537 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195529 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195538 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195542 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195528 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 200245 | memory/sql/String::value | 0.01778412 | 0.01563263 | | 197576 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195540 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195549 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195543 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195530 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 200244 | memory/sql/String::value | 0.01778412 | 0.01563263 | | 195531 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195546 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195532 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195545 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195551 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 179945 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195550 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195533 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 195534 | memory/sql/String::value | 0.01615143 | 0.01563263 | | 1 | memory/sql/ignored_db | 0.01560974 | 0.01560974 | | 211333 | memory/sql/thd::main_mem_root | 0.01473999 | 0.01473999 | | 1 | memory/sql/user_conn | 0.01220703 | 0.01220703 | | 1 | memory/sql/user_var_entry | 0.01245117 | 0.01208496 | | 211886 | memory/innodb/mem0mem | 0.01216125 | 0.01176453 | | 1 | memory/innodb/buf0dblwr | 0.00981140 | 0.00981140 | | 1 | memory/sql/host_cache::hostname | 0.00981140 | 0.00981140 | | 1 | memory/innodb/trx0undo | 0.00881958 | 0.00881958 | | 19 | memory/innodb/mem0mem | 0.03679657 | 0.00879669 | | 21 | memory/innodb/mem0mem | 0.03676605 | 0.00854492 | | 1 | memory/innodb/trx0trx | 0.00828552 | 0.00828552 | | 195535 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195534 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195545 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 152336 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195563 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180663 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 179945 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195570 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195574 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180666 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180025 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 211886 | memory/sql/THD::sp_cache | 0.00778198 | 0.00778198 | | 195549 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195573 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 211886 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195546 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195571 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180280 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195533 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195575 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195548 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195564 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195578 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 194191 | memory/sql/THD::sp_cache | 0.00778198 | 0.00778198 | | 195542 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195566 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195568 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 179831 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195579 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195567 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195572 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 3 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195577 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195537 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195543 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195569 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180662 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180173 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 194191 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195565 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195538 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 4 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195540 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195532 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 200245 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 200244 | memory/sql/THD::sp_cache | 0.00778198 | 0.00778198 | | 195529 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 212032 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 18 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195551 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 23 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195530 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 183828 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 200244 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 22 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 33457 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 200245 | memory/sql/THD::sp_cache | 0.00778198 | 0.00778198 | | 196907 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195576 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 21 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195552 | memory/sql/THD::sp_cache | 0.00778198 | 0.00778198 | | 197576 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 33457 | memory/sql/THD::sp_cache | 0.00778198 | 0.00778198 | | 195528 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 183827 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 180027 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195550 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 33575 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195552 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 20 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 195531 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 24 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 19 | memory/sql/THD::transactions::mem_root | 0.00778198 | 0.00778198 | | 211886 | memory/innodb/ha_innodb | 0.00718689 | 0.00718689 | | 211317 | memory/sql/thd::main_mem_root | 0.00704956 | 0.00704956 | | 211332 | memory/sql/thd::main_mem_root | 0.00704956 | 0.00704956 | | 211337 | memory/sql/thd::main_mem_root | 0.00704956 | 0.00704956 | | 33457 | memory/innodb/ha_innodb | 0.00647736 | 0.00647736 | | 172372 | memory/innodb/mem0mem | 9.04155731 | 0.00588226 | | 211318 | memory/sql/thd::main_mem_root | 0.00528717 | 0.00528717 | | 172372 | memory/sql/thd::main_mem_root | 0.00528717 | 0.00528717 | | 18 | memory/innodb/mem0mem | 0.00722504 | 0.00484467 | | 1 | memory/sql/handlerton | 0.00478363 | 0.00478363 | | 20 | memory/innodb/mem0mem | 0.00687408 | 0.00449371 | | 33575 | memory/innodb/ha_innodb | 0.00444031 | 0.00444031 | | 21 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 24 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 4 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 18 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 19 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 20 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 22 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 23 | memory/sql/table_mapping::m_mem_root | 0.00441742 | 0.00441742 | | 23 | memory/innodb/mem0mem | 0.03679085 | 0.00429726 | | 1 | memory/sql/DDL_LOG_MEMORY_ENTRY | 0.00399780 | 0.00399780 | | 183035 | memory/sql/thd::main_mem_root | 0.00352478 | 0.00352478 | | 211313 | memory/sql/thd::main_mem_root | 0.00352478 | 0.00352478 | | 33457 | memory/innodb/trx0undo | 0.00337219 | 0.00337219 | | 1 | memory/innodb/fil0fil | 0.00345325 | 0.00335217 | | 211886 | memory/memory/HP_INFO | 0.00579834 | 0.00313568 | | 1 | memory/sql/ST_SCHEMA_TABLE | 0.00250244 | 0.00250244 | | 200245 | memory/innodb/trx0undo | 0.00233459 | 0.00233459 | | 195574 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195533 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 183827 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195576 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195545 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195573 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195572 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195543 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 200244 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 196907 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195575 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195546 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 183828 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195542 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180027 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195529 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195535 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180662 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 211886 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195534 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180663 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180025 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195530 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 152336 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195532 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180666 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180173 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195537 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 194191 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195577 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195540 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195550 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 200245 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195578 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195579 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 33457 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 197576 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 179831 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195538 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195528 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 212032 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195531 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 22 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195567 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 24 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 13 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195570 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 180280 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 20 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195551 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 21 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195548 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195569 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195563 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195549 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195568 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 23 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195571 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 18 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195565 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 179945 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 33575 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195564 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 4 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 19 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195566 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 195552 | memory/sql/THD::variables | 0.00222778 | 0.00222778 | | 1 | memory/innodb/std | 0.00279999 | 0.00217438 | | 13 | memory/sql/thd::main_mem_root | 0.00189209 | 0.00189209 | | 195552 | memory/innodb/trx0undo | 0.00155640 | 0.00155640 | | 4 | memory/innodb/ha_innodb | 0.00153351 | 0.00153351 | | 1 | memory/sql/dboptions_hash | 0.00152588 | 0.00152588 | | 211886 | memory/memory/HP_SHARE | 0.00291443 | 0.00145721 | | 13 | memory/innodb/fil0fil | 0.00131989 | 0.00121307 | | 21 | memory/innodb/ha_innodb | 0.00112152 | 0.00112152 | | 18 | memory/innodb/ha_innodb | 0.00112152 | 0.00112152 | | 19 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 200245 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 4 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 24 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 20 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 195552 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 18 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 200244 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 194191 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 33457 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 21 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 23 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 22 | memory/sql/binlog_cache_mngr | 0.00110626 | 0.00110626 | | 23 | memory/sql/dboptions_hash | 0.00104523 | 0.00104523 | | 4 | memory/sql/dboptions_hash | 0.00103760 | 0.00103760 | | 194191 | memory/innodb/trx0undo | 0.00103760 | 0.00103760 | | 200244 | memory/innodb/trx0undo | 0.00077820 | 0.00077820 | | 211314 | memory/innodb/trx0undo | 0.00077820 | 0.00077820 | | 1 | memory/myisam/ft_stopwords | 0.00063324 | 0.00063324 | | 1 | memory/sql/handler::errmsgs | 0.00061798 | 0.00061798 | | 1 | memory/sql/mysql_plugin | 0.00061035 | 0.00061035 | | 1 | memory/sql/mysql_plugin_dl | 0.00057220 | 0.00057220 | | 13 | memory/innodb/ha_innodb | 0.00057220 | 0.00057220 | | 1 | memory/innodb/adaptive hash index | 0.00051117 | 0.00051117 | | 33457 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195578 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 4 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 23 | memory/innodb/std | 0.00143433 | 0.00048828 | | 3 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 183827 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 180027 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 22 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195542 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 23 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 211886 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195565 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 180173 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 180666 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 180025 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195538 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 33575 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195537 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 196907 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 152336 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195540 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195546 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 180663 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 21 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 33457 | memory/innodb/mem0mem | 0.04776001 | 0.00048828 | | 180280 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195563 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 24 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 211770 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 20 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 212032 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 19 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195530 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 13 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195573 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195545 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 197576 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195577 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195571 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195568 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195552 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 200245 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195533 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195569 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195576 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195551 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195570 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195529 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195575 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195574 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 179945 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195550 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195528 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195534 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195531 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195567 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 18 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195543 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195549 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195564 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195532 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 211651 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195566 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195535 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195572 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 194191 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 180662 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 183828 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 200244 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195579 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 195548 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 179831 | memory/sql/Prepared_statement_map | 0.00048828 | 0.00048828 | | 33457 | memory/sql/user_var_entry | 0.00045013 | 0.00045013 | | 211886 | memory/sql/user_var_entry | 0.00045013 | 0.00045013 | | 194191 | memory/sql/user_var_entry | 0.00045013 | 0.00045013 | | 20 | memory/innodb/ha_innodb | 0.00043488 | 0.00043488 | | 19 | memory/innodb/ha_innodb | 0.00043488 | 0.00043488 | | 23 | memory/innodb/fil0fil | 0.00086689 | 0.00040436 | | 21 | memory/innodb/fil0fil | 0.00049591 | 0.00040436 | | 19 | memory/innodb/fil0fil | 0.00052643 | 0.00040436 | | 4 | memory/innodb/fil0fil | 0.00050354 | 0.00040436 | | 179945 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195549 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195530 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 211651 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180027 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 183828 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 22 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195531 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195550 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195533 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195552 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 4 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 196907 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 200244 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195535 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 211770 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 19 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 18 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 200245 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 20 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195534 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 212032 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195529 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195551 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 13 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195528 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195537 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 21 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 197576 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 183827 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 23 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195548 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180666 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195576 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180173 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195546 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195573 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195545 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195564 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195569 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195540 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180663 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195570 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195574 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180280 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180662 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 152336 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195575 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195563 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195568 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195542 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195538 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 24 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195532 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195572 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195567 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 180025 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195566 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195579 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195543 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195578 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 3 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195571 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195565 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 195577 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 33575 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 179831 | memory/sql/user_var_entry | 0.00036621 | 0.00036621 | | 4 | memory/innodb/std | 0.00062561 | 0.00032043 | | 21 | memory/innodb/std | 0.00062561 | 0.00030518 | | 13 | memory/innodb/std | 0.00068665 | 0.00027466 | | 19 | memory/innodb/std | 0.00066376 | 0.00027466 | | 1 | memory/sql/global_system_variables | 0.00024414 | 0.00024414 | | 24 | memory/innodb/std | 0.00115967 | 0.00018311 | | 1 | memory/sql/dbnames_cache | 0.00015259 | 0.00015259 | | 1 | memory/innodb/ut0pool | 0.00013733 | 0.00013733 | | 33575 | memory/innodb/rem0rec | 0.00013542 | 0.00013542 | | 211886 | memory/innodb/rem0rec | 0.00012970 | 0.00012970 | | 22 | memory/innodb/btr0pcur | 0.00012398 | 0.00012398 | | 1 | memory/sql/String::value | 0.00148010 | 0.00012207 | | 33457 | memory/innodb/rem0rec | 0.00012112 | 0.00012112 | | 212032 | memory/sql/user_conn | 0.00009918 | 0.00009918 | | 180027 | memory/sql/host_cache::hostname | 0.00009155 | 0.00009155 | | 180025 | memory/sql/host_cache::hostname | 0.00009155 | 0.00009155 | | 1 | memory/innodb/ut0wqueue | 0.00008392 | 0.00008392 | | 33457 | memory/innodb/btr0pcur | 0.00008106 | 0.00008106 | | 211334 | memory/innodb/std | 0.00689697 | 0.00005341 | | 195571 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195577 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195531 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 200245 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195570 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195567 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195572 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195578 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195532 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195543 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 200244 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195534 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 179945 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195533 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195548 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195574 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195575 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195551 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195550 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195528 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195569 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195545 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195530 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195573 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195546 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 197576 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195576 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195568 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195549 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195529 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 211886 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195535 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 183827 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 180663 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195564 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 180173 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 211770 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195540 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 180662 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 196907 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195563 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 180280 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195538 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 152336 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 33457 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 180666 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195537 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 33575 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 194191 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195542 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 179831 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 1 | memory/sql/MYSQL_BIN_LOG::index | 0.00004578 | 0.00004578 | | 195552 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 183828 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 1 | memory/sql/MYSQL_LOG::name | 0.00004578 | 0.00004578 | | 195579 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 211651 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195566 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 195565 | memory/sql/host_cache::hostname | 0.00004578 | 0.00004578 | | 1 | memory/sql/MYSQL_BIN_LOG::basename | 0.00004578 | 0.00004578 | | 21 | memory/innodb/btr0pcur | 0.00004387 | 0.00004387 | | 21 | memory/innodb/rem0rec | 0.00006485 | 0.00004387 | | 1 | memory/innodb/ut0list | 0.00003815 | 0.00003815 | | 4 | memory/innodb/rem0rec | 0.00006866 | 0.00003815 | | 18 | memory/innodb/std | 0.00020599 | 0.00003815 | | 4 | memory/innodb/btr0pcur | 0.00003815 | 0.00003815 | | 22 | memory/innodb/std | 0.00028992 | 0.00003815 | | 13 | memory/innodb/lexyy | 0.00002956 | 0.00002956 | | 19 | memory/sql/String::value | 0.00006104 | 0.00002289 | | 180025 | memory/sql/THD::db | 0.00002289 | 0.00002289 | | 172372 | memory/sql/String::value | 0.00002289 | 0.00002289 | | 20 | memory/sql/String::value | 0.00002289 | 0.00002289 | | 18 | memory/sql/String::value | 0.00002289 | 0.00002289 | | 180027 | memory/sql/THD::db | 0.00002289 | 0.00002289 | | 195538 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195546 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195546 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195537 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195532 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195543 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195538 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195537 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195533 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195548 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195548 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195534 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195535 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195545 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195542 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195535 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195543 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195540 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195540 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195545 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 179945 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195542 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195534 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 4 | memory/sql/String::value | 0.00001526 | 0.00001526 | | 195533 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 1 | memory/sql/NAMED_ILINK::name | 0.00001526 | 0.00001526 | | 180280 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 180173 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195564 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 194191 | memory/innodb/std | 0.00026703 | 0.00001526 | | 194191 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 194191 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195565 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195565 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 179831 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 179831 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195566 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 180173 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195564 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 152336 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 152336 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 180280 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 180663 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 180663 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195563 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 180662 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 180662 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195563 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195571 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195579 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195579 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195575 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195569 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195574 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195570 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195574 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195573 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195570 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195573 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195571 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195572 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195575 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195569 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195566 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195567 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195578 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195578 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195567 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195568 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195577 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195576 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195568 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195576 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195572 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 180666 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195532 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195528 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195551 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 197576 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 197576 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 13 | memory/sql/String::value | 0.00001526 | 0.00001526 | | 200245 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 200245 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195552 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 200244 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195528 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195551 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195529 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 179945 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195549 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195531 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195531 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195549 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195530 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195550 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195529 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195550 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 200244 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195552 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 211651 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 33457 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 212032 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 180027 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 195530 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 211886 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 211886 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 33575 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 33575 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 180666 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 33457 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 180025 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 183827 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 211770 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 183828 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 196907 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 196907 | memory/sql/THD::db | 0.00001526 | 0.00001526 | | 195577 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 183828 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 21 | memory/sql/String::value | 0.00001526 | 0.00001526 | | 183827 | memory/sql/MPVIO_EXT::auth_info | 0.00001526 | 0.00001526 | | 33575 | memory/innodb/std | 0.00028229 | 0.00000763 | | 4 | memory/sql/NAMED_ILINK::name | 0.00000763 | 0.00000763 | | 33457 | memory/innodb/std | 0.00027466 | 0.00000763 | +-----------+----------------------------------------+----------------+----------------+ 734 rows in set (0.008 sec) Bye -------------- select event_name, sum(current_number_of_bytes_used/1024/1024) tot_cur_mb from performance_schema.memory_summary_by_thread_by_event_name group by event_name order by 2 desc -------------- +-----------------------------------------------------+----------------+ | event_name | tot_cur_mb | +-----------------------------------------------------+----------------+ | memory/sql/thd::main_mem_root | 29953.29133590 | | memory/innodb/buf_buf_pool | 8192.00000000 | | memory/innodb/hash0hash | 51.12756348 | | memory/memory/HP_PTRS | 4.24993896 | | memory/innodb/trx0undo | 3.64923096 | | memory/innodb/row0sel | 1.02967835 | | memory/sql/sp_head::main_mem_root | 0.89724733 | | memory/sql/String::value | 0.88783269 | | memory/sql/THD::transactions::mem_root | 0.52139266 | | memory/sql/THD::variables | 0.22067239 | | memory/innodb/mem0mem | 0.21012210 | | memory/innodb/buf0buf | 0.06252289 | | memory/sql/Prepared_statement_map | 0.05029288 | | memory/sql/THD::sp_cache | 0.04669188 | | memory/sql/user_var_entry | 0.03797142 | | memory/sql/table_mapping::m_mem_root | 0.03533936 | | memory/sql/plugin_int_mem_root | 0.02325439 | | memory/innodb/ha_innodb | 0.02220155 | | memory/innodb/lexyy | 0.01581764 | | memory/sql/ignored_db | 0.01560974 | | memory/sql/binlog_cache_mngr | 0.01438138 | | memory/sql/host_cache::hostname | 0.01260396 | | memory/sql/user_conn | 0.01230621 | | memory/innodb/buf0dblwr | 0.00981140 | | memory/innodb/trx0trx | 0.00828552 | | memory/innodb/fil0fil | 0.00618268 | | memory/sql/handlerton | 0.00478363 | | memory/memory/HP_INFO | 0.00457764 | | memory/innodb/std | 0.00418093 | | memory/sql/DDL_LOG_MEMORY_ENTRY | 0.00399780 | | memory/sql/dboptions_hash | 0.00360871 | | memory/memory/HP_SHARE | 0.00291442 | | memory/sql/ST_SCHEMA_TABLE | 0.00250244 | | memory/sql/MPVIO_EXT::auth_info | 0.00091560 | | memory/sql/THD::db | 0.00088508 | | memory/myisam/ft_stopwords | 0.00063324 | | memory/sql/handler::errmsgs | 0.00061798 | | memory/sql/mysql_plugin | 0.00061035 | | memory/sql/mysql_plugin_dl | 0.00057220 | | memory/innodb/adaptive hash index | 0.00051117 | | memory/innodb/rem0rec | 0.00046826 | | memory/innodb/btr0pcur | 0.00028706 | | memory/sql/global_system_variables | 0.00024414 | | memory/sql/dbnames_cache | 0.00015259 | | memory/innodb/ut0pool | 0.00013733 | | memory/innodb/ut0wqueue | 0.00008392 | | memory/sql/MYSQL_BIN_LOG::index | 0.00004578 | | memory/sql/MYSQL_LOG::name | 0.00004578 | | memory/sql/MYSQL_BIN_LOG::basename | 0.00004578 | | memory/innodb/ut0list | 0.00003815 | | memory/sql/NAMED_ILINK::name | 0.00002289 | | memory/innodb/row_log_buf | 0.00000000 | | memory/innodb/btr0sea | 0.00000000 | | memory/innodb/dict0stats | 0.00000000 | | memory/innodb/fts0file | 0.00000000 | | memory/sql/Locked_tables_list::m_locked_tables_root | 0.00000000 | | memory/innodb/pars0lex | 0.00000000 | | memory/innodb/srv0start | 0.00000000 | | memory/innodb/ut0mem | 0.00000000 | | memory/sql/Row_data_memory::memory | 0.00000000 | | memory/sql/user_var_entry::value | 0.00000000 | | memory/sql/TABLE_RULE_ENT | 0.00000000 | | memory/sql/Unique::merge_buffer | 0.00000000 | | memory/sql/Table_trigger_dispatcher::m_mem_root | 0.00000000 | | memory/myisam/MI_INFO::ft1_to_ft2 | 0.00000000 | | memory/myisam/MI_SORT_PARAM | 0.00000000 | | memory/myisam/preload_buffer | 0.00000000 | | memory/myisammrg/children | 0.00000000 | | memory/partition/ha_partition::file | 0.00000000 | | memory/innodb/btr0bulk | 0.00000000 | | memory/innodb/buf0rea | 0.00000000 | | memory/innodb/fts0ast | 0.00000000 | | memory/innodb/fts0sql | 0.00000000 | | memory/innodb/lock0lock | 0.00000000 | | memory/sql/Table_triggers_list | 0.00000000 | | memory/innodb/row0merge | 0.00000000 | | memory/sql/QUICK_RANGE_SELECT::alloc | 0.00000000 | | memory/innodb/xtrabackup | 0.00000000 | | memory/sql/Event_queue_element_for_exec::names | 0.00000000 | | memory/sql/Gis_read_stream::err_msg | 0.00000000 | | memory/sql/binlog_statement_buffer | 0.00000000 | | memory/myisam/FTPARSER_PARAM | 0.00000000 | | memory/myisam/SORT_INFO::buffer | 0.00000000 | | memory/csv/row | 0.00000000 | | memory/partition/Partition_share | 0.00000000 | | memory/innodb/dict_stats_index_map_t | 0.00000000 | | memory/innodb/fil0crypt | 0.00000000 | | memory/innodb/fts0opt | 0.00000000 | | memory/innodb/row0ftsort | 0.00000000 | | memory/sql/sp_head::execute_mem_root | 0.00000000 | | memory/innodb/trx0roll | 0.00000000 | | memory/sql/Sys_var_charptr::value | 0.00000000 | | memory/sql/Filesort_info::merge | 0.00000000 | | memory/sql/MYSQL_RELAY_LOG::index | 0.00000000 | | memory/sql/binlog_ver_1_event | 0.00000000 | | memory/sql/DATE_TIME_FORMAT | 0.00000000 | | memory/sql/THD::handler_tables_hash | 0.00000000 | | memory/sql/MDL_context::acquire_locks | 0.00000000 | | memory/myisam/record_buffer | 0.00000000 | | memory/myisam/SORT_FT_BUF | 0.00000000 | | memory/myisam/keycache_thread_var | 0.00000000 | | memory/innodb/other | 0.00000000 | | memory/innodb/dict0mem | 0.00000000 | | memory/innodb/fts0config | 0.00000000 | | memory/innodb/gis0sea | 0.00000000 | | memory/innodb/os0file | 0.00000000 | | memory/sql/Prepared_statement::main_mem_root | 0.00000000 | | memory/sql/Blob_mem_storage::storage | 0.00000000 | | memory/sql/Event_scheduler::scheduler_param | 0.00000000 | | memory/sql/Unique::sort_buffer | 0.00000000 | | memory/myisam/MI_INFO | 0.00000000 | | memory/myisam/MYISAM_SHARE::decode_tables | 0.00000000 | | memory/myisammrg/MYRG_INFO | 0.00000000 | | memory/partition/Partition_admin | 0.00000000 | | memory/innodb/btr0buf | 0.00000000 | | memory/innodb/buf0lru | 0.00000000 | | memory/innodb/fsp0file | 0.00000000 | | memory/innodb/fts0que | 0.00000000 | | memory/sql/gdl | 0.00000000 | | memory/innodb/row0log | 0.00000000 | | memory/innodb/trx0seg | 0.00000000 | | memory/sql/QUICK_RANGE_SELECT::mrr_buf_desc | 0.00000000 | | memory/sql/errmsgs | 0.00000000 | | memory/sql/binlog_pos | 0.00000000 | | memory/myisam/FT_INFO | 0.00000000 | | memory/myisam/filecopy | 0.00000000 | | memory/csv/tina_set | 0.00000000 | | memory/memory/HP_KEYDEF | 0.00000000 | | memory/innodb/dict_stats_bg_recalc_pool_t | 0.00000000 | | memory/innodb/row_merge_sort | 0.00000000 | | memory/innodb/eval0eval | 0.00000000 | | memory/innodb/fts0fts | 0.00000000 | | memory/innodb/handler0alter | 0.00000000 | | memory/sql/display_table_locks | 0.00000000 | | memory/innodb/trx0i_s | 0.00000000 | | memory/innodb/ut0new | 0.00000000 | | memory/sql/Sort_param::tmp_buffer | 0.00000000 | | memory/sql/User_level_lock | 0.00000000 | | memory/sql/MYSQL_RELAY_LOG::basename | 0.00000000 | | memory/sql/Rpl_info_file::buffer | 0.00000000 | | memory/sql/frm::string | 0.00000000 | | memory/sql/bison_stack | 0.00000000 | | memory/sql/wsrep | 0.00000000 | | memory/myisam/MI_INFO::bulk_insert | 0.00000000 | | memory/myisam/MI_SORT_PARAM::wordroot | 0.00000000 | | memory/myisam/stPageList::pages | 0.00000000 | | memory/partition/ha_partition::part_ids | 0.00000000 | | memory/innodb/btr0cur | 0.00000000 | | memory/innodb/dict0dict | 0.00000000 | | memory/innodb/fts0blex | 0.00000000 | | memory/innodb/fts0tlex | 0.00000000 | | memory/innodb/row0mysql | 0.00000000 | | memory/sql/MYSQL_BIN_LOG::recover | 0.00000000 | | memory/sql/Relay_log_info::group_relay_log_name | 0.00000000 | | memory/sql/XID | 0.00000000 | | memory/sql/my_str_malloc | 0.00000000 | | memory/sql/MYSQL_LOCK | 0.00000000 | | memory/sql/JOIN_CACHE | 0.00000000 | | memory/sql/PROFILE | 0.00000000 | | memory/myisam/MYISAM_SHARE | 0.00000000 | | memory/myisam/ft_memroot | 0.00000000 | | memory/myisam/MI_DECODE_TREE | 0.00000000 | | memory/csv/Transparent_file | 0.00000000 | | memory/partition/partition_sort_buffer | 0.00000000 | | memory/innodb/dict_stats_n_diff_on_level | 0.00000000 | | memory/innodb/btr0btr | 0.00000000 | | memory/innodb/buf0dump | 0.00000000 | | memory/innodb/fts0pars | 0.00000000 | | memory/innodb/i_s | 0.00000000 | | memory/innodb/row0import | 0.00000000 | | memory/sql/sp_head::call_mem_root | 0.00000000 | | memory/innodb/trx0rseg | 0.00000000 | | memory/sql/Queue::queue_item | 0.00000000 | | memory/innodb/ut0rbt | 0.00000000 | | memory/sql/Filesort_info::record_pointers | 0.00000000 | | memory/sql/TC_LOG_MMAP::pages | 0.00000000 | | memory/sql/rpl_filter memory | 0.00000000 | | memory/sql/SLAVE_INFO | 0.00000000 | | memory/sql/hash_index_key_buffer | 0.00000000 | | memory/myisam/FTB | 0.00000000 | | memory/myisam/SORT_KEY_BLOCKS | 0.00000000 | | memory/csv/blobroot | 0.00000000 | +-----------------------------------------------------+----------------+ 182 rows in set (0.046 sec) Bye -------------- select now(), count(*) cnt, sum(current_number_of_bytes_used/1024/1024) tot_cur_mb from performance_schema.memory_summary_by_thread_by_event_name -------------- +---------------------+-------+----------------+ | now() | cnt | tot_cur_mb | +---------------------+-------+----------------+ | 2026-10-06 09:46:46 | 20930 | 38250.14620018 | +---------------------+-------+----------------+ 1 row in set (0.008 sec) Bye -------------- show global status like 'Open%' -------------- +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | Open_files | 40 | | Open_streams | 4 | | Open_table_definitions | 253 | | Open_tables | 298 | | Opened_files | 268731 | | Opened_plugin_libraries | 5 | | Opened_table_definitions | 465 | | Opened_tables | 519 | | Opened_views | 0 | +--------------------------+--------+ 9 rows in set (0.020 sec) Bye -------------- select t.thread_id, p.id process_id, t.type, p.memory_used, p.query_id, p.info_binary, p.user, p.host, t.processlist_db, p.db, p.command, p.time time_ms, p.state from performance_schema.threads t left join information_schema.processlist p on t.processlist_id=p.id order by p.memory_used desc -------------- +-----------+------------+------------+-------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------------------------------------------------------+--------------------+--------------------+---------+---------+-------------------------+ | thread_id | process_id | type | memory_used | query_id | info_binary | user | host | processlist_db | db | command | time_ms | state | +-----------+------------+------------+-------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------------------------------------------------------+--------------------+--------------------+---------+---------+-------------------------+ | 211886 | 211570 | FOREGROUND | 675928 | 2820705 | select distinct(upper(VALUE)) from ( select APPL_ID_NO VALUE from TEST_CRE union all ( select STUDENT_ID VALUE from TEST_CRE ) union all ( select case when SECOND_FACTOR_CD = 'DOB_MONTH_YEAR' then substr(SECOND_FACTOR_VALUE, 3) else SECOND_FACTOR_VALUE end VALUE from ( select AR.SECOND_FACTOR_VALUE, WST.SECOND_FACTOR_CD from TEST_CRE AR left join WEB_SCHEME_TYPE_MAP WSTM on WSTM.TEST_CRE_SCHEME_TYPE_CD = AR.SCHEME_TYPE_CD left join WEB_SCHEME_TYPE WST on WST.SCHEME_TYPE_CD = WSTM.WEB_SCHEME_TYPE_CD where SECOND_FACTOR_CD in ('DATE_OF_BIRTH', 'DOB_MONTH_YEAR', 'DOB_STUDENT_APPLICANT', 'STUDENT_ID_NUMBER') ) U1 ) ) U2 where VALUE is not null and upper(VALUE) not in (select VALUE from TEST_CRE_HASH) | AAAA111 | 192.168.17.193:18143 | CCCCC333 | CCCCC333 | Query | 24 | Sending data | | 212036 | 211719 | FOREGROUND | 285536 | 2821127 | select t.thread_id, p.id process_id, t.type, p.memory_used, p.query_id, p.info_binary, p.user, p.host, t.processlist_db, p.db, p.command, p.time time_ms, p.state from performance_schema.threads t left join information_schema.processlist p on t.processlist_id=p.id order by p.memory_used desc | BBBBB222 | localhost | NULL | NULL | Query | 0 | Filling schema table | | 195578 | 195280 | FOREGROUND | 95896 | 2775980 | NULL | AAAA111 | 192.168.17.193:25237 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195577 | 195279 | FOREGROUND | 95896 | 2775979 | NULL | AAAA111 | 192.168.17.193:43005 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195576 | 195278 | FOREGROUND | 95896 | 2775978 | NULL | AAAA111 | 192.168.17.193:9847 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195575 | 195277 | FOREGROUND | 95896 | 2775977 | NULL | AAAA111 | 192.168.17.193:11073 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195574 | 195276 | FOREGROUND | 95896 | 2775976 | NULL | AAAA111 | 192.168.17.193:53209 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195573 | 195275 | FOREGROUND | 95896 | 2775975 | NULL | AAAA111 | 192.168.17.193:44904 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195572 | 195274 | FOREGROUND | 95896 | 2775974 | NULL | AAAA111 | 192.168.17.193:51068 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195571 | 195273 | FOREGROUND | 95896 | 2775973 | NULL | AAAA111 | 192.168.17.193:49300 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195570 | 195272 | FOREGROUND | 95896 | 2775972 | NULL | AAAA111 | 192.168.17.193:38150 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195569 | 195271 | FOREGROUND | 95896 | 2775971 | NULL | AAAA111 | 192.168.17.193:59768 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195568 | 195270 | FOREGROUND | 95896 | 2775970 | NULL | AAAA111 | 192.168.17.193:58654 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195567 | 195269 | FOREGROUND | 95896 | 2775969 | NULL | AAAA111 | 192.168.17.193:46125 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195566 | 195268 | FOREGROUND | 95896 | 2775968 | NULL | AAAA111 | 192.168.17.193:55067 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195565 | 195267 | FOREGROUND | 95896 | 2775967 | NULL | AAAA111 | 192.168.17.193:14431 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195564 | 195266 | FOREGROUND | 95896 | 2775966 | NULL | AAAA111 | 192.168.17.193:17622 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195563 | 195265 | FOREGROUND | 95896 | 2775957 | NULL | AAAA111 | 192.168.17.193:23296 | CCCCC333 | CCCCC333 | Sleep | 1485 | | | 195550 | 195252 | FOREGROUND | 95896 | 2775914 | NULL | AAAA111 | 192.168.17.193:53620 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195549 | 195251 | FOREGROUND | 95896 | 2775913 | NULL | AAAA111 | 192.168.17.193:30134 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195548 | 195250 | FOREGROUND | 95896 | 2775912 | NULL | AAAA111 | 192.168.17.193:47634 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195546 | 195248 | FOREGROUND | 95896 | 2775911 | NULL | AAAA111 | 192.168.17.193:61414 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195545 | 195247 | FOREGROUND | 95896 | 2775910 | NULL | AAAA111 | 192.168.17.193:57674 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195543 | 195245 | FOREGROUND | 95896 | 2775906 | NULL | AAAA111 | 192.168.17.193:64928 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195542 | 195244 | FOREGROUND | 95896 | 2775903 | NULL | AAAA111 | 192.168.17.193:19888 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195540 | 195242 | FOREGROUND | 95896 | 2775902 | NULL | AAAA111 | 192.168.17.193:47704 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195538 | 195240 | FOREGROUND | 95896 | 2775899 | NULL | AAAA111 | 192.168.17.193:32132 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195537 | 195239 | FOREGROUND | 95896 | 2775898 | NULL | AAAA111 | 192.168.17.193:52332 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195535 | 195237 | FOREGROUND | 95896 | 2775895 | NULL | AAAA111 | 192.168.17.193:53380 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195534 | 195236 | FOREGROUND | 95896 | 2775894 | NULL | AAAA111 | 192.168.17.193:21402 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195533 | 195235 | FOREGROUND | 95896 | 2775893 | NULL | AAAA111 | 192.168.17.193:60798 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195532 | 195234 | FOREGROUND | 95896 | 2775892 | NULL | AAAA111 | 192.168.17.193:8728 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195531 | 195233 | FOREGROUND | 95896 | 2775891 | NULL | AAAA111 | 192.168.17.193:51170 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195530 | 195232 | FOREGROUND | 95896 | 2775890 | NULL | AAAA111 | 192.168.17.193:43755 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195529 | 195231 | FOREGROUND | 95896 | 2775889 | NULL | AAAA111 | 192.168.17.193:57914 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 195528 | 195230 | FOREGROUND | 95896 | 2775879 | NULL | AAAA111 | 192.168.17.193:43255 | CCCCC333 | CCCCC333 | Sleep | 1486 | | | 183827 | 183533 | FOREGROUND | 95896 | 2747104 | NULL | AAAA111 | 192.168.17.193:14447 | CCCCC333 | CCCCC333 | Sleep | 2536 | | | 180663 | 180376 | FOREGROUND | 95896 | 2739028 | NULL | AAAA111 | 192.168.17.193:36937 | CCCCC333 | CCCCC333 | Sleep | 2866 | | | 180662 | 180375 | FOREGROUND | 95896 | 2739027 | NULL | AAAA111 | 192.168.17.193:57075 | CCCCC333 | CCCCC333 | Sleep | 2866 | | | 180280 | 179993 | FOREGROUND | 95896 | 2737220 | NULL | AAAA111 | 192.168.17.193:37328 | CCCCC333 | CCCCC333 | Sleep | 3076 | | | 180173 | 179886 | FOREGROUND | 95896 | 2736720 | NULL | AAAA111 | 192.168.17.193:31822 | CCCCC333 | CCCCC333 | Sleep | 3135 | | | 179945 | 179658 | FOREGROUND | 95896 | 2735656 | NULL | AAAA111 | 192.168.17.193:38673 | CCCCC333 | CCCCC333 | Sleep | 3256 | | | 179831 | 179544 | FOREGROUND | 95896 | 2735126 | NULL | AAAA111 | 192.168.17.193:20966 | CCCCC333 | CCCCC333 | Sleep | 3316 | | | 152336 | 152104 | FOREGROUND | 95896 | 2821016 | NULL | AAAA111 | 192.168.17.193:27431 | CCCCC333 | CCCCC333 | Sleep | 5 | | | 180027 | 179740 | FOREGROUND | 95840 | 2820521 | NULL | BBBBB222 | defgddd1..abc:56012 | information_schema | information_schema | Sleep | 30 | | | 180025 | 179738 | FOREGROUND | 95840 | 2820436 | NULL | BBBBB222 | t2vdbs-gddd2..abc:42366 | information_schema | information_schema | Sleep | 31 | | | 194191 | 193894 | FOREGROUND | 94992 | 2775782 | NULL | AAAA111 | 192.168.17.193:13856 | CCCCC333 | CCCCC333 | Sleep | 1490 | | | 33457 | 33404 | FOREGROUND | 94936 | 2820814 | NULL | AAAA111 | 192.168.17.193:28916 | CCCCC333 | CCCCC333 | Sleep | 18 | | | 200245 | 199947 | FOREGROUND | 94880 | 2803054 | NULL | AAAA111 | 192.168.17.193:43543 | CCCCC333 | CCCCC333 | Sleep | 515 | | | 200244 | 199946 | FOREGROUND | 94880 | 2797194 | NULL | AAAA111 | 192.168.17.193:9279 | CCCCC333 | CCCCC333 | Sleep | 728 | | | 197576 | 197278 | FOREGROUND | 94880 | 2780962 | NULL | AAAA111 | 192.168.17.193:32476 | CCCCC333 | CCCCC333 | Sleep | 1306 | | | 196907 | 196609 | FOREGROUND | 94880 | 2797268 | NULL | AAAA111 | 192.168.17.193:61505 | CCCCC333 | CCCCC333 | Sleep | 726 | | | 195579 | 195281 | FOREGROUND | 94880 | 2777902 | NULL | AAAA111 | 192.168.17.193:9591 | CCCCC333 | CCCCC333 | Sleep | 1417 | | | 195552 | 195254 | FOREGROUND | 94880 | 2784675 | NULL | AAAA111 | 192.168.17.193:10820 | CCCCC333 | CCCCC333 | Sleep | 1174 | | | 195551 | 195253 | FOREGROUND | 94880 | 2780697 | NULL | AAAA111 | 192.168.17.193:31020 | CCCCC333 | CCCCC333 | Sleep | 1315 | | | 183828 | 183534 | FOREGROUND | 94880 | 2775724 | NULL | AAAA111 | 192.168.17.193:24227 | CCCCC333 | CCCCC333 | Sleep | 1491 | | | 180666 | 180379 | FOREGROUND | 94880 | 2775700 | NULL | AAAA111 | 192.168.17.193:41020 | CCCCC333 | CCCCC333 | Sleep | 1491 | | | 33575 | 33522 | FOREGROUND | 94880 | 2814486 | NULL | AAAA111 | 192.168.17.193:64011 | CCCCC333 | CCCCC333 | Sleep | 98 | | | 211770 | 211454 | FOREGROUND | 94824 | 2821094 | NULL | dhh | defkkk01..abc:48660 | NULL | NULL | Sleep | 0 | | | 211651 | 211336 | FOREGROUND | 94824 | 2821102 | NULL | dhh | defkkk01..abc:50912 | NULL | NULL | Sleep | 0 | | | 21 | 9 | FOREGROUND | 79424 | 2820894 | NULL | system user | | NULL | NULL | Sleep | 11 | wsrep applier committed | | 20 | 8 | FOREGROUND | 79424 | 2820751 | NULL | system user | | NULL | NULL | Sleep | 22 | wsrep applier committed | | 18 | 6 | FOREGROUND | 79424 | 2821080 | NULL | system user | | NULL | NULL | Sleep | 1 | wsrep applier committed | | 4 | 2 | FOREGROUND | 79424 | 2816717 | NULL | system user | | NULL | NULL | Sleep | 42 | wsrep applier committed | | 24 | 12 | FOREGROUND | 78408 | 2820837 | NULL | system user | | NULL | NULL | Sleep | 16 | wsrep applier committed | | 23 | 11 | FOREGROUND | 78408 | 2815601 | NULL | system user | | NULL | NULL | Sleep | 63 | wsrep applier committed | | 22 | 10 | FOREGROUND | 78408 | 2820981 | NULL | system user | | NULL | NULL | Sleep | 6 | wsrep applier committed | | 19 | 7 | FOREGROUND | 78408 | 2820412 | NULL | system user | | NULL | NULL | Sleep | 32 | wsrep applier committed | | 3 | 1 | FOREGROUND | 71000 | 0 | NULL | system user | | NULL | NULL | Sleep | 86367 | wsrep aborter idle | | 1 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | mysql | NULL | NULL | NULL | NULL | | 2 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 7 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 8 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 9 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 12 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 13 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 14 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 15 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 25 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 26 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 32 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 33 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 34 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 44 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 46 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 47 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 67536 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 170853 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 170858 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 191048 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211001 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211312 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211313 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211314 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211316 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211317 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211318 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 62102 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211332 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211333 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211334 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211335 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211336 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211337 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211902 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 183035 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 180873 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211354 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 211049 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 179590 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 130365 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 39065 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 8595 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 96144 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 172372 | NULL | BACKGROUND | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | +-----------+------------+------------+-------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------------------------------------------------------+--------------------+--------------------+---------+---------+-------------------------+ 115 rows in set (0.302 sec) Bye -------------- select t.thread_os_id as os_tid, p.id as mariadb_connection_id, p.user as user, p.host as host, p.db as db, p.command as command, p.memory_used as current_memory_bytes, p.max_memory_used as peak_memory_bytes, p.info as active_query from performance_schema.threads t, information_schema.processlist p where t.processlist_id = p.id order by p.memory_used desc limit 10 -------------- +---------+-----------------------+------------+------------------------------------------------------+----------+---------+----------------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | os_tid | mariadb_connection_id | user | host | db | command | current_memory_bytes | peak_memory_bytes | active_query | +---------+-----------------------+------------+------------------------------------------------------+----------+---------+----------------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1014342 | 211721 | BBBBB222 | fff05f..abc:55514 | NULL | Query | 4353360 | 88432 | show status like 'wsrep_ready' | | 1014343 | 211570 | AAAA111 | 192.168.17.193:18143 | CCCCC333 | Query | 675928 | 75935232 | select distinct(upper(VALUE)) from ( select APPL_ID_NO VALUE from TEST_CRE union all ( select STUDENT_ID VALUE from TEST_CRE ) union all ( select case when SECOND_FACTOR_CD = 'DOB_MONTH_YEAR' then substr(SECOND_FACTOR_VALUE, 3) else SECOND_FACTOR_VALUE end VALUE from ( select AR.SECOND_FACTOR_VALUE, WST.SECOND_FACTOR_CD from TEST_CRE AR left join WEB_SCHEME_TYPE_MAP WSTM on WSTM.TEST_CRE_SCHEME_TYPE_CD = AR.SCHEME_TYPE_CD left join WEB_SCHEME_TYPE WST on WST.SCHEME_TYPE_CD = WSTM.WEB_SCHEME_TYPE_CD where SECOND_FACTOR_CD in ('DATE_OF_BIRTH', 'DOB_MONTH_YEAR', 'DOB_STUDENT_APPLICANT', 'STUDENT_ID_NUMBER') ) U1 ) ) U2 where VALUE is not null and upper(VALUE) not in (select VALUE from TEST_CRE_HASH) | | 1014344 | 211720 | BBBBB222 | localhost | NULL | Query | 229912 | 229912 | select t.thread_os_id as os_tid, p.id as mariadb_connection_id, p.user as user, p.host as host, p.db as db, p.command as command, p.memory_used as current_memory_bytes, p.max_memory_used as peak_memory_bytes, p.info as active_query from performance_schema.threads t, information_schema.processlist p where t.processlist_id = p.id order by p.memory_used desc limit 10 | | 1014343 | 195250 | AAAA111 | 192.168.17.193:47634 | CCCCC333 | Sleep | 95896 | 105456 | NULL | | 1885556 | 179658 | AAAA111 | 192.168.17.193:38673 | CCCCC333 | Sleep | 95896 | 105456 | NULL | | 2989403 | 195251 | AAAA111 | 192.168.17.193:30134 | CCCCC333 | Sleep | 95896 | 105456 | NULL | | 3705773 | 195252 | AAAA111 | 192.168.17.193:53620 | CCCCC333 | Sleep | 95896 | 105456 | NULL | | 1014342 | 179993 | AAAA111 | 192.168.17.193:37328 | CCCCC333 | Sleep | 95896 | 105456 | NULL | | 3705662 | 195265 | AAAA111 | 192.168.17.193:23296 | CCCCC333 | Sleep | 95896 | 105456 | NULL | | 1014343 | 195266 | AAAA111 | 192.168.17.193:17622 | CCCCC333 | Sleep | 95896 | 105456 | NULL | +---------+-----------------------+------------+------------------------------------------------------+----------+---------+----------------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 10 rows in set (0.022 sec) Bye -------------- SELECT t.THREAD_ID AS mariadb_internal_thread_id, t.PROCESSLIST_ID AS mariadb_connection_id, t.THREAD_OS_ID AS os_thread_id, t.TYPE AS thread_type, t.NAME AS thread_name, p.USER AS user, p.HOST AS host, p.DB AS db, p.COMMAND AS command, m.EVENT_NAME AS memory_component, ROUND(m.CURRENT_NUMBER_OF_BYTES_USED / 1024 / 1024, 2) AS current_memory_mb, ROUND(m.HIGH_NUMBER_OF_BYTES_USED / 1024 / 1024, 2) AS peak_memory_mb, p.INFO AS active_query FROM performance_schema.threads t LEFT JOIN information_schema.processlist p ON t.PROCESSLIST_ID = p.ID LEFT JOIN performance_schema.memory_summary_by_thread_by_event_name m ON t.THREAD_ID = m.THREAD_ID WHERE m.CURRENT_NUMBER_OF_BYTES_USED > 0 ORDER BY m.CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 30 -------------- +----------------------------+-----------------------+--------------+-------------+------------------------------------+-------------+---------------------+----------+---------+-----------------------------------+-------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | mariadb_internal_thread_id | mariadb_connection_id | os_thread_id | thread_type | thread_name | user | host | db | command | memory_component | current_memory_mb | peak_memory_mb | active_query | +----------------------------+-----------------------+--------------+-------------+------------------------------------+-------------+---------------------+----------+---------+-----------------------------------+-------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 211334 | NULL | 4056169 | BACKGROUND | thread/innodb/thread_pool_thread | NULL | NULL | NULL | NULL | memory/sql/thd::main_mem_root | 30226.78 | 30226.78 | NULL | | 1 | NULL | 997408 | BACKGROUND | thread/sql/main | NULL | NULL | NULL | NULL | memory/innodb/buf_buf_pool | 8192.00 | 8192.00 | NULL | | 1 | NULL | 997408 | BACKGROUND | thread/sql/main | NULL | NULL | NULL | NULL | memory/innodb/hash0hash | 51.13 | 51.13 | NULL | | 22 | 10 | 1014336 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.56 | 0.56 | NULL | | 19 | 7 | 1014332 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.56 | 0.56 | NULL | | 23 | 11 | 1014337 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.56 | 0.56 | NULL | | 18 | 6 | 1014331 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.55 | 0.55 | NULL | | 21 | 9 | 1014335 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.55 | 0.55 | NULL | | 20 | 8 | 1014333 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.55 | 0.55 | NULL | | 4 | 2 | 998439 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.55 | 0.55 | NULL | | 24 | 12 | 1014334 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/innodb/trx0undo | 0.55 | 0.55 | NULL | | 33575 | 33522 | 1219911 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:64011 | CCCCC333 | Sleep | memory/innodb/row0sel | 0.48 | 0.48 | NULL | | 212040 | 211722 | 1014343 | FOREGROUND | thread/sql/one_connection | BBBBB222 | localhost | NULL | Query | memory/sql/JOIN_CACHE | 0.36 | 0.36 | SELECT t.THREAD_ID AS mariadb_internal_thread_id, t.PROCESSLIST_ID AS mariadb_connection_id, t.THREAD_OS_ID AS os_thread_id, t.TYPE AS thread_type, t.NAME AS thread_name, p.USER AS user, p.HOST AS host, p.DB AS db, p.COMMAND AS command, m.EVENT_NAME AS memory_component, ROUND(m.CURRENT_NUMBER_OF_BYTES_USED / 1024 / 1024, 2) AS current_memory_mb, ROUND(m.HIGH_NUMBER_OF_BYTES_USED / 1024 / 1024, 2) AS peak_memory_mb, p.INFO AS active_query FROM performance_schema.threads t LEFT JOIN information_schema.processlist p ON t.PROCESSLIST_ID = p.ID LEFT JOIN performance_schema.memory_summary_by_thread_by_event_name m ON t.THREAD_ID = m.THREAD_ID WHERE m.CURRENT_NUMBER_OF_BYTES_USED > 0 ORDER BY m.CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 30 | | 211886 | 211570 | 1014343 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:18143 | CCCCC333 | Query | memory/sql/thd::main_mem_root | 0.35 | 0.35 | select distinct(upper(VALUE)) from ( select APPL_ID_NO VALUE from TEST_CRE union all ( select STUDENT_ID VALUE from TEST_CRE ) union all ( select case when SECOND_FACTOR_CD = 'DOB_MONTH_YEAR' then substr(SECOND_FACTOR_VALUE, 3) else SECOND_FACTOR_VALUE end VALUE from ( select AR.SECOND_FACTOR_VALUE, WST.SECOND_FACTOR_CD from TEST_CRE AR left join WEB_SCHEME_TYPE_MAP WSTM on WSTM.TEST_CRE_SCHEME_TYPE_CD = AR.SCHEME_TYPE_CD left join WEB_SCHEME_TYPE WST on WST.SCHEME_TYPE_CD = WSTM.WEB_SCHEME_TYPE_CD where SECOND_FACTOR_CD in ('DATE_OF_BIRTH', 'DOB_MONTH_YEAR', 'DOB_STUDENT_APPLICANT', 'STUDENT_ID_NUMBER') ) U1 ) ) U2 where VALUE is not null and upper(VALUE) not in (select VALUE from TEST_CRE_HASH) | | 211886 | 211570 | 1014343 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:18143 | CCCCC333 | Query | memory/innodb/row0sel | 0.31 | 0.31 | select distinct(upper(VALUE)) from ( select APPL_ID_NO VALUE from TEST_CRE union all ( select STUDENT_ID VALUE from TEST_CRE ) union all ( select case when SECOND_FACTOR_CD = 'DOB_MONTH_YEAR' then substr(SECOND_FACTOR_VALUE, 3) else SECOND_FACTOR_VALUE end VALUE from ( select AR.SECOND_FACTOR_VALUE, WST.SECOND_FACTOR_CD from TEST_CRE AR left join WEB_SCHEME_TYPE_MAP WSTM on WSTM.TEST_CRE_SCHEME_TYPE_CD = AR.SCHEME_TYPE_CD left join WEB_SCHEME_TYPE WST on WST.SCHEME_TYPE_CD = WSTM.WEB_SCHEME_TYPE_CD where SECOND_FACTOR_CD in ('DATE_OF_BIRTH', 'DOB_MONTH_YEAR', 'DOB_STUDENT_APPLICANT', 'STUDENT_ID_NUMBER') ) U1 ) ) U2 where VALUE is not null and upper(VALUE) not in (select VALUE from TEST_CRE_HASH) | | 33457 | 33404 | 1014351 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:28916 | CCCCC333 | Sleep | memory/innodb/row0sel | 0.24 | 0.24 | NULL | | 194191 | 193894 | 1014358 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:13856 | CCCCC333 | Sleep | memory/sql/sp_head::main_mem_root | 0.23 | 0.23 | NULL | | 195552 | 195254 | 1014357 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:10820 | CCCCC333 | Sleep | memory/sql/sp_head::main_mem_root | 0.21 | 0.21 | NULL | | 200244 | 199946 | 1014343 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:9279 | CCCCC333 | Sleep | memory/sql/sp_head::main_mem_root | 0.21 | 0.21 | NULL | | 200245 | 199947 | 1385244 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:43543 | CCCCC333 | Sleep | memory/sql/sp_head::main_mem_root | 0.21 | 0.21 | NULL | | 1 | NULL | 997408 | BACKGROUND | thread/sql/main | NULL | NULL | NULL | NULL | memory/innodb/mem0mem | 0.11 | 0.15 | NULL | | 212040 | 211722 | 1014343 | FOREGROUND | thread/sql/one_connection | BBBBB222 | localhost | NULL | Query | memory/sql/thd::main_mem_root | 0.09 | 0.09 | SELECT t.THREAD_ID AS mariadb_internal_thread_id, t.PROCESSLIST_ID AS mariadb_connection_id, t.THREAD_OS_ID AS os_thread_id, t.TYPE AS thread_type, t.NAME AS thread_name, p.USER AS user, p.HOST AS host, p.DB AS db, p.COMMAND AS command, m.EVENT_NAME AS memory_component, ROUND(m.CURRENT_NUMBER_OF_BYTES_USED / 1024 / 1024, 2) AS current_memory_mb, ROUND(m.HIGH_NUMBER_OF_BYTES_USED / 1024 / 1024, 2) AS peak_memory_mb, p.INFO AS active_query FROM performance_schema.threads t LEFT JOIN information_schema.processlist p ON t.PROCESSLIST_ID = p.ID LEFT JOIN performance_schema.memory_summary_by_thread_by_event_name m ON t.THREAD_ID = m.THREAD_ID WHERE m.CURRENT_NUMBER_OF_BYTES_USED > 0 ORDER BY m.CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 30 | | 1 | NULL | 997408 | BACKGROUND | thread/sql/main | NULL | NULL | NULL | NULL | memory/sql/THD::variables | 0.07 | 0.07 | NULL | | 1 | NULL | 997408 | BACKGROUND | thread/sql/main | NULL | NULL | NULL | NULL | memory/innodb/buf0buf | 0.06 | 0.06 | NULL | | 195548 | 195250 | 1014343 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:47634 | CCCCC333 | Sleep | memory/sql/thd::main_mem_root | 0.03 | 0.03 | NULL | | 3 | 1 | 998438 | FOREGROUND | thread/sql/wsrep_rollbacker_thread | system user | | NULL | Sleep | memory/sql/thd::main_mem_root | 0.03 | 0.03 | NULL | | 4 | 2 | 998439 | FOREGROUND | thread/sql/wsrep_applier_thread | system user | | NULL | Sleep | memory/sql/thd::main_mem_root | 0.03 | 0.03 | NULL | | 179945 | 179658 | 1885556 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:38673 | CCCCC333 | Sleep | memory/sql/thd::main_mem_root | 0.03 | 0.03 | NULL | | 195549 | 195251 | 2989403 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:30134 | CCCCC333 | Sleep | memory/sql/thd::main_mem_root | 0.03 | 0.03 | NULL | | 195550 | 195252 | 3705773 | FOREGROUND | thread/sql/one_connection | AAAA111 | 192.168.17.193:53620 | CCCCC333 | Sleep | memory/sql/thd::main_mem_root | 0.03 | 0.03 | NULL | +----------------------------+-----------------------+--------------+-------------+------------------------------------+-------------+---------------------+----------+---------+-----------------------------------+-------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 30 rows in set (0.033 sec)