PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
Requirements for Proxy User Support For proxying to occur for a given authentication plugin, these conditions must be satisfied: Proxying must be supported, either by the plugin itself, or by the MySQL server on behalf of the plugin. The account for ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
Each replica must have a unique server ID, as specified by the server_id system variable. If you are setting up multiple replicas, each one must have a unique server_id value that differs from that of the source and from any of the other replicas.
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Representation of metadata must satisfy these requirements: All metadata must be in the same character set. Error messages returned from the server to the client are converted to the client character set automatically, as with metadata. Metadata is ...Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in the same column of the results of these operations would be in different character ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ...The following relational comparison operators can be used to compare not only scalar operands, but row operands: = > < >= <= <> != The descriptions for those operators later in this section detail how they work with row ... Table 14.4 ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
MySQL supports a native JSON data type as defined by RFC 7159, and based on the ECMAScript standard (ECMA-262). Modes affect the SQL syntax MySQL supports and the data validation checks it performs. This makes it easier to use MySQL in different ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
The server maintains histogram statistics about column values in the column_statistics data dictionary table (see Section 10.9.6, “Optimizer Statistics”). Like other data dictionary tables, this table is not directly accessible by users. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays. For example, if you store death date in the database, you can easily calculate how old a pet ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-information-schema.html
Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? A.7.5. Can I add to or otherwise modify the tables found in the ...Where can I ...However, Oracle and MySQL use different table names and column ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
Specifically, replicated databases have to deal with the fact that they require maintenance and administration of several servers instead of just one. Therefore, the ultimate challenge is to fuse the logic of the database and data replication with ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
If you use binary log transaction compression in combination with Group Replication's message compression, message compression has less opportunity to act on the data, but can still compress headers and those events and transaction payloads that are ...Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system ...