PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. You can use OPTIMIZE TABLE to analyze the table and pack it into a smaller format (for a reason to use OPTIMIZE TABLE, see ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
Searches for ligatures also match uppercase ligatures when using the gb18030_unicode_520_ci collation. Use this collation if you need to ensure that ligatures are sorted correctly. In MySQL, the gb18030 character set corresponds to the “Chinese ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. InnoDB performs row-level locking ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
Phone numbers can be given in very different formats: +7-12345-67 +7-12-345-67 +7 12 345 67 +7 (12) 345 67 +71234567 The problem raised by dealing with these kinds of values is that the varying permissible formats make searching for a specific phone ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
If you set this option on a server s1, then when server s2 is establishing a connection to s1 for the purpose of engaging group communication, s1 first checks the allowlist before accepting the connection from s2. This address is not the same as the ... The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be ...