Rechercher dans le manuel MySQL
Search Results
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/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 ...
https://dev.mysql.com/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...At some later point, prior to restoring the cluster, make a backup of the mysql.ndb_binlog_index ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-time-p-2.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
