MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 41 to 50 of 58 total results

https://dev.mysql.com/doc/refman/9.7/en/batch-mode.html

Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. In the previous sections, you used mysql interactively to enter ...

A.14 MySQL 9.7 FAQ: Replication

https://dev.mysql.com/doc/refman/9.7/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 ...

7.1.16 Resource Groups

https://dev.mysql.com/doc/refman/9.7/en/resource-groups.html

(Perhaps batch jobs assigned to the group should run at lower priority during the day and at higher priority during the night.) The DBA can also adjust the set of CPUs available to the group. MySQL supports creation and management of resource ...

19.4.1.1 Backing Up a Replica Using mysqldump

https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-mysqldump.html

Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html

Regardless of how the server was built, the default value is 300 milliseconds, and the maximum possible value is 4294967295 milliseconds (approximately 49.7 days). This section explains the server options and system variables that apply to replica ...

19.4.11 Delayed Replication

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/purge-binary-logs.html

PURGE BINARY 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 (see Section ...

29.4.1 Performance Schema Event Timing

https://dev.mysql.com/doc/refman/9.7/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 ...

29.12.13.5 The temporary_account_locks Table

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-temporary-account-locks-table.html

PASSWORD_LOCK_TIME Lock time, in days, as defined in the password locking policy. The temporary_account_locks table lists the users with temporarily locked accounts. The temporary_account_locks table has these columns: USER The user name of the ...

Displaying 41 to 50 of 58 total results