https://dev.mysql.com/performance-schema.html
The PERFORMANCE_SCHEMA storage engine collects event data using “instrumentation points” in server source code. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these ...
https://dev.mysql.com/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. MySQL provides support ...
https://dev.mysql.com/recovery-from-backups.html
The full backup file is just a set of SQL statements, so restoring it is very easy: shell> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its state as of Sunday 1 p.m.. | mysql For more information about using mysqlbinlog to ... Now, suppose that we have a catastrophic crash on Wednesday at 8 ...
https://dev.mysql.com/replication-administration-pausing.html
Stopping only the I/O thread enables the events in the relay log to be executed by the SQL thread up to the point where the relay log ends. This can be useful when you want to pause execution to catch up with events already received from the master, ... You can stop and start replication on the slave using the STOP SLAVE and START SLAVE ...
https://dev.mysql.com/replication-mode-change-online-enable-gtids.html
If you use binary logs for anything other than replication, for example point in time backup and restore, wait until you do not need the old binary logs having transactions without GTIDs. This section describes how to enable GTID transactions, and ...
https://dev.mysql.com/replication-options-binary-log.html
Transactions are written to the binary log at the point when all the storage engines involved have confirmed that the transaction is prepared to commit. If you are using GTIDs for replication, this means that even when binary logging is later ...
https://dev.mysql.com/replication-options-gtids.html
If gtid_next=AUTOMATIC is used for the session, gtid_owned is only populated briefly during the execution of the commit statement for the transaction, so it cannot be observed from the session concerned, although it will be listed if ... The MySQL ...
https://dev.mysql.com/replication-options-slave.html
At a later point in time, we execute DELETE FROM a.t. This variable works in combination with the slave_checkpoint_period system variable in such a way that, when either limit is exceeded, the checkpoint is executed and the counters tracking both ...
https://dev.mysql.com/replication-rbr-safe-unsafe.html
In addition, statements using results from floating-point math functions—which are hardware-dependent—are always considered unsafe (see Section 17.5.1.12, “Replication and Floating-Point Values”). The “safeness” of a statement in MySQL ...
https://dev.mysql.com/replication-rules-table-options.html
Having reached this point, if there are no table options, the slave simply executes all events. The starting point is the end of the evaluation of the database-level options, as described in Section 17.2.5.1, “Evaluation of Database-Level ... The ...
