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-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster ...It is important to keep in mind that, by default, the MySQL grant tables use the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ...The list ... Beginning with MySQL 8.0.22, you can use the asynchronous connection failover mechanism to automatically establish an asynchronous (source to replica) replication connection to a new source after the existing connection from a replica to its source ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. The events_transactions_current table displays the current status of the most recent monitored transaction event on the ...For example, the events_transactions_history and events_transactions_history_long tables are collections of the most recent transaction events that have ended, up to a maximum number of rows per thread and globally across all threads, ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. After upgrading to MySQL 8.0.29, the format of the mysqld-auto.cnf option file remains the same until the ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
When a suspicion times out, the suspected member is assumed to have failed, and is expelled from the group. From MySQL 8.0.21, a waiting period of 5 seconds is added before the suspicion times out and the suspected member is liable for expulsion. If ... Group Replication's failure detection mechanism is designed to identify group members that are no longer communicating with the group, and expel them as and when it seems likely that they have ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
To initiate replication, the binary logs required for the recipient to catch up to the donor must not be purged between the time that the data is cloned and the time that replication is started. In addition to cloning data, a cloning operation ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 | MASTER_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10 | MASTER_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. This feature ensures that the replica stays ...Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT | MASTER_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO | CHANGE MASTER TO ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition prevents merging and takes precedence over the derived_merge value. This is true ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...