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/performance-schema-wait-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
(If strict SQL mode is not enabled, truncation for INSERT is permissible.) Handling of a numeric expression depends on what kind of values the expression contains: If any approximate values are present, the expression is approximate and is evaluated ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
It is also possible to specify whether or not to permit lossy (truncated) or non-lossy conversions of demoted column values, as explained later in this section. If we permit the conversion but truncate (or otherwise modify) the source value to ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For truncation of nonspace characters, you can cause an error to ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
Performance When you do not need to know the number of deleted rows, the TRUNCATE TABLE statement is a faster way to empty a table than a DELETE statement with no WHERE clause. Unlike DELETE, TRUNCATE TABLE cannot be used within a transaction or if ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
Disk space is returned to the operating system after truncating or dropping a table created in a file-per-table tablespace. Truncating or dropping a table stored in a shared tablespace creates free space within the shared tablespace data file, which ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
Purge and Undo Tablespace Truncation The purge system is also responsible for truncating undo tablespaces. You can configure the innodb_purge_rseg_truncate_frequency variable to control the frequency with which the purge system looks for undo ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
The value in effect for CREATE TABLE, or a subsequent ALTER TABLE or TRUNCATE TABLE, is the value used for the life of the table. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
A DROP TABLE or TRUNCATE TABLE operation on an NDB table frees the memory that was used by this table for re-use by any NDB table, either by the same table or by another NDB table. Note Bulk loading, TRUNCATE TABLE, and ALTER TABLE are handled as ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 12.21.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...