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/information-schema-ndb-transid-mysql-connection-map-table.html
It is implemented as an INFORMATION_SCHEMA plugin; you can verify that it is supported by checking the output of SHOW PLUGINS. The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
For more information about the relationship between the three events_statements_xxx event tables, see Section 25.9, “Performance Schema Tables for Current and Historical Events”. For information about configuring whether to collect statement ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_SCHEMA and OBJECT_NAME columns should contain a literal schema or object name, or '%' to match any name. Setting the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
For more information about the relationship between the three wait event tables, see Section 25.9, “Performance Schema Tables for Current and Historical Events”. For information about configuring whether to collect wait events, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema views have these columns: object_schema The schema name for the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
Note The processlist table is automatically created in the Performance Schema for new installations of MySQL 5.7.39, or higher. Note If the performance_schema_show_processlist system variable is enabled, the processlist table also serves as the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies within the schema directory. This function is useful when extracting file I/O information from the Performance Schema ...For this reason, it does not work with partitions or tables defined using their own DATA_DIRECTORY table ...