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/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 6.2, “Access Control and Account Management”, and Section 6.2.17, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
A - character between two other characters forms a range that matches all characters from the first character to the second. Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
BUFFERED_EPOCHS_OVER_THRESHOLD: Whether the number of buffered epochs has exceeded the configured threshold. The report is generated every second until the number of buffered epochs goes below the threshold, which can be adjusted by setting the ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
DATETIME is packed more efficiently, requiring 5 rather than 8 bytes for the nonfractional part, and all three parts have a fractional part that requires from 0 to 3 bytes, depending on the fractional seconds precision of stored values. Fractional ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
Time The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. SHOW [FULL] PROCESSLIST ...For a comparison of this statement with other sources, see Sources of Process ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
When XA COMMIT or XA ROLLBACK is issued, a second part of the transaction containing only the XA COMMIT or XA ROLLBACK statement is written using a second GTID. If there is an unexpected halt while the server is in the middle of executing an XA ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At ...RESIGNAL makes it possible to both handle an error and return the error ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The keyword STACKED means to retrieve information from the second diagnostics area, which is available only ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...