MySQL Forums
Forum List  »  Performance

Re: MySQL - Performance Schema
Posted by: Carlos A
Date: December 03, 2021 04:51AM

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,

Options: ReplyQuote


Subject
Views
Written By
Posted
183
December 02, 2021 12:22PM
39
December 02, 2021 02:35PM
Re: MySQL - Performance Schema
22
December 03, 2021 04:51AM
52
December 07, 2021 04:30AM
46
December 07, 2021 12:10PM
64
December 09, 2021 09:07AM
42
December 09, 2021 01:00PM
54
December 10, 2021 04:51AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.