Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-worker-table.html
When a replica is restarted by a START REPLICA statement, the columns beginning APPLYING_TRANSACTION are reset. The replication_applier_status_by_worker table has these indexes: Primary key on (CHANNEL_NAME, WORKER_ID) Index on (THREAD_ID) The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-status-table.html
COUNT_RECEIVED_HEARTBEATS The total number of heartbeat signals that a replica received since the last time it was restarted or reset, or a CHANGE REPLICATION SOURCE TO statement was issued. The replication_connection_status table has these indexes: ... This table shows the current status of the I/O thread that handles the replica's connection to the source, information on the last transaction queued in the relay log, and information on the transaction currently being queued in the relay ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
The binary log index file and relay log index file are never encrypted. The SHOW BINARY LOGS statement shows whether each binary log file is encrypted or unencrypted. MySQL binary log files and relay log files can be encrypted, helping to protect ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-refresh.html
REFRESH_MASTER On a source server, remove the binary log files listed in the binary log index and truncate the index file, like RESET BINARY LOGS AND GTIDS. int mysql_refresh(MYSQL *mysql, unsigned int options) Description Note mysql_refresh() is ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-components.html
SQL statements: INSTALL PLUGIN registers a plugin in the mysql.plugin table and loads the plugin code. The WITH PARSER clause for full-text index creation associates a full-text parser plugin with a given FULLTEXT index. UNINSTALL PLUGIN unregisters ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab and adding or editing a foreign key is similar to adding or editing an index. Enter a name for the foreign key and select the column or columns that you wish to ...
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
PAGE_BTR_SEG_LEAF and PAGE_BTR_SEG_TOP: These variables contain information (space ID, page number, and byte offset) about index node file segments. The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
This buffer is used only when the join is of type ALL or index (in other words, when no possible keys can be used). A join buffer is never allocated for the first non-const table, even if it would be of type ALL or index. Accepted row combinations ... Basic information about the join buffer cache: The size of each join buffer is determined by the value of the join_buffer_size system ...
https://dev.mysql.com/doc/internals/en/optimizer-or-relations.html
There is also an option to use index merge under such circumstances. See Section 7.2.2.5.2, “Index Merge Optimizer” and Index Merge Optimization, for more information. For example: WHERE column1 = 'x' OR column1 = 'y' In such a case, the search ... An ORed search has the form condition1 OR condition2, as in this example: WHERE column1 = 'x' OR column2 = 'y' Here the optimizer's decision is to use a sequential ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
Notes: Extra indexes still must follow the rules for indexes - see below. In addition to what we guarantee in (P-rpl-correct), we also guarantee correct replication in the following scenarios: (P-rpl-different-file-system-case-sensitivities) TODO: ...