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-rbr-usage.html
This section describes known issues when using a row-based format log, and describes some best practices using it in replication. Depending on the engine used for the replica's copy of the table, this may or may not be effective. This can ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. For this ... On ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
FIRST_DOC_ID The first document ID in which this word appears in the FULLTEXT index. LAST_DOC_ID The last document ID in which this word appears in the FULLTEXT index. DOC_COUNT The number of rows in which this word appears in the FULLTEXT index.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. FIRST_DOC_ID The first document ID in which this word appears in the FULLTEXT index. Before ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
To obtain details about the lock, join this column with the LOCK_ID column of the INNODB_LOCKS table. To obtain details about the thread, join this column with the ID column of the INFORMATION_SCHEMA PROCESSLIST table, but see Section 14.16.2.3, ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
Simple LDAP Authentication (Without Proxying) The procedure outlined in this section requires that authentication_ldap_simple_group_search_attr be set to an empty string, like this: SET GLOBAL.authentication_ldap_simple_group_search_attr=''; ...This ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
mysqld_multi searches for groups named [mysqldN] in my.cnf (or in the file named by the --defaults-file option). This number is referred to in the following discussion as the option group number, or GNR. Option files read are searched for ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...