PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
OLDEST_QUEUED How long in milliseconds the oldest queued statement has been waiting for execution. There is at most one thread ready to start executing if the active threads become stalled or blocked. There can be a maximum of four connection ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
Data and indexes belonging to p1's second subpartition (s1b) are stored on /disk5—the data in /disk5/data, and the indexes in /disk5/idx. Subpartitioning—also known as composite partitioning—is the further division of each partition in a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more quickly. For the second EXPLAIN output row: All COLUMNS table values are OPEN_FRM_ONLY lookups, so COLUMNS.TABLE_NAME requires the .frm file to be opened.
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. Command Syntax Meaning default Reset every optimization to its default value opt_name=default Set the named optimization to its default value opt_name=off Disable the named ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds ...This ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Strict mode produces an error for attempts to create a key that exceeds the maximum key length. If the statement inserts or modifies multiple rows and the bad value occurs in the second or later row, the result depends on which strict mode is ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
This occurs either when the cluster started for the very first time, or when all data nodes are restarted using the --initial option. For an initial start or system restart, a local checkpoint is executed, followed by a global checkpoint. This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-runtimes-in-95th-percentile.html
max_latency The maximum single wait time of timed occurrences of the statement. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query ...For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a ...