MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 132 total results

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

See Section 19.4.6, “Replicating Different Databases to Different Replicas” As the number of replicas increases, the load on the source can increase and lead to reduced performance (because of the need to replicate the binary log to each ...

15.6.7.4 RESIGNAL Statement

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

RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...

15.7.7.35 SHOW REPLICA STATUS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html

Any changes, including NTP updates, can lead to clock skews that can make calculation of Seconds_Behind_Source less reliable. SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of ...

2.8.7 MySQL Source-Configuration Options

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html

Overriding them can lead to unexpected results and is done at your own risk. The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For ...

2.8 Installing MySQL from Source

https://dev.mysql.com/doc/refman/8.0/en/source-installation.html

Warning Building MySQL with nonstandard options may lead to reduced functionality, performance, or security. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. For a ...

27.7 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

Mixed format binary logging (binlog_format=MIXED) uses statement-based binary logging, except for cases where only row-based binary logging is guaranteed to lead to proper results. The binary log contains information about SQL statements that ...

10.9.2 Switchable Optimizations

https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html

The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...

7.6.3.3 Thread Pool Operation

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html

These would lead to all resources used by only a few statements and they could prevent all others from accessing the server. The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections ...

27.9 Restrictions on Views

https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html

That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It ...

14.20.3 Window Function Frame Specification

https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html

The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...

Displaying 121 to 130 of 132 total results