PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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. Although TRUNCATE TABLE is similar to DELETE, it is classified as a DDL statement rather than a DML statement.
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/innodb-undo-tablespaces.html
Truncating Undo Tablespaces Truncating undo tablespaces requires that the MySQL instance have a minimum of two active undo tablespaces, which ensures that one undo tablespace remains active while the other is taken offline to be truncated. Use this ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/5.7/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, ... System ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
The maximum absolute value for D is 30; any digits in excess of 30 (or -30) are truncated. mysql> SELECT TAN(PI()); -> -1.2246063538224e-16 mysql> SELECT TAN(PI()+1); -> 1.5574077246549 TRUNCATE(X,D) Returns the number X, truncated to D decimal ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
disabled_storage_engines does not restrict other DDL statements for existing tables, such as CREATE INDEX, TRUNCATE TABLE, ANALYZE TABLE, DROP TABLE, or DROP TABLESPACE. Changing the size at runtime causes an implicit host cache flushing operation ... The MySQL server maintains many system variables that affect its ...