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/multifactor-authentication.html
That is, MySQL account management supports accounts that use 2FA or 3FA, in addition to the existing 1FA support. When a client attempts a connection to the MySQL server using a single-factor account, the server invokes the authentication plugin ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all platforms. On Unix-like systems, including Linux, you can check your system's ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Explicit Default Handling as of MySQL 8.0.13 Explicit Default Handling Prior to MySQL 8.0.13 Implicit Default Handling Explicit Default Handling as of MySQL 8.0.13 The default value specified in a DEFAULT clause can be a literal constant or an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
mysql> SELECT index_id, name, table_id, space from INFORMATION_SCHEMA.INNODB_INDEXES WHERE index_id=457; +----------+------+----------+-------+ | index_id | name | table_id | space | +----------+------+----------+-------+ | 457 | idx | 327 | 283 | ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
qualifier: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; Like SET GLOBAL, SET PERSIST sets the global variable runtime value, but also writes the variable setting to the mysqld-auto.cnf file (replacing any existing ...A ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The start item has this format, where value is a literal timestamp value: "start": { "timestamp": "value" } The start item is permitted as of MySQL 8.0.22. Suppose that a call to obtain a bookmark produces this value: mysql> SET @mark := ...The ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. (The resulting sort order may be ...An ORDER BY with and without LIMIT may return rows in different orders, as discussed in Section 10.2.1.19, “LIMIT Query ...
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
Table-Level Locking MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables, permitting only one session to update those tables at a time. Options other than row-level locking: Versioning (such as that used in MySQL for concurrent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of ...The bootstrap should only be done by a single server, the one that starts the group and only ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-installation.html
Note Only one keyring component or plugin should be enabled at a time. MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. To be usable by the server, the component library ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...