Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-refreshing-lakehouse-data.html
The DB System that your MySQL HeatWave Cluster is associated with must be running MySQL 9.0.0 or later. Do the following to refresh your Lakehouse data with a Lakehouse Incremental Load: Connect to the DB System that is associated with the Lakehouse ... Refreshing Lakehouse Data 9.3 Refreshing Lakehouse Data The MySQL HeatWave Lakehouse tables contain a snapshot of your data in Amazon S3 at the time you loaded the data into your MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
To run a query using the Query Editor: Connect to a DB System. Query Editor Limitations The Query Editor has the following limitations: It is not intended for loading data into a DB System. More efficient methods of loading data into a DB System are ... Running Queries 10 Running Queries The Workspace tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and MySQL HeatWave ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The second example shows how you can retrieve the same value using a standard SELECT ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. To create a Statement instance, you call the createStatement() method on the Connection object you have ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-hosts.html
Do not use localhost in the host list, as MySQL Cluster Manager relies on the operating system for host name resolution, and localhost might be resolved differently on different systems. When IPv6-enabled Windows systems are used as MySQL NDB ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-update-process.html
The process is a node that has been stopped by mcmd but, for some reasons, its PID remains valid with the operating system. Both the process's ID in the cluster (process_id) and its PID on the operating system (specified with the --pid option) are ... update process [--remove-angel] --pid=os_pid process_id cluster_name This command updates the status of the MySQL NDB Cluster process having the process ID process_id in the cluster named cluster_name when the status of the process is no longer reflected correctly in the output of the show status --process ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-procedure.html
Any cluster processes that are under the control of the system's boot-time process management facility, such as /etc/init.d on Linux systems or the Services Manager on Windows platforms, should be removed from its control. Create and configure ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-compressed-data.html
The following requirements apply when cloning remote data: The recipient file system must support sparse files and hole punching for hole punching to occur on the recipient. The donor and recipient file systems must have the same block size. If file ...For information about the page compression feature, see Section 17.9.2, “InnoDB Page ...
https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. ST_IsClosed() handles its arguments as described in the introduction to this section, with this ...You ...
https://dev.mysql.com/doc/refman/9.7/en/gis-polygon-property-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. These functions are available for obtaining polygon properties: ST_Area({poly|mpoly}) Returns a ...