content_image/801222.jpg
• HISTORY 

Whether to log historical events for foreground threads matched by the row. The value is YES  or NO . 

The setup_actors  table has these indexes: 

•Primary key on ( HOST , USER , ROLE ) 

TRUNCATE TABLE  is permitted for the setup_actors  table. It removes the rows. 

## 27.12.2.2 The setup_consumers Table 

The setup_consumers  table lists the types of consumers for which event information can be stored and which are enabled: 

<img src='content_image/801222.jpg'>

The consumer settings in the setup_consumers  table form a hierarchy from higher levels to lower. For detailed information about the effect of enabling different consumers, see Section 27.4.7, “Pre-Filtering by Consumer” . 

Modifications to the setup_consumers  table affect monitoring immediately. 

The setup_consumers  table has these columns: 

• NAME 

The consumer name. 

• ENABLED 

Whether the consumer is enabled. The value is YES  or NO . This column can be modified. If you disable a consumer, the server does not spend time adding event information to it. 

## 27.12.2.3 The setup_instruments Table 

The setup_consumers  table has these indexes: 

•Primary key on ( NAME ) 

TRUNCATE TABLE  is not permitted for the setup_consumers  table. 

