Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
If attribute size exceeds this value, these actions take place: The Performance Schema truncates the attribute data and increments the Performance_schema_session_connect_attrs_lost status variable, which indicates the number of connections for which ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
(If strict SQL mode is not enabled, truncation for INSERT is permissible.) Handling of a numeric expression depends on what kind of values the expression contains: If any approximate values are present, the expression is approximate and is evaluated ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
It is also possible to specify whether or not to permit lossy (truncated) or non-lossy conversions of demoted column values, as explained later in this section. If we permit the conversion but truncate (or otherwise modify) the source value to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Default frequency 06:00:00 Default auto-close enabled yes InnoDB Status Truncation Detected InnoDB primarily uses the SHOW ENGINE INNODB STATUS command to dump diagnostics information. You are running a version where the truncation limit should be 1 ...However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
Warning 6057 Row 13, char 1, column 1 of {object: "mtrtest/datalake_int_basic/0.tbl" in namespace: "OCI_OBJECT_STORE_SOURCE_NAMESPACE", bucket: "OCI_OBJECT_STORE_SOURCE_BUCKET"} at byte offset 66 : Integer value was truncated. As of MySQL 9.0.1-u1, ... See MySQL 9.5 Error Message Reference for Lakehouse error ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR 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 ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Performance When you do not need to know the number of deleted rows, the TRUNCATE TABLE statement is a faster way to empty a table than a DELETE statement with no WHERE clause. Unlike DELETE, TRUNCATE TABLE cannot be used within a transaction or if ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”. This section describes how to configure MySQL Enterprise Firewall using SQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
Note When undo log encryption is disabled, the server continues to require the keyring component or plugin that was used to encrypt undo log data until the undo tablespaces that contained the encrypted undo log data are truncated. (An encryption ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Disk space is returned to the operating system after truncating or dropping a table created in a file-per-table tablespace. Truncating or dropping a table stored in a shared tablespace creates free space within the shared tablespace data file, which ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...