PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
This section describes how to set up a MySQL server to use binary log file position based replication. You need this information when configuring the replica so that the replica knows where in the binary log to start executing events. If you do not ...There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
This section discusses what semisynchronous replication is and how it works. Failover from source to replica in this case might result in failover to a server that is missing transactions relative to the source. If your goal is to implement a ... In ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html
One way to improve the performance of the replication process is to create a deeper replication structure that enables the source to replicate to only one replica, and for the remaining replicas to connect to this primary replica for their ... As ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
Check the notes and hints at the end of this section for Solaris specific notes that you may need before or after installation. (By default mounting is done without this option.) Failing to do so causes a significant drop in performance when using ... Note MySQL 5.7 supports Solaris 11 (Update 3 and ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine instead. This provides a consistent and secure environment, and routines can ensure that each operation is properly logged. A ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
System variables: version_tokens_session Command-Line Format --version-tokens-session=value System Variable version_tokens_session Scope Global, Session Dynamic Yes Type String Default Value NULL The session value of this variable specifies the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
(In older versions of MySQL, manual intervention was required whenever relocating the binary log or relay log files.) (Bug #11745230, Bug #12133) Setting this option causes the log_bin system variable to be set to ON (or 1), and not to the base name. Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
Most of these can also be found in other places in this manual. This section lists environment variables that are used directly or indirectly by MySQL. If this variable is set, its value overrides the default for $HOME/.mysql_history. Options on ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 6.2.11, “Password Management”). For any operation not permitted within the session, the server returns an ER_MUST_CHANGE_PASSWORD error: mysql> ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
Checks against this file format tag are controlled by the configuration parameter innodb_file_format_check, which is ON by default. The ability to set innodb_file_format_check is useful (with future releases) if you manually “downgrade” all of ... To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file ...