SELECT * FROM `memory_by_thread_by_current_bytes`
|
thread_id | user | current_count_used | current_allocated | current_avg_alloc | current_max_alloc | total_allocated | |
---|---|---|---|---|---|---|---|
2795 | root@192.168.30.20 | 25 | 329.76 KiB | 13.19 KiB | 166.47 KiB | 377.78 KiB | |
2797 | root@192.168.30.20 | 18 | 322.37 KiB | 17.91 KiB | 257.43 KiB | 2.50 MiB | |
35 | innodb/clone_gtid_thread | 89 | 261.45 KiB | 2.94 KiB | 115.99 KiB | 338.77 KiB | |
2791 | root@192.168.30.20 | 7 | 26.84 KiB | 3.83 KiB | 26.46 KiB | 10.65 MiB | |
2788 | root@192.168.30.20 | 7 | 25.45 KiB | 3.64 KiB | 25.07 KiB | 13.96 MiB | |
2794 | pma@192.168.30.20 | 5 | 24.16 KiB | 4.83 KiB | 16.02 KiB | 49.38 KiB | |
2789 | pma@192.168.30.20 | 5 | 24.16 KiB | 4.83 KiB | 16.02 KiB | 49.38 KiB | |
2792 | pma@192.168.30.20 | 5 | 24.16 KiB | 4.83 KiB | 16.02 KiB | 49.38 KiB | |
2796 | pma@192.168.30.20 | 5 | 24.16 KiB | 4.83 KiB | 16.02 KiB | 49.38 KiB | |
2793 | root@192.168.30.20 | 7 | 20.79 KiB | 2.97 KiB | 20.41 KiB | 28.37 MiB | |
2790 | root@192.168.30.20 | 5 | 16.38 KiB | 3.28 KiB | 16.02 KiB | 479.20 KiB | |
45 | sql/event_scheduler | 20 | 16.38 KiB | 839 bytes | 16.01 KiB | 29.84 KiB | |
31 | mysqlx/acceptor_network | 153 | 12.22 KiB | 82 bytes | 12.21 KiB | 72.57 KiB | |
6 | innodb/io_read_thread | 55 | 3.81 KiB | 71 bytes | 3.81 KiB | 3.81 KiB | |
5 | innodb/io_read_thread | 30 | 2.08 KiB | 71 bytes | 2.08 KiB | 2.08 KiB | |
27 | innodb/fts_optimize_thread | 22 | 1.91 KiB | 89 bytes | 665 bytes | 1.99 KiB | |
36 | innodb/srv_purge_thread | 22 | 1.55 KiB | 72 bytes | 665 bytes | 886.04 KiB | |
13 | innodb/page_flush_coordinator_thread | 34 | 1.49 KiB | 45 bytes | 665 bytes | 4.69 KiB | |
42 | innodb/srv_worker_thread | 21 | 1.28 KiB | 62 bytes | 665 bytes | 611.12 KiB | |
25 | innodb/srv_master_thread | 21 | 1.28 KiB | 62 bytes | 665 bytes | 1.36 KiB | |
26 | innodb/dict_stats_thread | 21 | 1.28 KiB | 62 bytes | 665 bytes | 1.36 MiB | |
40 | innodb/srv_worker_thread | 21 | 1.28 KiB | 62 bytes | 665 bytes | 443.73 KiB | |
38 | innodb/srv_worker_thread | 21 | 1.28 KiB | 62 bytes | 665 bytes | 628.30 KiB | |
8 | innodb/io_read_thread | 5 | 355 bytes | 71 bytes | 355 bytes | 355 bytes | |
34 | innodb/buf_dump_thread | 24 | 287 bytes | 12 bytes | 287 bytes | 23.03 KiB |
|