Search Results
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting data. However, TRUNCATE TABLE ...Thus, it does not cause ON DELETE triggers to fire, it cannot be performed for InnoDB tables with parent-child foreign key relationships, and it cannot be rolled back like a DML ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE ...For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. TRUNCATE TABLE is treated for purposes of logging and replication as ...However this caused issues when logging or replicating, in STATEMENT or MIXED mode, tables that used transactional storage engines such as InnoDB when the transaction isolation level was READ COMMITTED or READ UNCOMMITTED, which precludes statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
A minimum of two undo tablespaces is required to support automated truncation of undo tablespaces. The initial size may differ when a new undo tablespace is created by a truncate operation. After transactions are completed, the purge system frees ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
This may indicate that the the last binary log file was truncated or lost, e.g., after a power failure when sync_binlog != 1. Error number: 6052; Symbol: ER_LH_WARN_EXCEEDS_MIN_TRUNCATING; SQLSTATE: HY000 Message: Column %d of %s : %s exceeds min, ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
The following conditions apply when altering the innodb_buffer_pool_chunk_size value: If innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances is larger than the current buffer pool size when the buffer pool is initialized, ... InnoDB Startup ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
The maximum absolute value for D is 30; any digits in excess of 30 (or -30) are truncated. The data type returned by ROUND() (and TRUNCATE()) is determined according to the rules listed here: When the first argument is of any integer type, the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
Summary tables that depend on the connection table are implicitly truncated, as described later in this section. In addition, each summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
Also includes the TRUNCATE statement, because it works differently than a DELETE FROM table_name statement, even though the ultimate effect is similar. Also, the InnoDB file-per-table setting can affect the behavior of DROP TABLE and TRUNCATE TABLE ... These terms are commonly used in information about the MySQL database ...