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/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...Any non-NULL cost estimate specified in the tables takes precedence over the corresponding compiled-in default cost ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 9.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... A schema mismatch ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. --connect-retries Command-Line Format ...Usage ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by the triggering event. MySQL handles errors during trigger execution as ...It ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
group_replication_components_stop_timeout Command-Line Format --group-replication-components-stop-timeout=# Introduced 5.7.17 System Variable group_replication_components_stop_timeout Scope Global Dynamic Yes Type Integer Default Value 31536000 ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, sufficient for the data transfer to complete. In this case, if your connect_timeout value is set to only a few ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
MAX_TIMER_WAIT The maximum wait time of the summarized timed wait events. Because waits are timed in picoseconds (trillionths of a second) by default, wait times are divided by 1000000000 to show wait times in milliseconds. A mutex is a ...The ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
This warning does not terminate the procedure, so execution continues and p() then signals an error. The following statements cause that error because the named condition is associated with a MySQL error number: DECLARE no_such_table CONDITION FOR ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...To retrieve information from the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
If a row does not exceed the maximum row length, all of it is stored locally within the page. If a row exceeds the maximum row length, variable-length columns are chosen for external off-page storage until the row fits within the maximum row length ...(These segments are different from the rollback segment, which actually contains many tablespace segments.) When a segment grows inside the tablespace, InnoDB allocates the first 32 pages to it one at a ...