Search Results
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/internals/en/custom-engine-overview.html
The MySQL server is built in a modular fashion: The storage engines manage data storage and index management for MySQL. Once a handler instance is created, the MySQL server issues commands to the handler to perform data storage and retrieval tasks ...The MySQL server communicates with the storage engines through a defined ...
https://dev.mysql.com/doc/internals/en/generating-browsable-binary-log-information.html
These commands create a subdirectory named html containing the HTML output: shell> doxygen -g shell> doxygen To view the top-level index page, load the html/index.html file into your browser. For example, to navigate from index.html to ... Source ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or join. It is defined as follows: ha_rows ...The *min_key ...
https://dev.mysql.com/doc/internals/en/implementing-the-rnd-next-method.html
As with the index_read() method, the storage engine must return the row that matches the key according to the find_flag and set a cursor for future reads.
https://dev.mysql.com/doc/internals/en/innodb-infimum-and-supremum-records.html
InnoDB sets up an infimum record and a supremum record automatically in the root page when an index is first created, and never deletes them. The infimum and supremum records can be considered part of the overhead of an index page. Initially, they ... “Infimum” and “Supremum” are mathematical terms that refer to the outer bounds of an ordered ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
In both cases we have a WHERE clause as input: the range access method needs index ranges (that is, intervals) to scan; partition pruning module needs partitioning intervals so that it can determine which partitions should be used. For range access, ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...