Performance Schema setup_actors Table
The setup_actors
table contains information for determining whether
monitoring should be enabled for new client connection threads.
The default size is 100 rows, which can be changed by modifying the
performance_schema_setup_actors_size
system variable at server startup.
If a row in the table matches a new foreground thread's client and host, the
matching INSTRUMENTED
column in the
threads table is set to either YES
or
NO
, which allows selective application of instrumenting by host, by user,
or combination thereof.
Column | Description |
---|---|
HOST | Host name, either a literal, or the % wildcard representing any host. |
USER | User name, either a literal or the % wildcard representing any name. |
ROLE | Unused |
Initially, any user and host is matched:
SELECT * FROM performance_schema.setup_actors; +------+------+------+ | HOST | USER | ROLE | +------+------+------+ | % | % | % | +------+------+------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.