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/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
DML transactions and also atomic DDL update the replication positions in the replica's applier metadata repository in the mysql.slave_relay_log_info table together with applying the changes to the database, as an atomic operation. In all other ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
Log Control at Server Startup Log Control at Runtime Log Table Benefits and Characteristics Log Control at Server Startup The log_output system variable specifies the destination for log output. Log Control at Runtime The system variables associated ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE TABLE with the UPDATE HISTOGRAM clause generates histogram statistics for the named table columns and stores them in the data dictionary. These histogram operations are available: ANALYZE TABLE with an UPDATE HISTOGRAM clause generates ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a program. Most MySQL programs can read startup options from option files (sometimes called configuration ...To determine whether a program reads option files, invoke it with the --help ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-binary.html
For management nodes and data nodes, it is not necessary to install the MySQL Server binary; however, each management node requires the management server daemon (ndb_mgmd.exe); each data node requires the data node daemon (ndbd.exe or ndbmtd.exe).
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
By default, mysqlbinlog reads binary log files and displays their contents in text format. This enables you to examine events within the files more easily and to re-execute them (for example, by using the output as input to mysql). mysqlbinlog can ...This capability enables you to easily back up a binary log in its original ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
Each namespace has its own IP addresses, network interfaces, routing tables, and so forth. This can produce phenomena such as a client connection from an address in one namespace appearing to the MySQL server to be coming from a different address, ... A network namespace is a logical copy of the network stack from the host ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character units. For definitions of ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable is disabled. If ...CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ...option: { FOR UPGRADE | QUICK | ...