> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-setup_actors-table.md).

# Performance Schema setup\_actors Table

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](/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables.md#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](/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-threads-table.md) 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:

```sql
SELECT * FROM performance_schema.setup_actors;
+------+------+------+
| HOST | USER | ROLE |
+------+------+------+
| %    | %    | %    |
+------+------+------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}