https://dev.mysql.com/server-system-variables.html
Most of them can be changed dynamically at runtime using the SET statement, which enables you to modify operation of the server without having to stop and restart it. Setting a global system variable runtime value normally requires the ... The MySQL ...
https://dev.mysql.com/point-in-time-recovery.html
Point-in-time recovery refers to recovery of data changes made since a given point in time. Typically, this type of recovery is performed after restoring a full backup that brings the server to its state as of the time the backup was made. (The ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
There are many parameters which control buffer sizes, pool sizes, timeouts, and so forth. It is read only when the cluster is started for the first time, and cannot be used to reassign a data node to a different node group online. You are not ...
https://dev.mysql.com/point-in-time-recovery-positions.html
Instead of specifying dates and times, the --start-position and --stop-position options for mysqlbinlog can be used for specifying log positions. Using positions may enable you to be more precise about which part of the log to recover, especially ...They work the same as the start and stop date options, except that you specify log position numbers rather than ...
https://dev.mysql.com/group-replication-recovering-from-a-point-in-time.html
To synchronize the server joining the group with the donor up to a specific point in time, the server joining the group and donor make use of the MySQL Global Transaction Identifiers (GTIDs) mechanism. However, GTIDS only provide a means to realize ...This is the job of binary log view markers, which mark view changes in the binary log stream, and also contain additional metadata information, provisioning the server joining the group with missing certification related ...
https://dev.mysql.com/server-error-reference.html
You can increase the value of the innodb_lock_wait_timeout configuration option if SQL statements should wait longer for other transactions to complete, or decrease it if too many long-running transactions are causing locking problems and reducing ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/mysql-cluster-options-variables.html
Controls whether or not constraint checks on unique indexes are deferred until commit time, where such checks are supported. Because --ndb-log-empty-epochs=1 causes the size of the ndb_binlog_index table to increase independently of the size of the ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/mysql-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). If your system does not have a zoneinfo database, you can use the ...
https://dev.mysql.com/fractional-seconds.html
MySQL 8.0 has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/innodb-parameters.html
Many system variables can be changed at runtime (see Section 5.1.9.2, “Dynamic System Variables”). The --innodb-status-file option is intended for temporary use, as SHOW ENGINE INNODB STATUS output generation can affect performance, and the ...
