No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
26.11 Performance Schema General Table Characteristics
The name of the performance_schema
database is
lowercase, as are the names of tables within it. Queries should
specify the names in lowercase.
Many tables in the performance_schema
database
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 events_waits_
.
Summary tables can be truncated with TRUNCATE
TABLE
. Generally, the effect is to reset the summary
columns to 0 or NULL
, not to remove rows. This
enables you to clear collected values and restart aggregation.
That might be useful, for example, after you have made a runtime
configuration change. Exceptions to this truncation behavior are
noted in individual summary table sections.
Privileges are as for other databases and tables:
Because only a limited set of privileges apply to Performance
Schema tables, attempts to use GRANT ALL
as
shorthand for granting privileges at the database or table leval
fail with an error:
Instead, grant exactly the desired privileges:
Can not display this page of the Infobrol website
Type of error (18-01)
Unknown format specifier "&"Please try again in a few minutes…
Steph