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/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or debugging. For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 12.9.6, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. However, the result must be an integer value or NULL (except in the case of [LINEAR] KEY partitioning, as discussed elsewhere in this chapter; see Section ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-advantages.html
This makes MERGE indexes much slower on eq_ref searches, but not much slower on ref searches. A MERGE table structured this way could be much faster than using a single large table. If you know exactly what you are looking for, you can search in ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted constructs in filter definitions. The preceding definition can be written like this: { "filter": ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. Options ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
This is the same as the value returned by the CONNECTION_ID() function within the session. Example: <DB>test</DB> For connect events, this element indicates the default database; the element is empty if there is no default database. This is the same ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
This information is stored in the form of “events” that describe the modifications. This can result in different data on source and replica, or cause restored data to differ from the original data. This section describes how MySQL handles binary ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. This means ...The core concept behind partition pruning is relatively simple, and can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into ...The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table ...