MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 66 total results

19.1.6.1 Replication and Binary Logging Option and Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html

binlog_expire_logs_auto_purge: Controls automatic purging of binary log files; can be overridden when enabled, by setting both binlog_expire_logs_seconds and expire_logs_days to 0. The following two sections provide basic information about the ...

19.1.4.4 Verifying Replication of Anonymous Transactions

https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html

Or wait for a day, or whatever time period you consider safe for your deployment. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the ...

19.4.11 Delayed Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html

For example, by configuring a replica with a delay of one week, if you then need to see what the database looked like before the last few days' worth of development, the delayed replica can be inspected. MySQL supports delayed replication such that ...

19.4.9.1 Asynchronous Connection Failover for Sources

https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html

Note that the defaults for these options, which were designed for a connection to a single source, make the replica retry the same connection for 60 days. To activate asynchronous connection failover for a replication channel set ...

15.4.1.1 PURGE BINARY LOGS Statement

https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html

PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. The log consists of a set of binary log files, plus an index file ...

29.4.1 Performance Schema Event Timing

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html

Using the cycle counter is much cheaper than getting the actual time of day. For example, the standard gettimeofday() function can take hundreds of cycles, which is an unacceptable overhead for data gathering that may occur thousands or millions of ... Events are collected by means of instrumentation added to the server source ...

14.21 Performance Schema Functions

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html

As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema ...

26.6.3 Partitioning Limitations Relating to Functions

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html

This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...

A.14 MySQL 8.0 FAQ: Replication

https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html

The replica can go down or stay disconnected for hours or even days, and then reconnect and catch up on updates. In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. Must the replica be ...

6.5.4 mysqldump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

You can use --mysqld-long-query-time to specify a session value from 0 (meaning that every query from mysqldump is logged to the slow query log) to 31536000, which is 365 days in seconds. The mysqldump client utility performs logical backups, ...

Displaying 51 to 60 of 66 total results