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/group-replication-distributed-recovery.html
Distributed recovery can be summarized as the process through which a server gets missing transactions from the group so that it can then join the group having processed the same set of transactions as the other group members. This section ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-multi-primary-mode.html
Figure 17.6 Client Failover All servers are set to read-write mode when joining the group. In multi-primary mode, there is no notion of a single primary. There is no need to engage an election procedure because there is no server playing any ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
In this case, the key column contains a list of indexes used, and key_len contains a list of the longest key parts for those indexes. To enable only certain algorithms, set index_merge to off, and enable only such of the others as should be ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-default-stopword-table.html
This is not used if you override the default stopword processing with either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system variable. For information about the default InnoDB stopword list and how to define your own ... The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/5.7/en/json-functions.html
A set of spatial functions for operating on GeoJSON values is also available. The functions described in this section perform operations on JSON values. For discussion of the JSON data type and additional examples showing how to use these ...
https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html
Applications that perform a lot of memory accesses may obtain performance improvements by using large pages due to reduced Translation Lookaside Buffer (TLB) misses. In MySQL, large pages can be used by InnoDB, to allocate memory for its buffer pool ... Some hardware and operating system architectures support memory pages greater than the default (usually ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-compiling.html
The next line of code tells the compiler to obtain the location of the include files and libraries and other settings for the system on which it is compiled. The correct flags for compiling and linking a threaded program must be used, even if you do ... In precompiled binary MySQL distributions that include libmysqld, the embedded server library, MySQL builds the library using the appropriate vendor compiler if there is ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
Because the MERGE engine cannot enforce uniqueness over the set of underlying tables, REPLACE does not work as expected. The INSERT_METHOD table option for a MERGE table indicates which underlying MyISAM table to use for inserts into the MERGE table. However, use of the AUTO_INCREMENT table option for that MyISAM table has no effect for inserts into the MERGE table until at least one row has been inserted directly into the MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. --check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since ...This is the default operation if you specify no option that selects an operation type ...