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/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...
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/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/disk-issues.html
This makes both the seek and read times better, assuming that the disk is not used for other purposes as well. Striping Striping means that you have many disks and put the first block on the first disk, the second block on the second disk, and the ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
This buffer is refreshed only if more than 0.1 seconds has elapsed since the last time the buffer was read. The data needed to fill the three tables is fetched atomically and consistently and is saved in this global internal buffer, forming a ...
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/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 ...