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/partitioning-types.html
For HASH partitioning, the user-supplied expression must evaluate to an integer value. With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. For example, the events_waits_history and events_waits_history_long ...Of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
The setup_timers table contains a row with a NAME value of statement that indicates the unit for statement event timing. These tables store statement events: events_statements_current: The current statement event for each thread. There are also ...
https://dev.mysql.com/doc/refman/5.7/en/query-log.html
You can also rename the general query log file at runtime by disabling the log: SET GLOBAL general_log = 'OFF'; With the log disabled, rename the log file externally (for example, from the command line). Then enable the log again: SET GLOBAL ...The ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Renaming an index ALTER TABLE tbl_name RENAME INDEX old_index_name TO new_index_name, ALGORITHM=INPLACE, LOCK=NONE; Adding a FULLTEXT index CREATE FULLTEXT INDEX name ON table(column); Adding the first FULLTEXT index rebuilds the table if there is ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...The CREATE INDEX statement only finishes after all transactions ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
Any missing columns are set to their default values, just as happens for INSERT. There are no user-visible effects other than a possible difference in how the storage engine increments Handler_xxx status variables. REPLACE [LOW_PRIORITY | DELAYED] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-user-names.html
The maximum length of MySQL user names was increased from 16 characters to 32 characters in MySQL 5.7.8. Replication of user names longer than 16 characters to a replica that supports only shorter user names fails. However, this should occur only ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. | ...This is generally useful when a search ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
For batched_key_access to have any effect when set to on, the mrr flag must also be on. The derived_merge flag controls whether the optimizer attempts to merge derived tables and view references into the outer query block, assuming that no other ...