Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
Results from queries can be retrieved into local variables using SELECT ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
MySQL supports a very useful extension that enables the use of regular SELECT statements (that is, without using cursors or local variables) inside a stored procedure. Multiple SELECT statements generate multiple result sets, so the client must use ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-enabled.html
Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); +-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | ... Returns YES or ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-timed.html
Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); +-----------------------------------------------------------------+ | sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf') | ... Returns YES or NO to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-thread-instrumented.html
Example mysql> SELECT sys.ps_is_thread_instrumented(43); +-----------------------------------+ | sys.ps_is_thread_instrumented(43) | +-----------------------------------+ | UNKNOWN | +-----------------------------------+ mysql> SELECT ... Returns ...
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-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...
https://dev.mysql.com/doc/refman/8.4/en/system-variables-controlling-tracing.html
optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET optimizer_trace_features=option=value[,option=value][,...] option: {greedy_search | range_optimizer | dynamic_range | ... The ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...