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/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. For example: CREATE ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
WKB uses 1-byte unsigned integers, 4-byte unsigned integers, and 8-byte double-precision numbers (IEEE 754 format). Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--query=# Command-Line Format --query=# Type Numeric Default Value 0 Minimum Value 0 Maximum Value MAX_INT Perform random range queries on first key attribute (must be int unsigned). ndb_index_stat provides per-fragment statistical information ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
If the table already has a primary key on some longer column, such as a VARCHAR, consider adding a new unsigned AUTO_INCREMENT column and switching the primary key to that, even if that column is not referenced in queries. A 4-byte unsigned INT ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
Parameters in_connection_id BIGINT UNSIGNED: The ID of the connection for which to return the thread ID. Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is ...