Search Results
https://dev.mysql.com/doc/internals/en/transactions-current-situation.html
Technically, a statement transaction can be viewed as a transaction which starts with a savepoint which MySQL maintains automatically, in order to make the effects of one statement atomic. Since MySQL supports pluggable storage engine architecture ... Nowadays a statement transaction is started for each statement that accesses transactional tables or uses the binary ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-overview.html
This connector differs in a number of key respects from most other MySQL Connectors and APIs. The mysql driver uses a MySQL Server for its data source, and depends on the node-mysql Node.js module from https://github.com/felixge/node-mysql/. In ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-22.html
(Bug #31248601) Functionality Added or Changed Revisions to the MySql.Data.EntityFrameworkCore namespace reduced the number of public classes. (Bug #31353208) Previously, the client-side mysql_clear_password authentication plugin was not supported.
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-31.html
The EMTrace project implements a trace-listener plugin that feeds data back to MySQL Enterprise Monitor using a REST server endpoint. (WL #15158) The MySql.Data.MySqlClient.Memcached namespace and its members now are removed. (Bug #107618, Bug ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-manage-access.html
MySQL HeatWave is designed as a pluggable engine for the DB System. You can manage the DB System and MySQL HeatWave Cluster using the same interface. MySQL HeatWave supports multiple ways of managing the service: Using a web-based cloud console.
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet Delta lake tables (as of MySQL 9.5.0) Supported File Formats for Unstructured Data A Vector ...To load unstructured data, see Ingest Files into a Vector ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
MySQL also supports setting the histogram of a single column to a user-defined JSON value. MySQL uses the stored key distribution to decide the order in which tables should be joined for joins on something other than a constant. In the few cases ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. Automated configuration is intended for MySQL instances that reside on a server dedicated to MySQL, where the MySQL ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
See Section 27.2, “Using Stored Routines” and Adding Functions to MySQL for more information. (Although you must handle backups and storage issues yourself in this case.) If you need really high speed, look at the low-level MySQL interfaces. For ... This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help ...