Hi,
Thanks for your reply, indeed i agree with you:
"Performance_schema documentation is opaque at best."
In:
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrumentation-checking.html
We can find out:
"As described earlier, it is possible to find out by querying the setup_instruments table. This information is always up to date for your version of MySQL, also includes instrumentation for instrumented plugins you might have installed that are not part of the core server, and can be used by automated tools."
mysql> SELECT * FROM performance_schema.setup_instruments where name like '%db/memory%' \G;
*************************** 1. row ***************************
NAME: memory/innodb/memory
ENABLED: YES
TIMED: NULL
PROPERTIES:
VOLATILITY: 0
DOCUMENTATION: NULL
1 row in set (0.00 sec)
Well a NULL does not help much.
Do you have any idea what this instrument count for? And with this what should be the reasonable amount of memory for it?
Thanks,