MySQL Bugs: #107397: Contribution by Tencent:memory/innodb/buf_buf

Bug #107397	Contribution by Tencent:memory/innodb/buf_buf_pool missed
Submitted:	25 May 2022 16:45	Modified:	26 May 2022 6:13
Reporter:	yuxiang jiang (OCA)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S3 (Non-critical)
Version:	5.7.18,5.7.36	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contribution, pfs innodb buffer pool

Description:
When checking innodb buffer pool allocation, we found entry of memory/innodb/buf_buf_pool is missed in sys.memory_global_by_current_bytes.

How to repeat:
step 1

set performance on in my.cnf as below

performance_schema=ON
performance_schema_max_memory_classes=10000
performance-schema-instrument='memory/%=COUNTED'

step 2
start server

step 3
check innodb buffer pool allocation
select * from sys.memory_global_by_current_bytes where event_name like '%buf_buf_pool%'\G

Suggested fix:
It seems that memory/innodbbuf_buf_pool is a global entry not a pfs_thread related entry. 

By change the definition of the entry as below in source file storage/innobase/ut/ut0new.cc.

{&mem_key_buf_buf_pool, "buf_buf_pool", PSI_FLAG_GLOBAL},

We can get the correct result.

Hello yuxiang jiang,

Thank you for the report and contribution.

regards,
Umesh

Sorry this is not the correct bug report.

I have done some other modifications for test and accidently trigger this.

The actual problem happens when resizing buffer pool which reported laterly here 
https://bugs.mysql.com/bug.php?id=107400&thanks=4

Thank you for confirming.
Closing this as a duplicate of Bug #107400.

regards,
Umesh