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-information-schema-tables.html
The FILES table provides information about NDB Cluster Disk Data files (see Section 25.6.11.1, “NDB Cluster Disk Data Objects”). Additional statistical and other data about NDB Cluster transactions, operations, threads, blocks, and other aspects ...The ndb_transid_mysql_connection_map table provides a mapping between transactions, transaction coordinators, and API ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-directory.html
The result is that MyISAM data and index files are created in the table's database directory. If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
mysqld_db_t is the type associated with the MySQL data directory and its files. SELinux policy modules use SELinux contexts to define rules for how processes, files, ports, and other system objects interact with each other. An SELinux context (the ... Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a security label referred to as an SELinux context to each system ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
With this setting, the contents of the InnoDB redo log buffer are written out to the log file at each transaction commit and the log file is flushed to disk. However, the replica notices the network outage only after receiving no data from the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-configuration-overview.html
When performing a node restart or an initial node restart, all of the cluster's data nodes must be restarted in turn (also referred to as a rolling restart). All tables include the data type for the parameter, option, or variable, as well as its ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
Tell the replica to use the source with GTID based transactions as the replication data source, and to use GTID-based auto-positioning rather than file-based positioning. Instruct the replica to use the source as the replication data source and to ...This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section 19.1.3.5, “Using GTIDs for Failover and ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Hints are permitted in these contexts: At the beginning of query and data change statements: SELECT /*+ ... If a table has an alias, hints must refer to the alias, not the table name. Note To use a block nested loop or batched key access hint to ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
In addition, each element in the value list must be of the same data type as the corresponding element in the column list. A value_list must be supplied for each partition definition, and each value_list must have the same number of values as the ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. The search string must be a string value that ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
When binary log transaction compression is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). However, the effort required for data ...Compressed transaction payloads remain in a compressed state while they are sent in the replication stream to replicas, other Group Replication group members, or clients such as ...