Search Results
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Effect of Signals on Handlers, Cursors, and Statements Signals have different effects on statement execution depending on the signal class. The statement thus clears any warnings that may have been present there (and resets warning_count to 0).
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
If you encounter build errors such as internal compiler error when compiling large source files, it may be that you have too little memory. Note If you have to install any programs, modify your PATH environment variable to include any directories in ...Some of these tools are needed no matter whether you use a standard source distribution or a development source ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/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 ...