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
Table 8.11 Example authentication_policy Values authentication_policy Value Effective Policy '*' Permit only creating or altering accounts with one factor. Authentication involves one party establishing its identity to the satisfaction of a second ...Multifactor authentication (MFA) is the use of multiple authentication values (or “factors”) during the authentication ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Support for aliases on tables and columns as required by standard SQL. Support for MySQL-specific SHOW statements that retrieve information about databases, storage engines, tables, and indexes. You can refer to tables from different databases in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html
This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage engine. The index key prefix length limit is 3072 bytes for InnoDB tables that use DYNAMIC or COMPRESSED row format. The index key prefix ...For example, you might hit this limit with a column prefix index of more than 191 characters on a TEXT or VARCHAR column, assuming a utf8mb4 character set and the maximum of 4 bytes for each ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ... # at 302 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. The threads table contains a row for each server thread. For the Performance Schema to monitor a thread, these ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared library. If you are upgrading to MySQL 8.0.30 from an earlier release where you used ...From MySQL 8.0.30, the functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. Handling of Enumeration Literals Trailing spaces are automatically deleted from ENUM ...Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted string ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
As a result of this exchange, the server creates a security context object that represents the identity of the client in the Windows OS. Windows pluggable authentication provides these capabilities: External authentication: Windows authentication ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring a large amount of data into ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...