MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 362 total results

17.12.2 Online DDL Performance and Concurrency

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html

Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...

6.5.1.1 mysql Client Options

https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html

--compression-algorithms=value Command-Line Format --compression-algorithms=value Introduced 8.0.18 Type Set Default Value uncompressed Valid Values zlibzstduncompressed The permitted compression algorithms for connections to the server. The ...

6.4.5 mysql_upgrade — Check and Upgrade MySQL Tables

https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html

6.5.2 mysqladmin — A MySQL Server Administration Program

https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html

6.5.3 mysqlcheck — A Table Maintenance Program

https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html

6.5.7 mysqlshow — Display Database, Table, and Column Information

https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html

6.5.8 mysqlslap — A Load Emulation Client

https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html

8.2.15 Password Management

https://dev.mysql.com/doc/refman/8.0/en/password-management.html

Password verification, to require that password changes also specify the current password to be replaced. In password-change statements, a REPLACE clause specifies the current password to be replaced. REPLACE is optional if password changes for the ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...

8.6.1 MySQL Enterprise Encryption Installation and Upgrading

https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html

If you do not set a maximum key size, the upper limit is 16384 for the RSA algorithm and 10000 for the DSA algorithm, as specified by OpenSSL. The most important of these are as follows: The legacy functions support the older DSA algorithm and ...

17.5.1 Buffer Pool

https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html

For efficiency of cache management, the buffer pool is implemented as a linked list of pages; data that is rarely used is aged out of the cache using a variation of the least recently used (LRU) algorithm. Buffer Pool LRU Algorithm The buffer pool ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...

Displaying 51 to 60 of 362 total results