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/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. This optimzation is performed by default whenever the optimizer determines that using it would allow for faster execution of the query. Because the algorithm that makes this ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
This might result in quicker lock release than the MERGE algorithm so that other clients that use the view are not blocked as long. In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
This document is published by The Open Group and available at http://www.opengroup.org/public/pubs/catalog/c193.htm. In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature-windows.html
Type "Mysql Release Engineering" into the search box and press Search. An import dialog is displayed; choose Okay, and this certificate should now be listed under the Imported Certificates tab. This requires files for both the packaged file, and the ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
There are some exceptions to this behavior for InnoDB tables, as discussed in Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”. In this case, reuse of values deleted from the top of the sequence occurs even for MyISAM tables. This affects ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
This means such names are not case-sensitive in Windows, but are case-sensitive in most varieties of Unix. The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section. The following statement would not work on Unix, because it refers to the alias both as a and as A: mysql> SELECT col_name FROM tbl_name AS a WHERE a.col_name = 1 OR A.col_name = 2; However, this same statement is permitted on ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text processing. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------------------+ ... The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB ...
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. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
Based on the observed pattern of searches, a hash index is built using a prefix of the index key. The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient ...