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 | |
7965 | root@192.168.30.20 | 14 | 104852 | 7489.4286 | 87576 | 151873 | |
7964 | pma@192.168.30.20 | 5 | 24736 | 4947.2000 | 16408 | 50567 | |
44 | sql/event_scheduler | 20 | 16772 | 838.6000 | 16391 | 29175 | |
42 | innodb/srv_worker_thread | 29 | 14716 | 507.4483 | 8200 | 6538875 | |
38 | innodb/srv_worker_thread | 29 | 14716 | 507.4483 | 8200 | 10033499 | |
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 | 11756824 | |
13 | innodb/page_flush_coordinator_thread | 34 | 1527 | 44.9118 | 665 | 4798 | |
25 | innodb/srv_master_thread | 21 | 1306 | 62.1905 | 665 | 1394 | |
40 | innodb/srv_worker_thread | 21 | 1306 | 62.1905 | 665 | 5406617 | |
26 | innodb/dict_stats_thread | 21 | 1306 | 62.1905 | 665 | 1394 | |
34 | innodb/buf_dump_thread | 24 | 287 | 11.9583 | 287 | 20819 | |
31 | mysqlx/worker | 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 | |
46 | sql/compress_gtid_table | 0 | 0 | 0.0000 | 0 | 0 | |
45 | sql/signal_handler | 0 | 0 | 0.0000 | 0 | 0 | |
5 | innodb/io_read_thread | 0 | 0 | 0.0000 | 0 | 0 | |
43 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
6 | innodb/io_read_thread | 0 | 0 | 0.0000 | 0 | 0 | |
41 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
7 | innodb/io_read_thread | 0 | 0 | 0.0000 | 0 | 0 | |
39 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 |
|