Search Results
https://dev.mysql.com/doc/refman/8.4/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT 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 ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
If the constant has more significant fractional digits than column's type, truncate the constant. If the operator is >= or <=, adjust the operator due to truncation. If the value has more than n decimals, truncate, compensating during folding.
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
In typical load operations for data warehousing, if something goes wrong, you truncate the table (using TRUNCATE TABLE) and start over from the beginning rather than doing a ROLLBACK. In contrast with the InnoDB system tablespace, file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
To delete all rows from a MyISAM table, TRUNCATE TABLE tbl_name is faster than DELETE FROM tbl_name. Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
Changing the cache size at runtime causes an implicit host cache flushing operation that clears the host cache, truncates the host_cache table, and unblocks any blocked hosts; see Flushing the Host Cache. Execute a TRUNCATE TABLE statement that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
To exclude this data, you can truncate the events_waits_summary_global_by_event_name table immediately after startup and before running your workload. However, the truncate operation itself may produce a negligible amount wait event data. A mutex ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
Because of this, the transactional behavior of a number of MySQL statements is affected as described in the following list: TRUNCATE TABLE is not transactional when used on NDB tables. If a TRUNCATE TABLE fails to empty the table, then it must be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
ndb_restore reports any truncation of data that it performs during lossy conversions once per attribute and column. Such values are truncated to the first 256 bytes in the output. The NDB Cluster restoration program is implemented as a separate ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
After making instrumentation changes, you might want to truncate the summary tables. Exceptions to this truncation behavior are noted in individual summary table sections. Pre-filtering is done by the Performance Schema and has a global effect that ...