The setup_actors
table was added in MariaDB 10.0 (along with many other new Performance Schema tables).
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 | +------+------+------+ | % | % | % | +------+------+------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-setup_actors-table/