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/performance-schema-setup-instruments-table.html
Events produced by the instrument have NULL for the TIMER_START, TIMER_END, and TIMER_WAIT timer values. This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. For ...row ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
For additional information about reconfiguring the TLS context, including which system and status variables are context-related, see Server-Side Runtime Configuration and Monitoring for Encrypted Connections. If the CRL file is large, the server ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-plugin.html
These endpoints are vault specific and Oracle Cloud Infrastructure assigns them at vault-creation time. The keyring_oci plugin does not support runtime reconfiguration and none of its system variables can be modified at runtime. As of MySQL 8.0.31, ... Note The keyring_oci plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ...If it ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Whereas partition pruning applies only to queries, explicit selection of partitions is supported for both queries and a number of DML ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition prevents merging and takes precedence over the derived_merge value. This is true ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
This is a kind of long-running “statement” that runs for a very long time, and that should not prevent other statements from executing. With this design, when a thread executes or becomes blocked for an extended time, the thread pool moves the ...thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
In this method there is only ever one group, and each server instance is removed from the group, upgraded and then rejoined to the group. For full information on version compatibility in a group and how this influences the behavior of a group during ... Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with an older version in ...