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/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...Important ...
https://dev.mysql.com/doc/refman/8.0/en/xa.html
For example, when a Transaction Manager finds that a global transaction consists of only one transactional resource (that is, a single branch), that resource can be told to prepare and commit at the same time. This document is published by The Open ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
A session that has autocommit enabled can perform a multiple-statement transaction by starting it with an explicit START TRANSACTION or BEGIN statement and ending it with a COMMIT or ROLLBACK statement. A COMMIT or ROLLBACK statement ends the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...If a table ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-configuration-overview.html
All tables include the data type for the parameter, option, or variable, as well as its default, minimum, and maximum values as applicable. For node parameters, these tables also indicate what type of restart is required (node restart or system ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-privilege-synchronization.html
NDB 8.0 introduces a new mechanism for sharing and synchronizing users, roles, and privileges between SQL nodes connected to an NDB Cluster. A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO ...Whenever an ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-redo-log-reader.html
ndb_redo_log_reader is intended for use primarily by NDB Cluster developers and Support personnel in debugging and diagnosing problems. This utility remains under development, and its syntax and behavior are subject to change in future NDB Cluster ... Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. Statement-based replication depends on ...If you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
The database that is checked for a match depends on the binary log format of the statement that is being handled. The statement is not executed until all table-level options (if any) have also been checked, and the outcome of that process permits ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
The default is OFF; that is, the manager thread for ordinary connections on the main interface also handles connections for the administrative interface. These lines in the server my.cnf file enable the administrative interface on the loopback ...