PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a FEDERATED table points to must exist before you try to access the table through the ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
For an example specific to full-text indexing, see Section 12.9.7, “Adding a User-Defined Collation for Full-Text Indexing”. Rebuilding InnoDB Full-Text Indexes For the changes to take effect, FULLTEXT indexes must be rebuilt after modifying any ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
There is a built-in stopword list, but it can be overridden by a user-defined list. Stopword processing is controlled by the configuration options innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
User lock The thread is going to request or is waiting for an advisory lock requested with a GET_LOCK() call. The following list describes thread State values that are associated with general query processing and not more specialized activities ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
Whenever the size of one of these queues exceeds the user-defined threshold, the throttling mechanism is triggered. The writer quota is enforced by the throttling mechanism if the queue size of the certifier or the binary log applier exceeds a user ... Group Replication ensures that a transaction only commits after a majority of the members in a group have received it and agreed on the relative order between all transactions that were sent ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. In MySQL, databases correspond to directories within the data directory. Each table ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
A user variable cannot be used directly in an SQL statement as an identifier or as part of an identifier. See Section 9.4, “User-Defined Variables”, for more information and examples of workarounds. Certain objects within MySQL, including ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The VALUE column is empty if there is no user-defined stopword table. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
DEFINER The account named in the DEFINER clause (often the user who created the routine), in 'user_name'@'host_name' format. Notes To see information about a routine, you must be the user named in the routine DEFINER clause or have SELECT access to ... The ROUTINES table provides information about stored routines (stored procedures and stored ...