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/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/audit-log-reference.html
Audit Log Functions This section describes, for each audit log function, its purpose, calling sequence, and return value. If this function fails, an error message is returned and the audit log is disabled until the next successful call to ...Unless ...
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/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. Furthermore, given that changes are propagated and applied in row-based format, this means that they ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
This occurs due to heuristic pruning during greedy search, which can be avoided by setting optimizer_prune_level=0. The optimizer uses semijoin strategies to improve subquery execution, as described in this section. To list the classes that actually ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
The following relational comparison operators can be used to compare not only scalar operands, but row operands: = > < >= <= <> != The descriptions for those operators later in this section detail how they work with row operands. Some of the ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...