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/precision-math-expressions.html
(See Section 5.1.10, “Server SQL Modes”.) The following discussion mentions strict mode (selected by the STRICT_ALL_TABLES or STRICT_TRANS_TABLES mode values) and ERROR_FOR_DIVISION_BY_ZERO. To turn on all restrictions, you can simply use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. REMAINING_DELAY If the replica is waiting for DESIRED_DELAY seconds to pass since the source applied an event, this field contains the number of delay seconds ...The ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
The following checks are made when Group Replication is deployed in multi-primary mode: If a transaction is executed under the SERIALIZABLE isolation level, then its commit fails when synchronizing itself with the group. If a transaction executes ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-failover.html
Executing the entire transaction history can be time-consuming when the source server has processed a large number of transactions previously, and this can represent a major bottleneck when setting up a new replica. Copying over binary logs to the ...The easiest way to reproduce all identifiers and transactions on a new server is to make the new server into the replica of a source that has the entire execution history, and enable global transaction identifiers on both ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multicurve.html
A MultiCurve is a geometry collection composed of Curve elements. A MultiCurve is simple if and only if all of its elements are simple; the only intersections between any two elements occur at points that are on the boundaries of both elements. A ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 5.4.2, “The Error Log”). Server Error Message Reference provides ...When ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Can a table have multiple ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. You can monitor these status variables to access runtime performance characteristics. mysqld, also known as MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-server-states.html
Table 17.1 Server State Field Description Group Synchronized ONLINE The member is ready to serve as a fully functional group member, meaning that the client can connect and start executing transactions. Whenever there is an error on the recovery ...