89551

The setupactors Tsble

The setup_actors table contains information that determines whether to enable monitoring

for newforeground server threads; that is, threads associated with Client connections. This

table has a maximum size of 100 rows by default. The size may be changed by modifying the

performance_schema_setup_actors_size [2765] system variable at server startu p.

The setup_actors table has these columns:

•    HOST

The host name. This should be a literał name, or * % ' to mean “any host."

•USER

The user name. This should be a literał name, or • % ' to mean “any user."

•    ROLE Unused.

For each newforeground thread, the Performance Schema matches the user and host for the the

thread against the rows of the setup_actors table. Based on whether any row matches, the

INSTRUMENTED column of the threads table row for the thread is set to YES or NO. This enables

instrumenting to be applied selectively per host, user, or combination of host and user.

The initial contents of the setup_actors table match any user and host

combination, so monitoring

for all foreground threads is enabled by default:

rnysql>SELECT * FROM setup_actors;

HOST |	USER	- + ■ I	ROLE |
------+.		-+■	------+
% | %	I % I

Modifications to the setup_actors table do not affect existing threads.

For morę information about the role of the setup_actors table in event monitoring, see

Section 21.2.3.2.1, “Event Pre-Filtering".