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/source-configuration-options.html
If disabled, the operation produces multiple installation package files, which may be useful if you want to install only a subset of a full MySQL installation. This location cannot be set at server startup, but you can start the server with a given ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
Additional Resources Example showing how to add a collation for full-text searches: Section 12.9.7, “Adding a User-Defined Collation for Full-Text Indexing” The Unicode Collation Algorithm (UCA) specification: ... A collation is a set of rules ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
For example, to disable InnoDB mutex wait event instruments related to full-text search, add the following rule: performance-schema-instrument='wait/synch/mutex/innodb/fts%=OFF' Note Rules with a longer prefix such as wait/synch/mutex/innodb/fts% ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
When the MySQL server starts on Windows, it looks for option files in several locations, such as the Windows directory, C:\, and the MySQL installation directory (for the full list of locations, see Section 4.2.2.2, “Using Option Files”). If ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
Support for variable-length data types (including BLOB and TEXT) not supported by MEMORY. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
The NDB storage engine does not support FULLTEXT indexes, which are possible for MyISAM and InnoDB tables only. You cannot create indexes on NDB table columns that use any of the TEXT or BLOB data types. Using nullable columns in unique keys and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
The statement event tables (events_statements_current, events_statements_history, and events_statements_history_long) have columns for storing normalized statement digests and the corresponding digest MD5 hash values: DIGEST_TEXT is the text of the ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/5.7/en/json.html
When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The space required to store a JSON document is roughly the same as for LONGBLOB or LONGTEXT; see Section 11.7, ...The ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. To represent these in your text file, use \N (backslash, ...