Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-variables.html
For a given connection, if the client sends connection attribute key-value pairs for which the aggregate size is larger than the reserved storage permitted by the value of the performance_schema_session_connect_attrs_size system variable, the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-group-stats-table.html
This number is incremented when a statement starts executing, not when it finishes. The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. QUERIES_QUEUED The number of statements received that were queued for execution.
https://dev.mysql.com/doc/refman/9.7/en/replace.html
There are no user-visible effects other than a possible difference in how the storage engine increments Handler_xxx status variables. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-binlog-encryption-encryption-keys.html
{SEQ_NO} is the sequence number for the binary log encryption key, which is incremented by 1 for each new key that is generated on the server. It automatically generates a new binary log encryption key using its own generated UUID, and uses this to ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.5, “The MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-reference.html
max_relay_log_size: If nonzero, relay log is rotated automatically when its size exceeds this value. relay_log_recovery: Whether automatic recovery of relay log files from source at startup is enabled; must be enabled for crash-safe replica. The ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-recover.html
For instructions to do this, see Section 9.5, “Point-in-Time (Incremental) Recovery”. To skip a transaction, if GTIDs are in use, commit an empty transaction that has the GTID of the failing transaction, for example: SET ... If a privilege check ...
https://dev.mysql.com/doc/refman/9.7/en/show-status.html
Each invocation of the SHOW STATUS statement uses an internal temporary table and increments the global Created_tmp_tables value. SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] SHOW STATUS provides server status information (see ...
https://dev.mysql.com/doc/refman/9.7/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented.
https://dev.mysql.com/doc/refman/9.7/en/which-version.html
This is incremented for each new LTS release, but is likely always 0 for innovation releases. When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install from an LTS ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/advanced.source.html
To fix a corruption problem in a replication source database, you can restore the backup, taking care not to propagate unnecessary SQL operations to the replica servers: Shut down the source database and then use, for example, the ...