PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Modifying the default behavior in most cases can actually decrease effectiveness. Do not ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
The WKB type is a code that indicates the geometry type. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
row *************************** Level: Note Code: 1276 Message: Field or reference 't3.t2.c1' of SELECT #2 was resolved in SELECT #1 Left outer join: mysql> EXPLAIN FORMAT=TREE SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c1\G ... By default, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/history.html
This API was designed to enable third-party code that was written for use with mSQL to be ported easily for use with MySQL. We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
The POS value for a virtual generated column encodes the column sequence number and ordinal position of the column. PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
Each monitor represents a point within the InnoDB source code that is instrumented to gather counter information. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
SOURCE_FUNCTION, SOURCE_FILE, and SOURCE_LINE Information indicating where in the source code the profiled state executes. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
For InnoDB-specific tuning techniques you can apply to your MySQL server and application code, see Section 10.5, “Optimizing for InnoDB Tables”. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware ...