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/diagnostics-area.html
Standard SQL also supports GET STACKED DIAGNOSTICS syntax for referring to the second diagnostics area during condition handler execution. Execution of RESIGNAL The RESIGNAL statement passes on the error condition information that is available ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down ...(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. An ...It ...
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/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/condition-filtering.html
To the extent that the optimizer can use information about conditions on rows selected from one table and passed to the next, the more accurately it can compute row estimates and choose the best execution plan. The maximum value is 100, which means ... In join processing, prefix rows are those rows passed from one table in a join to the ...
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/assignment-operators.html
Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...