Search Results
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-query-analyzer-ref.html
Tmp Disk Tables The total number of internal on-disk temporary tables created by occurrences of the statement. Tmp Tables The total number of internal in-memory temporary tables created by occurrences of the statement. Each row within the table ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The following table illustrates the differences between CHAR and VARCHAR by showing ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. The majority of the time the system does not run into partitioning, and therefore ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. InnoDB tables arrange your data on disk to optimize queries based on primary keys. Each InnoDB table ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
This repository is created by default as an InnoDB table named mysql.slave_relay_log_info. DML transactions and also atomic DDL update the replication positions in the replica's applier metadata repository in the mysql.slave_relay_log_info table ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
You must therefore set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The process of creating the replication user for distributed recovery can be captured in ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage engine. Options that can be used with ndbd are shown in the following table. An initial start erases ...This data node process enables a data node to accomplish distributed transaction handling, node recovery, checkpointing to disk, online backup, and related ...