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/mysql-installer-catalog-dashboard.html
By default, and when an Internet connection is present, MySQL Installer attempts to update the catalog at startup every seven days. Upgrade: This operation loads the Select Products to Upgrade page and populates it with all the upgrade candidates.
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. The functions described here are general-purpose and intended for use with any keyring component or ...
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
At connect time, proxy_user must represent a valid externally authenticated MySQL user, and proxied_user must represent a valid locally authenticated user. The second user is a “proxied user” (a user whose identity and privileges can be assumed ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
(If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE and LOCK IN SHARE MODE set shared locks that permit other transactions to read the examined rows but not ...[WITH ROLLUP]] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [into_option] [FOR {UPDATE | SHARE} [OF tbl_name [, tbl_name] ...] [NOWAIT | SKIP LOCKED] | LOCK IN SHARE MODE] [into_option] into_option: { INTO OUTFILE 'file_name' [CHARACTER SET charset_name] export_options | INTO DUMPFILE 'file_name' | INTO var_name [, var_name] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. This clause always begins with PARTITION BY, ...Simply using a partition_options clause with ALTER TABLE on a partitioned table repartitions the table according to the partitioning scheme defined by the ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
Logged information is buffered during the startup sequence while the InnoDB storage engine is initialized, which is sometimes prolonged by operations such as recovery and data dictionary upgrade that occur during the InnoDB startup sequence. The ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Also, the ...Benefits of BKA include improved join performance due to more efficient table ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior of such tables, and could easily lead to corruption or loss of data. Reads from such tables are relatively unaffected; ... This section discusses current restrictions and limitations on MySQL partitioning ...The following constructs are not permitted in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
It is important to minimize the number of times B-tree nodes are split, as well as to minimize the need to uncompress and recompress their content. Updates and inserts of small records may be written to this modification log without requiring the ...