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".

Wyszukiwarka

Podobne podstrony:
Example Consumer Configurations The consumer settings in the setup_consumers table form a hierarchy
APC presents peptide with weak binding to the T-cell receptor APC presents peptide that binds strong
Warrior Praisc for Aumktn the Highland Warrior-.“A ROMANTIC ADVENTURE THAT IS HARD TO RESIST.” —RT l
screenshot
4 Account Wizard & IdentityHE Each account has an identity, which is the information
PreFNtering byThread The threads table contains a rowfor each server thread. Each row contains infor
Static Table Characteristics Static format is the defaultfor MylSAMtables. It is used when the table
The setupobjects Table The setup_objectstable Controls whether particular objects are monitored. Thi
f9 5 lnbox Setup Wizard Select the information services(s] that you want to use with Microsoft Excha
00208 ?1906ab0bcf2542dac76203983810dc 210 Messina, Montgomery, Keats & Runger Table 4. Average
•    The title page should contain: the author’s fuli names, title of the paper, all
2. The New Zealand Table of Allocations2.1 How to use the Table The New Zealand Table of Allocations
i099 THAT -THAT 16 THE UST CONTAININO INFORMATION ON
IMAG0113 (6) Unita View Books Optionsintereom IHU 22 The Smartfind Plus EPIRB contains a GPS receive
25ddg11 Text Import Wizard - Step 2 of 3 This screen lets you set the delimiters your data contains.
111 Changes in chemism of the Łabuńka river.. they contain fewer Ca2+ions and are characterized by t

więcej podobnych podstron