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/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. It is therefore imperative that you back up your data before starting the upgrade process. If your MySQL installation contains a ...The only supported alternative is to restore a backup taken before ...Important Downgrade from MySQL 8.0 to MySQL 5.7, or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-concepts.html
During backup, each node saves these three parts into three files on disk: BACKUP-backup_id.node_id.ctl A control file containing control information and metadata. BACKUP-backup_id-0.node_id.data A data file containing the table records, which are ... A backup is a snapshot of the database at a given ...Following the list of records ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-package-integrity.html
After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. There are three means of integrity checking: MD5 checksums Cryptographic signatures using ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
Server plugins must be loaded into the server before they can be used. Installing Plugins Controlling Plugin Activation State Uninstalling Plugins Plugins and Loadable Functions Installing Plugins Before a server plugin can be used, it must be ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was away. To enable this method of state transfer, you must install the clone plugin ...The joining member begins by checking the relay log for its group_replication_applier channel for any transactions that it already received from the group but did not yet ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-first-start.html
Each cluster node process must be started separately, and on the host where it resides. Note The IP address shown for a given NDB Cluster SQL or other API node in the output of SHOW is the address used by the SQL or API node to connect to the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). The disadvantage of this is that you must ensure that your statements always refer to your database and ... In MySQL, databases correspond to directories within the data ...One notable exception is macOS, which is Unix-based ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. --core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...--connect-retries ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
The reason for this is that this table must work like a data file that would never be written to by anything other than the database system. The following items indicate features that the FEDERATED storage engine does and does not support: The ...