PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-instrument-filtering.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-instruments-table.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-state-table.html
MARKED_STALLED: This is True if this thread has been marked as stalled by the stall checker thread. The tp_thread_state table has one row per thread created by the thread pool to handle connections. The tp_thread_state table has these columns: ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html
The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and description. VARIABLE_SCOPE The variable's scope; this is one of the values listed here: GLOBAL The variable is ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 29.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.25.3, “Expression Handling”, and Section 14.25.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
Repreparation does not occur if any of the following conditions are true: NULL is used as the actual parameter value. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which ...
https://dev.mysql.com/doc/refman/9.7/en/program-variables.html
On the other hand, with SET, you can assign a variable's value using an expression, which is not true when you set a variable at server startup. Many MySQL programs have internal variables that can be set at runtime using the SET statement. See ...
https://dev.mysql.com/doc/refman/9.7/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...