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/blackhole-storage-engine.html
(See Section 16.1.6, “Replication and Binary Logging Options and Variables”.) This filtered log is provided to the replica. This type of setup can be repeated with additional replication replicas. This should be borne in mind when considering ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. This command invokes mysql without specifying any explicit connection parameters: mysql Because ...For additional information if you are unable to connect, see Section 6.2.17, “Troubleshooting Problems Connecting to ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) ...The first example shows a simplified procedure such as you might use from the command ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
This means that, for a query that cannot use any indexes and so requires a full table scan, the server fetches all rows from the remote table and filters them locally. This occurs regardless of any WHERE or LIMIT used with this SELECT statement; ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
This creates a set of challenges that raise complexity of such systems to a whole different level. This can be summarized as having servers reaching agreement on each database state transition, so that they all progress as one single database or ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
This critical component in Group Replication is fault tolerant and configurable. This way there is a good chance that the same server is not selected more than once when multiple members enter the group. This behavior was extended to also cover ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
This is the type of operation on the associated table for which the trigger activates. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. This is a TIMESTAMP(2) value (with a ...To ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
Example 14.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate count of pages that contain system data by excluding pages where the TABLE_NAME value is either NULL or includes a slash / or period . The ... The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
This section describes how to set up the daemon_memcached plugin on a MySQL server. Because the memcached daemon is tightly integrated with the MySQL server to avoid network traffic and minimize latency, you perform this process on each MySQL ...