10.2.4 The setup_objects Table

The setup_objects table controls
whether the Performance Schema monitors particular objects.
This table has a maximum size of 100 rows by default. To
change the table size, modify the
performance_schema_setup_objects_size
system variable at server startup.

For object types listed in
setup_objects, the Performance
Schema uses the table to how to monitor them. Object matching
is based on the OBJECT_SCHEMA and
OBJECT_NAME columns. Objects for which
there is no match are not monitored.

The effect of the default object configuration is to
instrument all tables except those in the
mysql,
INFORMATION_SCHEMA, and
performance_schema databases. (Tables in
the INFORMATION_SCHEMA database are not
instrumented regardless of the contents of
setup_objects; the row for
information_schema.% simply makes this
default explicit.)

When the Performance Schema checks for a match in
setup_objects, it tries to find
more specific matches first. For example, with a table
db1.t1, it looks for a match for
'db1' and 't1', then for
'db1' and '%', then for
'%' and '%'. The order
in which matching occurs matters because different matching
setup_objects rows can have
different ENABLED and
TIMED values.

Rows can be inserted into or deleted from
setup_objects by users with the
INSERT or
DELETE privilege on the table.
For existing rows, only the ENABLED and
TIMED columns can be modified, by users
with the UPDATE privilege on
the table.