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/information-schema-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
For example: SELECT * FROM t WHERE partial_key=5 AND some_column=RAND(); If the optimizer can use partial_key to reduce the set of rows selected, RAND() is executed fewer times, which diminishes the effect of nondeterminism on optimization. The ...A ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
Note that the maximum supported input size for the LZ4 compression algorithm is 2113929216 bytes. This limit is lower than the maximum possible value for the group_replication_compression_threshold system variable, which is matched to the maximum ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
(On a case-insensitive file system, both letters are treated as the same.) For some blocks, such as Cyrillic, the second byte determines lettercase. There is a correspondence between database and table identifiers and names in the file system. For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
COUNT_STAR, SUM_TIMER_WAIT, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT These columns aggregate all I/O operations. COUNT_READ, SUM_TIMER_READ, MIN_TIMER_READ, AVG_TIMER_READ, MAX_TIMER_READ These columns aggregate all read operations. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error and ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the ...This method of index creation is also known as a sorted index ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
Specify character settings at configuration time, if you build MySQL from source. If most or all applications use the same character set, specifying character settings at server startup or configuration time may be most convenient. Applications that ... For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
(See Section 6.2.12, “Server Handling of Expired Passwords”.) --connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 0 The number of seconds before connection timeout. If the file does not exist or is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Note This needs to be done only for tables already existing at the time the new node ... In this section, we list the basic steps required to add new data nodes to an NDB ...