Performance Schema setup_actors Table
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
system variable at server startup.
If a row in the table matches a new foreground thread's client and host, the
INSTRUMENTED column in the
threads table is set to either
NO, which allows selective application of instrumenting by host, by user,
or combination thereof.
|Host name, either a literal, or the |
|User name, either a literal or the |
Initially, any user and host is matched:
SELECT * FROM performance_schema.setup_actors; +------+------+------+ | HOST | USER | ROLE | +------+------+------+ | % | % | % | +------+------+------+
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.