Search Results
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-13.html
(Bug #28034570, Bug #90887) Setting rewriteBatchedStatements=true and useLocalTransactionState=true caused transactions to be uncommitted for batched UPDATE and DELETE statements. (Bug #27658489, Bug #89948) Rewriting prepared INSERT statements in a ... Version 8.0.13 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-sharing.html
MySQL Router tracks the statements executed by the client and the SQL state of the session to ensure client connections do not lose their session state. Warnings and errors generated by statements are captured and returned when requested by the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Configuring InnoDB Buffer Pool Size Online The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement, allowing you to resize the buffer pool without restarting the server. Status codes include: 0: No Resize ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
If a table containing full-text search (FTS) index is backed up using transportable tablespace (TTS), after it is restored, the FTS index will be corrupted. Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-7.html
It is preferable that SQL statements be used for such operations. (WL #11415) X DevAPI Notes It is now possible to use the Collection interface to create and drop indexes on document collections. This interface supports the operations provided by ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-performanceschema-activity-category.html
Index Stat Lost (Delta) The number of indexes for which statistics were lost. Nested Statement Lost (Delta) The number of stored program statements for which statistics were lost. Prepared Statements Lost (Delta) The number of prepared statements ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
(Bug #27011755, Bug #27720503) Retrieving Query Analyzer data for the Statement details report resulted in resource-intensive index scans on the normalized_statements_by_server_by_schema_data table. As part of the Query Analyzer performance ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-bulk-ingest-limitations.html
Bulk Ingest Limitations 7.2.2.3 Bulk Ingest Limitations The following are some limitations to the Bulk Ingest Feature of MySQL HeatWave on AWS when using the LOAD DATA FROM S3 statement with ALGORITHM=BULK: The target table must be empty. If the ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...