mysql memory usage analysis

 SELECT SUBSTRING_INDEX(event_name,'/',2) AS

       code_area, FORMAT_BYTES(SUM(current_alloc))
       AS current_alloc
       FROM sys.x$memory_global_by_current_bytes
       GROUP BY SUBSTRING_INDEX(event_name,'/',2)
       ORDER BY SUM(current_alloc) DESC

code_area	current_alloc
memory/innodb	4.65 GiB
memory/performance_schema	232.48 MiB
memory/sql	80.08 MiB
memory/mysys	33.07 MiB
memory/temptable	2.00 MiB
memory/myisam	1.41 MiB
memory/mysqld_openssl	152.04 KiB
memory/csv	49.84 KiB
memory/blackhole	88 bytes
memory/vio	8 bytes

SELECT CONCAT(FORMAT(A.num * 100.0 / B.num,2),'%') `BufferPool %` FROM
    (SELECT variable_value num FROM performance_schema.global_status
    WHERE variable_name = 'Innodb_buffer_pool_pages_data') A,
    (SELECT variable_value num FROM performance_schema.global_status
    WHERE variable_name = 'Innodb_buffer_pool_pages_total') B

BufferPool %
91.72%

select format_bytes(sum(current_alloc)) from sys.x$memory_global_by_current_bytes;