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-events-transactions-current-table.html
For example: mysql> SELECT * FROM performance_schema.events_transactions_current LIMIT 1\G *************************** 1. For more information about the relationship between the three transaction event tables, see Section 25.9, “Performance Schema ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. setup_objects controls whether the Performance Schema monitors particular table and stored program objects. If a given event is not e sent to any ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. 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 ...This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 25.12.6, “Performance Schema Statement Event Tables” describes the events on which statement ...See that discussion for information about the content of statement events, the current and historical statement event tables, and how to control statement event collection, which is partially disabled by ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
To see which storage engines are available and enabled, use the SHOW ENGINES statement or query the INFORMATION_SCHEMA ENGINES table. Setting foreign_key_checks to 0 also affects data definition statements: DROP SCHEMA drops a schema even if it ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-status-table.html
Note Information available from the tables described here is also available from the Performance Schema. The INFORMATION_SCHEMA tables are deprecated in preference to the Performance Schema tables and are removed in MySQL 8.0. For advice on ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-variables-table.html
Note Information available from the tables described here is also available from the Performance Schema. The INFORMATION_SCHEMA tables are deprecated in preference to the Performance Schema tables and are removed in MySQL 8.0. For advice on ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf and you have less information to sift through. If a given consumer setting is NO, the Performance ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-current-table.html
For more information about the relationship between the three stage event tables, see Section 25.9, “Performance Schema Tables for Current and Historical Events”. For information about configuring whether to collect stage events, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
The Performance Schema makes status variable information available in the tables described in Section 25.12.14, “Performance Schema Status Variable Tables”. They differ in that, for grant tables, the host part of an account can be a pattern, ...