Search Results
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
NdbBlob Class Overview NdbBlob::ActiveHook NdbBlob::blobsFirstBlob() NdbBlob::blobsNextBlob() NdbBlob::close() NdbBlob::getBlobEventName() NdbBlob::getBlobTableName() NdbBlob::getColumn() NdbBlob::getLength() NdbBlob::getNull() ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
For other summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Once that amount of space is used during digest computation, truncation occurs: no further tokens from a parsed statement are collected or figure into its digest value. Consequently, if performance_schema_max_digest_length is less than ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. Truncation is permitted to clear collected events, ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
The table_io_waits_summary_by_table table has these indexes: Unique index on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) TRUNCATE TABLE is permitted for table I/O summary tables. The table_io_waits_summary_by_index_usage table has these indexes: ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-performance-schema.html
Because of this, the Max Latency statistic that is reported per a normalized statement within Query Analyzer is actually the maximum since either the MySQL Server started, or since a TRUNCATE TABLE ... Query Analyzer data is automatically collected ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
Truncate: set to true to enable truncation of text segments that are too large for the embedding model to handle without truncation. Set to false to disable truncation and instead throw an error when a text segment that is too large for the ... This ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
To delete rows from selected partitions, use the TRUNCATE PARTITION option. TRUNCATE PARTITION merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions. Only a single instance of any one of the following ... Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Long values may be truncated as indicated in the element descriptions given later. Long values may be truncated as indicated in the attribute descriptions given later. Long values may be truncated as indicated in the item descriptions given later.