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/fulltext-query-expansion.html
It works by performing the search twice, where the search phrase for the second search is the original search phrase concatenated with the few most highly relevant documents from the first search. Thus, if one of these documents contains the word ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-unix-servers.html
It is also possible to use the same server binary and start each invocation of it with different parameter values at runtime. One way to do so is by using command-line options: $> mysqld_safe --socket=file_name --port=port_number To start a second ... Note The discussion here uses mysqld_safe to launch multiple instances of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-members-table.html
ERROR: The member has encountered an error, either during applying transactions or during the recovery phase, and is not participating in the group's transactions. UNREACHABLE: The failure detection process suspects that this member cannot be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...If binary logging is not enabled, verify that you are running the source server with the --log-bin ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab. If you add a version number after the ! character, the syntax within the comment is ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata lock acquisition order can make a difference in operation outcome when multiple transactions execute concurrently, as the following example illustrates. Lock acquisition order results in the RENAME TABLE executing before the INSERT. In this ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) block_instance refers to an instance of a kernel ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-transactions.html
The server_transactions table is subset of the cluster_transactions table, but includes only those transactions in which the current SQL node (MySQL Server) is a participant, while including the relevant connection IDs. Together with the block ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
(If the option is given multiple times, the last value is used.) Command-Line Format --defaults-extra-file=filename Type File name Default Value [none] For additional information about these and other option-file options, see Section 4.2.2.3, ...