PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Stored routines also enable you to have libraries of functions in the database server. A stored routine is a ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
Within a string, certain sequences have special meaning unless the NO_BACKSLASH_ESCAPES SQL mode is enabled. A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' ...
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 ...