Search Results
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
If B2 is a regular join buffer, each row r put into B2 is composed of the columns of a row r1 from B1 and the interesting columns of a matching row r2 from table t3. When these operations are executed with a join buffer, each row put into the buffer ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
With this function active, if the primary that is replicating goes offline or into an error state, the new primary starts replication on the same channel when it is elected. After loading the snapshot into the replica to synchronize it with the ...] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This is more reliable than using MD5 checksums, but requires more work. GnuPG is an Open Source alternative to the well-known Pretty Good ...
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
Components must be loaded into the server before they can be used. The SQL statements for component manipulation affect server operation and the mysql.component system table as follows: INSTALL COMPONENT loads components into the server. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
It resolves this issue as follows: Whenever the server reads the user table into memory, it sorts the rows. +-----------+----------+- When the server reads the table into memory, it sorts the rows using the rules just described. When you attempt to ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT TO_DAYS(950501); -> 728779 mysql> SELECT TO_DAYS('2007-10-07'); -> 733321 TO_DAYS() is not intended for use with values that precede the advent of the Gregorian calendar (1582), because it does not take into account the days that were ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The following means are available to influence whether the optimizer attempts to merge derived tables, view references, and common table expressions into the outer query block: The MERGE and NO_MERGE optimizer hints can be used. The optimizer ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
However, if a row becomes larger, it is split into as many pieces as are required, resulting in row fragmentation. More difficult than static-format tables to reconstruct after a crash, because rows may be fragmented into many pieces and links ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? Yes, the binaries have SSL enabled for client/server ...Where can I find documentation that addresses security issues for MySQL? ...