Search Results
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
Although these functions are not deterministic, they are treated as safe for purposes of logging and replication: CONNECTION_ID(), CURDATE(), CURRENT_DATE(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME(), LAST_INSERT_ID(), LOCALTIME(), ... The ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. Here is a simple example that shows data-conversion warnings for INSERT. With strict mode enabled, the ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
write Handler_write ASYNC COUNTER The number of requests to insert a row in a table. rows_deleted Innodb_rows_deleted ASYNC COUNTER The number of rows inserted into InnoDB tables. system_rows_inserted Innodb_system_rows_inserted ASYNC COUNTER Number ... 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/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. Inserts for v2 are checked against its LOCAL check option, then the check recurses to v1 and ...It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
Firewall stored procedures now avoid performing unnecessary combinations of DELETE plus INSERT statements, as well as those of INSERT IGNORE plus UPDATE operations, making them faster and more efficient. (Bug #36293529, WL #15989) When using the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #107991, Bug #34454572) Partitioning: When inserting NOW() into a column not part of the partition key of a partitioned table, all partitions were retrieved, and no pruning occurred. (Bug #37370439) An UPDATE subsequent to an INSERT affecting a ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
For example, the mysqlbackup command can log into the server being backed up to insert and update data in the progress table and the history table. The database might be entirely shut down, or in a read-only state when applications are attempting to ... These terms are commonly used in information about the MySQL Enterprise Backup ...