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/innodb-information-schema-metrics-table.html
The TIME_ENABLED and TIME_ELAPSED values indicate when the counter was last enabled and how many seconds have elapsed since that time. Note Because each counter adds a degree of runtime overhead, use counters conservatively on production servers to ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
WAIT_FOR_EXECUTED_GTID_SET(): Waits until all transactions in a given GTID set have been executed. To perform the same check with GTID_SUBTRACT(), execute the following statement on the replica: SELECT GTID_SUBTRACT(source_gtid_executed, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Using any value other than 0 or 1 results in a syntax error. The effect of using ... NDB_COLUMN ...
https://dev.mysql.com/doc/refman/5.7/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/deallocate-prepare.html
Attempting to execute a prepared statement after deallocating it results in an error. {DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The table_id column value is unique at any given time, but can be reused if the corresponding object has been deleted. Generally, such a refusal is due to duplicate keys (inserts), Key not found errors (updates, deletes, and reads), or the operation ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
In MySQL, it can produce nondeterministic results because f() might be executed a different number of times for different executions of a given query depending on how the optimizer chooses to handle it. FROM t...) AS dt ...); Here the result from ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
The error message looks like this: InnoDB: Error: table test/parent already exists in InnoDB internal InnoDB: data dictionary. You can drop the orphan table by following the instructions given in the error message. [ERROR] InnoDB: The error means ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
No warnings or errors are issued by the server if a variable has the wrong type or has previously not been assigned a value. This also means the user is fully responsible for any typographical errors, since no warnings are given if (for example) ...
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.