Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance_schema_session_connect_attrs_lost The number of connections for which connection attribute truncation has occurred. For a given connection, if the client sends connection attribute key-value pairs for which the aggregate size is larger ...Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
In strict mode, inserting a value that is out of range for a column causes an error, rather than truncation to a legal value. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
After each transaction is committed, the binary log cache is reset by clearing the memory buffer and truncating the temporary file if used. After each transaction is committed, the binary log statement cache is reset by clearing the memory buffer ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
row *************************** Level: Warning Code: 1265 Message: Data truncated for column 'b' at row 1 *************************** 2. SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
session_connect_attrs_lost Performance_schema_session_connect_attrs_lost ASYNC COUNTER The number of connections for which connection attribute truncation has occurred socket_classes_lost Performance_schema_socket_classes_lost ASYNC COUNTER How many ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
InnoDB: The MySQL truncate undo operation (purge thread) did not remove the undo_{space_number}_trunc.log file when attempting to truncate the undo tablespace. (Bug #36301441) Audit log filtering by type, using error as the type, did not work ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-validate.html
mysqlbackup [STD-OPTIONS] [--backup-dir=PATH][--backup-image=IMAGE] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS] [CLOUD-STORAGE-OPTIONS] validate validate Verifies that a backup is not corrupted, truncated, or damaged. If a backup has been ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
240426 13:01:24 RDR1 INFO: Truncating binary log index '/home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir/binlog.index' to 16. In the following illustration, we back up an entire MySQL instance to a single file using the backup-to-image ...