Search Results
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. Once the data is collected, you view and monitor the queries, check the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dynamic-query-offload.html
The overhead for more complex queries is also minimal, compared to the time required for query optimisation and subsequent execution. Before MySQL 9.0.0, MySQL HeatWave uses a query cost threshold to choose either INNODB or MySQL HeatWave as the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
This is a one-time operation, performed by executing the following statements, adjusting the .so suffix for your platform as necessary: CREATE FUNCTION keyring_aws_rotate_cmk RETURNS INTEGER SONAME 'keyring_aws.so'; CREATE FUNCTION ...(Its value can ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
On each server, execute the following statement: SET @@global.gtid_mode = ON_PERMISSIVE; On each server, execute the following statement: SET @@global.gtid_mode = OFF_PERMISSIVE; On each server, wait until the global value of gtid_owned is equal to ... This section describes how to disable GTID transactions on servers that are already ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-configuration-file-locations.html
MySQL Router scans for the default configuration files at startup, and optionally loads user-defined configuration files at runtime from the command line. You can alter the default locations at compile time by using the -DROUTER_CONFIGDIR=<path> ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-6.html
Locks can be requested several times for a given find or select statement. These methods can be called after .bind() and before the final .execute(). X DevAPI example: coll.find("'car' IN $.toys").execute(); X DevAPI for C example: res = ...An ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-cluster.html
Each item in the process_host_list consists of the name of a MySQL NDB Cluster process—possibly suffixed with a colon (:) character followed by the process node ID—joined with the name of the host on which it is located using an amphora (@) sign ... create cluster {--package=|-P }package_name {--processhosts=|-R }process_host_list cluster_name [(--import|-m) cluster_name] [--verbose | -v] process_host_list: process_name[:node_id]@host[,process_name@host[,...]] process_name: {ndb_mgmd|ndbd|ndbmtd|mysqld|ndbapi} This command creates a cluster to be managed by the MySQL Cluster ...
https://dev.mysql.com/doc/mysql-installer/en/server-windows-service.html
Alternatively, you can configure MySQL server to run as an executable program that requires manual configuration. On the Windows platform, MySQL server can run as a named service managed by the operating system and be configured to start up ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
With statement-based binary logging, the source server writes the executed queries to the binary log. The default value of max_sort_length is 1024 and can be changed at server startup time or at runtime. For example, the following does not work: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
When executing on the replica, a table lock is taken on all tables involved, and then the rows are applied in batch mode. This can significantly increase the time required to make changes on the replica that match those on the source. When ... MySQL ...