PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
Pruning can also be applied for tables partitioned on a DATE or DATETIME column when the partitioning expression uses the YEAR() or TO_DAYS() function. In addition, in MySQL 5.7, pruning can be applied for such tables when the partitioning ...The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE mysql_stmt_close() COM_STMT_CLOSE The text protocol. The following discussion refers to the server commands rather than the C API ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
The mutex still functions as a synchronization object (that is, the server continues to function normally), but performance data for it is not collected. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
Rounding behavior for exact-value numbers is well-defined: Rounding behavior (for example, with the ROUND() function) is independent of the implementation of the underlying C library, which means that results are consistent from platform to platform. If the argument to an aggregate function is an exact numeric type, the result is also an exact numeric type, with a scale at least that of the ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
The CHANGE MASTER TO statement does not have this function, so you must be careful to identify the correct location to restart replication at the beginning of an event group. If replication stops due to an issue with an event in a replicated ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
If no other channels (having nonempty names) have been created, replication statements act on the default channel only, so that all replication statements from older replicas function as expected (see Section 16.2.2.2, “Compatibility with Previous ... In MySQL multi-source replication, a replica opens multiple replication channels, one for each replication source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-fractional-seconds.html
On the source, functions that return a result that includes the current time (such as CURTIME(), SYSDATE(), or UTC_TIMESTAMP()) interpret an argument as an fsp value and the return value includes a fractional seconds part of that many digits. On the ... MySQL 5.7 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
Otherwise, statements depending on the local time on the source are not replicated properly, such as statements that use the NOW() or FROM_UNIXTIME() functions. By default, source and replica servers assume that they are in the same time zone. If ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
The auto-skip function for GTIDs means that a transaction committed on the source can be applied no more than once on the replica, which helps to guarantee consistency. The built-in functions GTID_SUBSET() and GTID_SUBTRACT() require GTID sets as ...