PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. When a full-text index is dropped, the FTS_DOC_ID column that was created for the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
The NAME column displays the system-generated name for the temporary table, which is prefixed with “#sql”. The number of columns (N_COLS) is 4 rather than 1 because InnoDB always creates three hidden table columns (DB_ROW_ID, DB_TRX_ID, and ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
With a nonconstant initializer argument (such as a column name), the seed is initialized with the value for each invocation of RAND(). One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
The MRR optimization is not supported with secondary indexes created on virtual generated columns. When MRR is used, the Extra column in EXPLAIN output shows Using MRR. Reading rows using a range scan on a secondary index can result in many random ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
Can indexed columns be encrypted? InnoDB data-at-rest encryption supports all indexes transparently. The master encryption key is generated when tablespace encryption is enabled, and is stored outside the database. The master encryption key is ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
The following options are used to generate and update the statistics tables in the NDB kernel. ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. This includes cache version and age, number of index entries ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
If there is a row in A that matches the WHERE clause, but there is no row in B that matches the ON condition, an extra B row is generated with all columns set to NULL. For a LEFT JOIN, if the WHERE condition is always false for the generated NULL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
These limits primarily apply if you intend to create an index on a value column to run report-generating queries on that column using SQL. loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
See Section 4.5.3, “mysqlcheck — A Table Maintenance Program”, Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”, and Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”. Also, the code in the ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...