Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
MySQL HeatWave Cluster enables you to perform real-time analytics and machine learning on the structured data residing in the DB System. The hybrid approach achieves the benefits of columnar format for query processing, while avoiding the ... MySQL ...MySQL HeatWave consists of a massively parallel, high-performance, in-memory query accelerator that improves query performance by orders of ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
If you change the grant tables directly (for example, by using INSERT, UPDATE, or DELETE statements) and your changes seem to be ignored, remember that you must execute a FLUSH PRIVILEGES statement or a mysqladmin flush-privileges command to cause ...If the server was started with the bind_address system variable set to 127.0.0.1, it listens for TCP/IP connections only locally on the loopback interface and does not accept remote ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
START REPLICA with no thread type options starts all of the replication threads, and so does START REPLICA with both of the thread type options. IO_THREAD starts the replication receiver thread, which reads events from the source server and stores ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/myai-installation-clean.html
Run the MySQL AI installer to install and configure MySQL AI server and tools. The MySQL AI installer can be run in the following ways: GUI Installer: a graphical installer which enables you to configure and install MySQL AI. See MySQL AI GUI ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
If binary logging is enabled (log_bin is ON), for the InnoDB storage engine only, the server updates the mysql.gtid_executed table in the same way as when binary logging or replica update logging is disabled, storing the GTID for each transaction at ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-network-config-ibr-privatelink.html
Under VPC, select the VPC in which the service is located to be included into the Target Group Under Health checks Select TCP for Health check protocol Under Advanced health check settings, select Override, and enter any port number other than the ... Configuring the Network Infrastructure for an Egress PrivateLink 6.2.1 Configuring the Network Infrastructure for an Egress PrivateLink Before creating an Egress PrivateLink, configure the network infrastructure in your AWS ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
For example, SELECT c1 FROM t WHERE c1 BETWEEN 10 and 20 FOR UPDATE; prevents other transactions from inserting a value of 15 into column t.c1, whether or not there was already any such value in the column, because the gaps between all existing ...A ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... This option follows the name of ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small number of tables are modified frequently. As the redo log files grow faster than they can be processed by mysqlbackup, the ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Example: 0x00 -> +00:00:00.000000 DATETIME A date or date and time value. BYTES x x x GEOMETRY BYTES TIME TIME x DATE DATETIME x DATETIME DATETIME x YEAR UINT x x TIMESTAMP DATETIME x SET SET x ENUM ENUM x NULL BYTES BIT BIT x Note The SQL "NULL" ...