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-replication-group-configuration-version-table.html
This table displays the version of the member actions configuration for replication group members. The replication_group_configuration_version table has these columns: NAME The name of the configuration. Whenever a member action is enabled or ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-member-actions-table.html
This table lists the member actions that are included in the member actions configuration for replication group members. The replication_group_member_actions table has these columns: NAME The name of the member action. You can reset the member ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. The rwlock_instances table has these columns: NAME The instrument name associated with the lock. The ...An rwlock ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tls-channel-status-table.html
The tls_channel_status table (available as of MySQL 8.0.21) provides information about connection interface TLS properties: mysql> SELECT * FROM performance_schema.tls_channel_status\G *************************** 1. The tls_channel_status table has ... Connection interface TLS properties are set at server startup, and can be updated at runtime using the ALTER INSTANCE RELOAD TLS ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-compression.html
Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ALTER TABLE. This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-table-replicas.html
The table_replicas table provides information about the copying, distribution, and checkpointing of NDB table fragments and fragment replicas.
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
When selecting from and inserting into the same table, MySQL creates an internal temporary table to hold the rows from the SELECT and then inserts those rows into the target table. To ensure that the binary log can be used to re-create the original ...| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and ...CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-engines-table.html
The ENGINES table has these columns: ENGINE The name of the storage engine. SUPPORT The server's level of support for the storage engine, as shown in the following table. This is particularly useful for checking whether a storage engine is ...