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/optimize-overview.html
In practice, the advanced InnoDB performance features mean that InnoDB tables often outperform the simpler MyISAM tables, especially for a busy database. The InnoDB storage engine handles most locking issues without involvement from you, allowing ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
If the remote cloning operation starts but does not complete, the joining member might be left with a partial set of its original data files, or with no user data. In the following situations, Group Replication detects an error in distributed ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are subject to the internal row-size limit of 65,535 bytes, which may cause some attempts at data type changes to fail. MySQL ...Trailing spaces are automatically deleted from ENUM and SET member values when the table is ... In some cases, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
--core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in debugging. --database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
If errors occur while copying data to the table, the table is automatically dropped and not created. The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax error. The data ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON This variable controls how binary log ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. The server creates the file in the data directory unless an absolute path name is given to specify a different directory. The log_timestamps system ...The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database. In this environment, all writes and updates must take place on the source server. Data security - because the replica can ... Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. The alternative SOURCE_LOG_FILE | MASTER_LOG_FILE and SOURCE_LOG_POS | MASTER_LOG_POS ...To ...For full instructions to configure and start sources and replicas using GTID-based replication, see Section 19.1.3.4, “Setting Up Replication Using ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned scans; threads blocked while waiting for the completion of various operations; and data and events sent and ... A ...