Search Results
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
Unquoted pam_service_name, pam_group_name, and mysql_user_name values can contain anything except equal sign, comma, or space. Assign /etc/group to the shadow group and enable the group read permission: chgrp shadow /etc/shadow chmod g+r /etc/shadow ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
In many cases, the equal sign can be replaced with another arithmetic comparison, including <, >, <=, >=, and <>. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
row *************************** LOGGED: 2020-08-06 09:25:02.936146 THREAD_ID: 0 PRIO: Warning ERROR_CODE: MY-010068 SUBSYSTEM: Server DATA: CA certificate /var/mysql/sslinfo/cacert.pem is self signed. Many Performance Schema tables other than ... Of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
INSTALL PLUGIN plugin_a; The server detects that the 40 instruments are already defined, so no new instruments are created, and previously assigned internal memory buffers are reused. The Performance_schema_mutex_classes_lost status variable is the ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. (In this case, an implicit CAST(? AS derived_type) is performed.) The derived type and ...The prepared statement is executed with EXECUTE and released with DEALLOCATE ...
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. If either server does not support encrypted connections (because it ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
GTID assignment distinguishes between client transactions, which are committed on the source, and replicated transactions, which are reproduced on a replica. When a client transaction is committed on the source, it is assigned a new GTID, provided ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
For more information, see Section 15.7.6.1, “SET Syntax for Variable Assignment”. When set to MINIMAL, the default, only metadata related to SIGNED flags, column character set and geometry types are logged. Setting this variable to OFF prevents ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
NO_UNSIGNED_SUBTRACTION Subtraction between integer values, where one is of type UNSIGNED, produces an unsigned result by default. When NO_UNSIGNED_SUBTRACTION is enabled, the subtraction result is signed, even if any operand is unsigned. The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-auto-increment-columns.html
For example, for a column with a bigint(20) unsigned column type, the data type is just bigint. This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values ...