PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-schema.html
Do not query these views on a production system unless you are aware of the performance impact and have determined it to be acceptable. The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema views have these columns: object_schema The ... These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-table.html
Do not query these views on a production system unless you are aware of the performance impact and have determined it to be acceptable. The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table views have these columns: object_schema The ... These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-global-by-current-bytes.html
The memory_global_by_current_bytes and x$memory_global_by_current_bytes views have these columns: event_name The memory event name. current_alloc The current number of allocated bytes that have not been freed yet for the event. These views ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/sys-statement-performance-analyzer.html
statement_performance_analyzer.limit, @sys.statement_performance_analyzer.limit The maximum number of rows to return for views that have no built-in limit. Creates a report of the statements running on the server. The views are calculated based on ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html
These views display normalized statements that have produced errors or warnings. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns: query The normalized statement string. By default, rows are ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The normalized statement string. By default, rows are sorted by descending ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary.html
The user_summary and x$user_summary views have these columns: user The client user name. unique_hosts The number of distinct hosts from which connections for the user have originated. These views summarize statement activity, file I/O, and ...