WL#7800: PERFORMANCE SCHEMA, SETUP_ACTORS ENABLED COLUMN

Affects: Server-5.7   —   Status: Complete

Performance_schema.setup_actors table is used to specify for which user/host
connection thread (foreground thread), instrumentation is supposed to be turned ON.

At present, if an entry for a user/host is found in setup_actors table,
instrumentation would be turned ON for that connection (foreground thread). If no
matching row for a user/host is found in setup_actors table, instrumentation for
that user/host connection thread is turned OFF. (keep in mind that %, if
specified, matches to all permissible user/host names).

Therefore, there is no (easy) way to specify the exclusion of a specific
user/host connection thread using setup_actors table. i.e. one can not say enable
all user/host except this one. To allow this, a new column ENABLED is to be
added in setup_actors table to make user capable of specifying exclusion as well.

By default, instrumentation for all foreground threads from all user/host is
Enabled.

Note: Internal (background) threads are unaffected i.e. Enabled.