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/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuring-io-capacity.html
Configuring an I/O Capacity Maximum If flushing activity falls behind, InnoDB can flush more aggressively, at a higher rate of I/O operations per second (IOPS) than defined by the innodb_io_capacity variable. The InnoDB master thread and other ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
A replication group is formed by multiple servers and each server in the group may execute transactions independently at any time. However, there may be conflicts between transactions that execute concurrently on different servers. During ... Group ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
On Unix, the mysql client writes a record of executed statements to a history file (see Section 4.5.1.3, “mysql Client Logging”). MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect ...
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/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Without the FOR QUERY n clause, the output pertains to the most recently executed statement. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. Once START SLAVE has been executed, the value of the ...
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/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 ...