Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-edit.html
The maintenance window is a two-hour period specified in Coordinated Universal Time, UTC. The time required to apply patches and updates may extend beyond the maintenance window and require a DB System restart. Select Automatic for MySQL HeatWave on ... Editing a DB System 3.4.3 Editing a DB System Use the MySQL HeatWave Console to edit details of a DB System and various options for ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table.
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you connect to the server (see Client Program Connection Character Set Configuration). Connect-Time Error ...The ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
gtid_executed_compression_period Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
DATE DATE DATETIME DATETIME DATETIME2 DATETIME Date range in MySQL is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'. Note: fractional second values are only stored as of MySQL Server 5.6.4 and higher. SMALLDATETIME DATETIME ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-priority-queue.html
If a query does raise an out of memory error, the scheduler runs the query a second time in isolation. The scheduling mechanism prioritizes short-running queries but considers wait time in the queue so that costlier queries are eventually scheduled ... MySQL HeatWave uses a workload-aware, priority-based, automated scheduling mechanism to schedule concurrently issued queries for ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
DATE DATE TIME TIME TIMESTAMP DATETIME INTERVAL TIME BYTEA LONGBLOB TEXT LONGTEXT CIDR VARCHAR(43) INET VARCHAR(43) MACADDR VARCHAR(17) UUID VARCHAR(36) XML LONGTEXT JSON LONGTEXT TSVECTOR LONGTEXT TSQUERY LONGTEXT ARRAY LONGTEXT POINT POINT LINE ...
https://dev.mysql.com/doc/internals/en/debug-sync-point.html
open_tables(...) DBUG_SYNC_POINT("debug_lock.after_open_tables", 10); lock_tables(...) The synchronization points behave similar to RELEASE_LOCK(<whatever the thread has>); IS_FREE_LOCK(str) OR (GET_LOCK(str,timeout) AND RELEASE_LOCK(str)) This ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-java.html
A NDB Cluster is defined as one or more MySQL Servers providing access to an NDBCLUSTER storage engine—that is, to a set of NDB Cluster data nodes (ndbd processes). There are three main access paths from Java to NDBCLUSTER, listed here: JDBC and ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
If a locking statement executes while a different transaction holds the same lock, it blocks until the other transaction releases it. Locking considerations When working with locking modes note the following: autocommit mode means that there is ...