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/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.0/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.0/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.0/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.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-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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-information-schema-tables.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The following sections describe the INFORMATION_SCHEMA ... Note As of MySQL 8.0.14, the INFORMATION_SCHEMA thread pool tables are also available as Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
When the thread group selects a queued statement for execution, it first looks in the high-priority queue, then in the low-priority queue. For example, if SELECT * FROM performance_schema.tp_thread_group_stats\G returns 17 rows (one row per thread ... The thread pool consists of a number of thread groups, each of which manages a set of client ...