PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
In strict mode, inserting a value that is out of range for a column causes an error, rather than truncation to a legal value. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. The IS_UPDATABLE column in the VIEWS table displays the ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
An UPDATE statement involving a temporary table with a join on a non-temporary table having a trigger defined on it can result in an error, even though the update statement reads only the non-temporary table, in the following cases: With read-only ...In an UPDATE statement, columns are updated from left to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html
On each server, execute: SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = ON; On each server, execute: SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE; It does not matter which server executes this statement first, but it is important that all servers complete this ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
If backed-up log files are encrypted, also back up the corresponding encryption passwords to a safe place, should you need to decrypt the files later. This section describes how to configure audit logging characteristics, such as the file to which ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
It is safe to reduce TIME_WAIT greatly on LAN connections because there is little chance of packets arriving at very long delays, as they could through the Internet with its comparatively large distances and latencies. A MySQL client on Unix can ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-create.html
Provided that the write error is to a test file, the error is not serious and can be safely ignored. If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. Tablespace keys are decrypted at the donor before transport and re-encrypted at the ...