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 ...At ... When a new connection is established, thd->transaction members are initialized to an empty ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using.html
The MySQL Query Analyzer enables you to monitor SQL statements executed on a MySQL server and displays the details of each query, number of executions and execution times. Query Analyzer collects information on the SQL statements MySQL client ...By ...Similar queries with different literal values are combined for reporting ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. The dummy process does not actually store any data, so there is little ...To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
This is because the server IDs of replicas must be unique in a replication topology. Important On a MySQL server instance that is configured for Group Replication, channel specific replication filters can be used on replication channels that are not ...For instructions to set up replication channels, see Section 19.1.5, “MySQL Multi-Source Replication”, and for more information on how they work, see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-enterprise-audit.html
MySQL Enterprise Audit 3.1.2.7 MySQL Enterprise Audit MySQL HeatWave on AWS supports the MySQL Enterprise Audit plugin for MySQL Server 8.1.0 and later. The audit plugin enables the MySQL Server to produce a log file containing an audit record of ...You can add statistics for the time and size of the queries to detect ...The log contents can include information such as when clients connected and disconnected, what actions ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. INFORMATION_SCHEMA Name SHOW Name Remarks mysql_connection_id MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-security.html
MySQL Enterprise Edition provides plugins that implement security features using external services: MySQL Enterprise Edition includes an authentication plugin that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) to ...MySQL ...LDAP Authentications supports user name and password, SASL, and GSSAPI/Kerberos authentication methods to LDAP ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids.html
In addition, once a transaction with a given GTID is committed on a given server, any subsequent transaction having the same GTID is ignored by that server. This section discusses the following topics: How GTIDs are defined and created, and how they ...Suggested methods for provisioning new replication servers when using GTIDs (see Section 19.1.3.5, “Using GTIDs for Failover and ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). For answers to some questions often asked by those who are new to MySQL Replication, see Section ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbclusterspec.html
mysqlNode (NdbMysqldSpec): (optional) Specification for any MySQL Servers run as NDB Cluster SQL nodes. NDB Operator requires at least one MySQL Server running in the NDB Cluster for internal operations. If none is specified, the operator by default ...With a redundancy level of 2 or higher, the cluster can continue to serve client requests even in the event of node failures; this is the default value, recommended for most ...