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/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...Within ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
For more information about the relationship between the three transaction event tables, see Section 25.9, “Performance Schema Tables for Current and Historical Events”. The Performance Schema defines transaction boundaries similarly to that of ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
For additional information about the differences between non-x$ and x$ views, see Section 26.4.3, “sys Schema Views”. To examine sys schema object definitions, use the appropriate SHOW statement or INFORMATION_SCHEMA query. To view object ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. sys schema objects can be used for typical tuning and diagnosis use cases. Objects in this schema include: Views ...Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or removes the root ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. Developers familiar with the Performance Schema interface can ...This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. For more information about the relationship between the three wait event tables, see Section 25.9, “Performance Schema Tables for Current and Historical Events”. Within ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance Schema documentation, see Chapter 25, MySQL Performance Schema. You can profile certain internal InnoDB operations using the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-build-configuration.html
It is possible to exclude certain parts of the Performance Schema instrumentation. If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has ...