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 | |
4106 | root@192.168.30.20 | 14 | 104812 | 7486.5714 | 87576 | 151753 | |
42 | innodb/srv_worker_thread | 47 | 98363 | 2092.8298 | 73928 | 655083 | |
38 | innodb/srv_worker_thread | 42 | 53891 | 1283.1190 | 37736 | 816699 | |
4107 | root@192.168.30.20 | 5 | 16776 | 3355.2000 | 16408 | 491817 | |
44 | sql/event_scheduler | 20 | 16772 | 838.6000 | 16391 | 29175 | |
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 | 517718 | |
13 | innodb/page_flush_coordinator_thread | 34 | 1527 | 44.9118 | 665 | 4798 | |
40 | innodb/srv_worker_thread | 21 | 1306 | 62.1905 | 665 | 610701 | |
26 | innodb/dict_stats_thread | 21 | 1306 | 62.1905 | 665 | 101235 | |
25 | innodb/srv_master_thread | 21 | 1306 | 62.1905 | 665 | 1394 | |
34 | innodb/buf_dump_thread | 24 | 287 | 11.9583 | 287 | 20819 | |
39 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
37 | innodb/srv_purge_thread | 0 | 0 | 0.0000 | 0 | 0 | |
46 | sql/compress_gtid_table | 0 | 0 | 0.0000 | 0 | 0 | |
41 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
31 | mysqlx/worker | 0 | 0 | 0.0000 | 0 | 0 | |
30 | mysqlx/acceptor_network | 0 | 0 | 0.0000 | 0 | 0 | |
43 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
28 | mysqlx/worker | 0 | 0 | 0.0000 | 0 | 0 | |
45 | sql/signal_handler | 0 | 0 | 0.0000 | 0 | 0 | |
23 | innodb/srv_monitor_thread | 0 | 0 | 0.0000 | 0 | 0 | |
3 | innodb/io_ibuf_thread | 0 | 0 | 0.0000 | 0 | 0 |
|