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/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning ...
https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
For example, you can insert the geometry return value from Point() directly into a POINT column: INSERT INTO t1 (pt_col) VALUES(Point(1,2)); GeometryCollection(g [, g] ...) Constructs a GeometryCollection value from the geometry arguments. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 4MB. This section also covers the related Lost ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-member-stats.html
To use this table to monitor a Group Replication member, issue the following statement: mysql> SELECT * FROM performance_schema.replication_group_member_stats\G These columns are important for monitoring the performance of the members connected in ... Each member in a replication group certifies and applies transactions received by the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# Introduced 5.7.17 System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes Type Integer Default Value 7 Minimum ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
This hostname can be verified in the Member_host column of the performance_schema.replication_group_members table. Group Replication uses the asynchronous replication protocol to achieve Section 17.9.5, “Distributed Recovery”, synchronizing ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
The 0x notation is based on ODBC, for which hexadecimal strings are often used to supply values for BLOB columns. Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
Check whether the Password column of that table is shorter than 16 characters. If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
B-Tree Index Characteristics Hash Index Characteristics B-Tree Index Characteristics A B-tree index can be used for column comparisons in expressions that use the =, >, >=, <, <=, or BETWEEN operators. WHERE index_part1=1 AND index_part2=2 AND ...