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/group-replication-system-variables.html
Important A number of system variables for Group Replication are not completely validated during server startup if they are passed as command line arguments to the server. During and between auto-rejoin attempts, a member remains in super read only ...Some system variables on a Group Replication group member, including some Group Replication-specific system variables and some general system variables, are group-wide configuration ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
--ndb-deferred-constraints=[0|1] Command-Line Format --ndb-deferred-constraints System Variable ndb_deferred_constraints Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 Controls ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...For NDB Cluster configuration ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there ...The DATE type is used for values with a date part but no time ...This section ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If you disable binary logging, either omit these options, or specify --log-slave-updates=OFF and --skip-slave-preserve-commit-order. To specify more than one database, use this option multiple times, once for each database; however, doing so does ...
https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html
For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates specified with ambiguous year values using these rules: Year values in the range 00-69 become 2000-2069. Date values with 2-digit years are ambiguous because the century is unknown. To ...Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on. This tool provides high performance for ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
The column_list used in the COLUMNS clause may contain only names of columns; each column in the list must be one of the following MySQL data types: the integer types; the string types; and time or date column types. If the NO_ZERO_DATE or ...If you ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
REPLICATION SLAVE Enables the account to request updates that have been made to databases on the replication source server, using the SHOW REPLICAS (or before MySQL 8.0.22, SHOW SLAVE HOSTS), SHOW RELAYLOG EVENTS, and SHOW BINLOG EVENTS statements.
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
For example, use these lines in the server option file: [mysqld] default_authentication_plugin=mysql_native_password That setting enables pre-8.0 clients to connect to 8.0 servers until such time as the clients and connectors in use at your ...Our ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
--sql-mode=value[,value[,value...]] Command-Line Format --sql-mode=name System Variable sql_mode Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Set Default Value ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ...