The name of the
performance_schema database is
lowercase, as are the names of tables within it. Queries should
specify the names in lowercase.
Most tables in the
are read only and cannot be modified. Some of the setup tables
have columns that can be modified to affect Performance Schema
operation; some also permit rows to be inserted or deleted.
Truncation is permitted to clear collected events, so
TRUNCATE TABLE can be used on
tables containing those kinds of information, such as tables named
with a prefix of
TRUNCATE TABLE can also be used
with summary tables, but except for
and the memory summary tables, the effect is to reset the summary
columns to 0 or
NULL, not to remove rows.
Privileges are as for other databases and tables:
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices