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-log-statistics.html
A unique index read operation generates 2 primary key read operations—1 for the hidden unique index table, and 1 for the table on which the read takes place. Note A unique index update operation can generate multiple PK read and write operations ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. DiskDataUsingSameDisk: Set to false if Disk Data tablespaces are located on separate physical disks. LateAlloc: Allocate memory after connection to management server has been ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-print-backup-file.html
--table-id Command-Line Format --table-id=# Introduced 8.0.24-ndb-8.0.24 Type Integer Default Value [none] Table ID. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup directory. These files are found in the data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-quick.html
row *************************** Engine: NDBCLUSTER Support: YES Comment: Clustered, fault-tolerant, memory-based tables *************************** 13. Try to create an NDBCLUSTER table: $> mysql mysql> USE test; Database changed mysql> CREATE TABLE ... To familiarize you with the basics, we describe the simplest possible configuration for a functional NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Alternatively, create a shortcut that only sets the console font, and set the character set in the [mysql] group of your my.ini file: [mysql] default-character-set=utf8mb4 # or utf8mb3 Displaying Query Results Vertically Some query results are much ...In cases where a console is shared, this behavior may be ... This section provides information about techniques for ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
This makes PERSIST_ONLY suitable for configuring read-only system variables that can be set only at server startup. The Performance Schema variables_info table contains information showing when and by which user each system variable was most ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code.
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. An alternative is to use the ... Certain ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of GTID auto-positioning and automatic failover, and use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and Performance Schema tables to monitor replicated transactions (see Section 29.12.11, ... Before ...