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/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. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...The third example describes how to set up SSL files on ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The expire_time_column value is related to the way memcached hashes requests to different servers and caches data in memory. Specify 0 for flags, cas_column, and expire_time_column if they are unused. InnoDB API functions access the InnoDB tables ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. Each matching row is updated once, even if it matches the conditions multiple times. Only the partitions (or ... UPDATE is a DML statement that modifies rows in a ...Each value can be given as an expression, or the ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
Instances then are managed by normal systemd commands, such as: systemctl start mysqld@replica01 systemctl start mysqld@replica02 To enable instances to run at boot time, do this: systemctl enable mysqld@replica01 systemctl enable mysqld@replica02 ...The following discussion covers these topics: Overview of systemd Configuring systemd for MySQL Configuring Multiple MySQL Instances Using systemd Migrating from mysqld_safe to systemd Note On platforms for which systemd support for MySQL is installed, scripts such as mysqld_safe and the System V initialization script are unnecessary and are not ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
Thus, you should expect USE INDEX, FORCE INDEX, and IGNORE INDEX to be deprecated in a future release of MySQL, and at some time thereafter to be removed altogether. These index-level optimizer hints are supported with both single-table and ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
This is simpler and has no side effects, but is not suitable for installations that require minimal server downtime with as few restarts as possible. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
These statements are subject to rewriting: As of MySQL 8.0.12: SELECT, INSERT, REPLACE, UPDATE, and DELETE. When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. Otherwise, the server accepts the connection, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
From MySQL 8.0.27, Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
This is not visible to the NDB kernel, which views these two rows as being the same, and thus has no way of knowing that this update should be cascaded. Keys and indexes on NDB Cluster tables are subject to the following limitations: Column width.