Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/en/performance-schema-system-variables.html
If the aggregate size of connection attribute data sent by a client is larger than this amount, the Performance Schema truncates the attribute data, increments the Performance_schema_session_connect_attrs_lost status variable, and writes a message ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
TIME_TRUNCATE_FRACTIONAL Control whether rounding or truncation occurs when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column having the same type but fewer fractional digits. When strict mode is not enabled, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Configuration Options format_statement() operation can be modified using the ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
If the recursive part of a CTE produces wider values for a column than the nonrecursive part, it may be necessary to widen the column in the nonrecursive part to avoid data truncation. Consequently, the wider str values produced by the recursive ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
MYSQL_NO_DATA Success, no more data exists MYSQL_DATA_TRUNCATED Data truncation occurred MYSQL_DATA_TRUNCATED is returned when truncation reporting is enabled. To determine which column values were truncated when this value is returned, check the ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
(There can be space truncation if keyseg->flag HA_SPACE_PACK flag is on.) For fixed-row tables: The pointer is a fixed-size (4-byte) number which contains an ordinal row number. A .MYI file for a MyISAM table contains the table's indexes. The .MYI ...