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 | |
14524 | root@192.168.30.20 | 14 | 104852 | 7489.4286 | 87576 | 151873 | |
14521 | root@192.168.30.20 | 23 | 57683 | 2507.9565 | 23528 | 8829118 | |
14526 | root@192.168.30.20 | 7 | 35222 | 5031.7143 | 18440 | 357163 | |
14527 | root@192.168.30.20 | 5 | 24736 | 4947.2000 | 16408 | 49981 | |
14520 | pma@192.168.30.20 | 5 | 24736 | 4947.2000 | 16408 | 50567 | |
14525 | root@192.168.30.20 | 5 | 16776 | 3355.2000 | 16408 | 491705 | |
44 | sql/event_scheduler | 3 | 16569 | 5523.0000 | 16391 | 16569 | |
42 | innodb/srv_worker_thread | 29 | 14716 | 507.4483 | 8200 | 9561817 | |
38 | innodb/srv_worker_thread | 29 | 14716 | 507.4483 | 8200 | 9374844 | |
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 | 11525900 | |
13 | innodb/page_flush_coordinator_thread | 34 | 1527 | 44.9118 | 665 | 4798 | |
40 | innodb/srv_worker_thread | 21 | 1306 | 62.1905 | 665 | 9134589 | |
25 | innodb/srv_master_thread | 21 | 1306 | 62.1905 | 665 | 1394 | |
26 | innodb/dict_stats_thread | 21 | 1306 | 62.1905 | 665 | 4067467 | |
34 | innodb/buf_dump_thread | 24 | 287 | 11.9583 | 287 | 20819 | |
11 | innodb/io_write_thread | 0 | 0 | 0.0000 | 0 | 0 | |
12 | innodb/io_write_thread | 0 | 0 | 0.0000 | 0 | 0 | |
39 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
41 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
10 | innodb/io_write_thread | 0 | 0 | 0.0000 | 0 | 0 | |
43 | innodb/srv_worker_thread | 0 | 0 | 0.0000 | 0 | 0 | |
9 | innodb/io_write_thread | 0 | 0 | 0.0000 | 0 | 0 |
|