Search Results
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
The remaining rare cases, when the server explicitly must commit a statement transaction prior to committing a normal transaction, are error-handling cases (see for example SQLCOM_LOCK_TABLES). For example, imagine that some day MySQL supports ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndb-cluster-connection.html
For more information, see Defining SQL and Other API Nodes in an NDB Cluster. You can use the ndb_data_node_neighbour server system variable to set a data node neighbor for an NDB Cluster SQL node. This section provides information about the ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-29.html
Pluggable Authentication Security Notes X DevAPI Notes Functionality Added or Changed Bugs Fixed Pluggable Authentication Connector/C++ now supports authentication to MySQL Server using devices such as smart cards, security keys, and biometric ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-nl2ml.html
MySQL 9.4.0 introduces the NL2ML (natural language to machine learning) routine, which provides step-by-step guidelines on using MySQL HeatWave AutoML for a particular business problem. Use this routine to ask general questions about MySQL HeatWave ...Note Oracle Cloud Infrastructure Generative AI is available in specific ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica servers. MySQL offers a variety of backup strategies from which you can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
ndbinfo is included with NDB Cluster support in the MySQL Server; no special compilation or configuration steps are required; the tables are created by the MySQL Server when it connects to the cluster. row *************************** Engine: ndbinfo ... ndbinfo is a database containing information specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
Optimizer Hint Syntax MySQL supports comments in SQL statements as described in Section 11.7, “Comments”. Duplicate hints: For a hint such as /*+ MRR(idx1) MRR(idx1) */, MySQL uses the first hint and issues a warning about the duplicate hint.
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
Use SHOW ENGINE PERFORMANCE_SCHEMA STATUS to inspect the internal operation of the Performance Schema code: mysql> SHOW ENGINE PERFORMANCE_SCHEMA STATUS\G ... In general, one of these is created each time a data manipulation statement is performed ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
It is part of the SQL standard, but the MySQL implementation permits only RESPECT NULLS (which is also the default). from_first_last is part of the SQL standard, but the MySQL implementation permits only FROM FIRST (which is also the default). This ...