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/mysql-cluster-limitations-transactions.html
This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB or TEXT columns. To avoid modification of the index during this double-read operation, the row found in the hidden index table is locked. This ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See also Section 16.4.1.8, “Replication of CURRENT_USER()”.) This is also true for VERSION() and RAND(). This means that the value as returned by the call to this function on the source is replicated to the replica. For this reason, if you ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
If this is true of the statement, we refer to the statement as safe; otherwise, we refer to it as unsafe. However, certain nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered unsafe, later in this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
This section describes the impact of an unexpected halt of a replica during replication, and how to configure a replica for the best chance of recovery to continue replication. In older MySQL Server versions, this repository could only be created as ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
It starts by pushing a diagnostics area to the top of the stack, which now looks like this: DA 1. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. SET is ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and monitored. This option is available only if the validate_password plugin has been previously ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in Section 16.1.3.7, “Stored Function Examples to Manipulate GTIDs”. For Group Replication, this includes both transactions ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. If the connection between the client and the server goes through an untrusted network, and ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
1) Try to use constant lookup values for database and table names in the WHERE clause You can take advantage of this principle as follows: To look up databases or tables, use expressions that evaluate to a constant, such as literal values, functions ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. The Transportable Tablespaces ...