MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 41 to 50 of 58 total results

https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html

Encryption is supported for the InnoDB FULLTEXT index tables that are created implicitly when adding a FULLTEXT index. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo ...

17.6.2.3 Sorted Index Builds

https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html

Sorted Index Builds and Full-Text Index Support Sorted index builds are supported for fulltext indexes. Previously, SQL was used to insert entries into a fulltext index. InnoDB performs a bulk load instead of inserting one index record at a time ...

10.8.2 EXPLAIN Output Format

https://dev.mysql.com/doc/refman/8.0/en/explain-output.html

In the following examples, MySQL can use a ref join to process ref_table: SELECT * FROM ref_table WHERE key_column=expr; SELECT * FROM ref_table,other_table WHERE ref_table.key_column=other_table.column; SELECT * FROM ref_table,other_table WHERE ...

10.3.13 Descending Indexes

https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html

Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in an error. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.

19.5.1.27 Replication and Row Searches

https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html

When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. The algorithm used to carry out this process uses one of the table's indexes to carry out the search ...

10.2.1.2 Range Optimization

https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html

The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/show-index.html

SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...

Chapter 18 Alternative Storage Engines

https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html

Support for FULLTEXT indexes is available in MySQL 5.6 and later.7. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends ...

15.1.9 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

| ADD {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | ...

15.7.4.6 UNINSTALL PLUGIN Statement

https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html

For example, if a full-text parser plugin is associated with a FULLTEXT index on the table, uninstalling the plugin makes the table unusable. UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE ...

Displaying 41 to 50 of 58 total results