Search Results
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-markers.html
These markers can be used in any template, including custom templates. Using the table The table shows which variables are defined in which sections. The variable should be used in its correct section or its value will not be displayed. If a ...
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
index: a sequential scan on an index ALL: a sequential scan of the entire table See: /sql/sql_select.h, enum join_type{}. For example, consider this query: SELECT * FROM Table1 WHERE indexed_column = 5 AND unindexed_column = 6 Since indexed_column ... When evaluating a conditional expression, MySQL decides what join type the expression ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb.html
(See Section 2.3.12, “The Ndb_cluster_connection Class”.) catalogName is an optional parameter providing a namespace for the tables and indexes created in any connection from the Ndb object. The optional schemaName provides an additional ...
https://dev.mysql.com/doc/ndbapi/en/ndb-object.html
This section provides information about the Object class, which contains meta-information about database objects such as tables and indexes. Description This parameter specifies how data in the table or index is distributed among the cluster's data ...The larger the table, the larger the number of fragments that should be ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
False hits or misses might occur for stopword lookups if the stopword file or columns used for full-text indexing or searches have a character set or collation different from character_set_server or collation_server. Stopwords for InnoDB Search ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If ordering is done by using ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The term “relay log” collectively denotes the set ...The default location for relay log files is the data ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-fewer-data-nodes.html
This is because if we also try to restore the indexes node by node, they might not be restored in the right order for the foreign keys and unique key constraints to work properly. Sometimes, you want to transfer data from your cluster to another ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
It is used on master replication servers as a record of the statements to be sent to slave servers. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. As this SHOW ...