SELECT * FROM `x$memory_by_thread_by_current_bytes`
|
thread_id | user | current_count_used | current_allocated | current_avg_alloc | current_max_alloc | total_allocated | |
---|---|---|---|---|---|---|---|
35 | innodb/clone_gtid_thread | 89 | 267728 | 3008.1798 | 118776 | 346902 | |
12783 | root@192.168.30.20 | 14 | 104852 | 7489.4286 | 87576 | 151873 | |
12781 | root@192.168.30.20 | 7 | 33166 | 4738.0000 | 32792 | 3238359 | |
12782 | pma@192.168.30.20 | 5 | 24736 | 4947.2000 | 16408 | 50567 | |
12780 | pma@192.168.30.20 | 5 | 24736 | 4947.2000 | 16408 | 50567 | |
45 | sql/event_scheduler | 3 | 16569 | 5523.0000 | 16391 | 16569 | |
42 | innodb/srv_worker_thread | 29 | 14716 | 507.4483 | 8200 | 3820697 | |
40 | innodb/srv_worker_thread | 29 | 14716 | 507.4483 | 8200 | 8855396 | |
29 | mysqlx/acceptor_network | 153 | 12514 | 81.7908 | 12506 | 74309 | |
27 | innodb/fts_optimize_thread | 22 | 1954 | 88.8182 | 665 | 2042 | |
36 | innodb/srv_purge_thread | 22 | 1586 | 72.0909 | 665 | 4552660 | |
13 | innodb/page_flush_coordinator_thread | 34 | 1527 | 44.9118 | 665 | 4798 | |
26 | innodb/dict_stats_thread | 21 | 1306 | 62.1905 | 665 | 301083 | |
38 | innodb/srv_worker_thread | 21 | 1306 | 62.1905 | 665 | 6104747 | |
25 | innodb/srv_master_thread | 21 | 1306 | 62.1905 | 665 | 1394 | |
34 | innodb/buf_dump_thread | 24 | 287 | 11.9583 | 287 | 20819 | |
12 | innodb/io_write_thread | 0 | 0 | 0.0000 | 0 | 0 | |
3 | innodb/io_ibuf_thread | 0 | 0 | 0.0000 | 0 | 0 | |
4 | innodb/io_log_thread | 0 | 0 | 0.0000 | 0 | 0 | |
5 | innodb/io_read_thread | 0 | 0 | 0.0000 | 0 | 0 | |
6 | innodb/io_read_thread | 0 | 0 | 0.0000 | 0 | 0 | |
46 | sql/compress_gtid_table | 0 | 0 | 0.0000 | 0 | 0 | |
7 | innodb/io_read_thread | 0 | 0 | 0.0000 | 0 | 0 | |
44 | sql/signal_handler | 0 | 0 | 0.0000 | 0 | 0 | |
43 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 |
|