PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-hosts-table.html
To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 25.12.8, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| stage/sql/end | NO | NO ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. For every mutex instrumented in the code, the Performance Schema provides the following information. A mutex is a synchronization mechanism ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** 1. row *************************** ... The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 25.12.8, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
Tables in these schemas are excluded from view output: mysql, sys, INFORMATION_SCHEMA, performance_schema. The schema_auto_increment_columns view has these columns: table_schema The schema that contains the table. This view indicates which tables ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by them. The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 25.12.12.1, “The metadata_locks Table”. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema ... These views display which sessions are blocked waiting on metadata locks, and what is blocking ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format.