PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
If you want to set a different default for the X Plugin socket file at compile time, use the MYSQLX_UNIX_ADDR compile option. The MYSQLX_UNIX_PORT environment variable can also be used to set a default for the X Plugin socket file at server startup ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
To detect this condition, you can set up a handler for it or for a NOT FOUND condition. statement can be a simple statement such as SET var_name = value, or a compound statement written using BEGIN and END (see Section 13.6.1, “BEGIN ... It can ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
However, a user that requires an SSL connection must have been created before the server joining the group connects to the donor. new_member> SET GLOBAL group_replication_recovery_use_ssl=1; new_member> SET GLOBAL group_replication_recovery_ssl_ca= ...Configuring SSL for Group Replication Recovery Recovery is performed through a regular asynchronous replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
InnoDB performs row-level locking in such a way that when it searches or scans a table index, it sets shared or exclusive locks on the index records it encounters. A SPATIAL index contains minimum bounding rectangle (MBR) values, so InnoDB enforces ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
Example: To enable audit logging only for the user1 and user2 local host accounts, set the audit_log_include_accounts system variable like this: SET GLOBAL audit_log_include_accounts = 'user1@localhost,user2@localhost'; Only one of ...The value for ...For example, to log all statement events but only failed connection events, use these settings: SET GLOBAL audit_log_statement_policy = ALL; SET GLOBAL audit_log_connection_policy = ERRORS; Another policy system variable, audit_log_policy, is available but does not afford as much control as audit_log_connection_policy and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
(You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are additional constraints on setting it; see the description of MaxNoOfExecutionThreads for more ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
This example creates a 2,048-bit DSA private key, then derives a public key from the private key: SET @priv = create_asymmetric_priv_key('DSA', 2048); SET @pub = create_asymmetric_pub_key('DSA', @priv); For an example showing DH key generation, see ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, OPTIMIZE TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. The table and indexes ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an error occurs). SET autocommit disables or enables the default autocommit mode for the current session. To disable ...