PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/data-dictionary-file-removal.html
.isl files: InnoDB Symbolic Link files containing the location of file-per-table tablespace files created outside of the data directory. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables. With ... In previous MySQL releases, dictionary data was partially stored in metadata ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). row ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
PartitionsPerNode: Determines the number of table partitions created on each data node; not used if ClassicFragmentation is enabled. ClassicFragmentation: When true, use traditional table fragmentation; set false to enable flexible distribution of ...Parameters Introduced in NDB 8.0 The following node configuration parameters have been added in NDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples-compression-sect.html
Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...The ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. If you want to check a table, you should normally run myisamchk without options or with the -s (silent) option. This may take a long time for a ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data.html
NDB Cluster supports storing nonindexed columns of NDB tables on disk, rather than in RAM. Column data and logging metadata are kept in data files and undo log files, conceptualized as tablespaces and log file groups, as described in the next ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-blocks.html
The blocks table is a static table which simply contains the names and internal IDs of all NDB kernel blocks (see NDB Kernel Blocks). It is for use by the other ndbinfo tables (most of which are actually views) in mapping block numbers to block ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. Together with the block name, this number can be used to look up a given instance in the threadblocks table. You can use this along with the block ...